Pulling the price of the ETF or Stock for the date

[Chris White]

For a future upgrade, would you consider pulling in the Price of the ETF or Stock for the date in question?

I really like the program!
Jim.

[Chris White]

Hi Jim,

I’m glad you like the program.

Regarding your suggestion, if I understand correctly, you would like to see the price displayed in one of the columns? If so, that is already possible by adding a column formula of CLOSE and naming the cell ERF_XX:

Remember to add it to the ‘System’ worksheet and then also add the column to the ‘Formatted System’ worksheet so the values get copied to the correct column.

Here’s the System worksheet after the template has been run:

The 'System' worksheet in the Leveraged ETFs Signals Template

system_worksheet.png (20.64 KiB) Viewed 15188 times

And here’s the Formatted System worksheet:

The 'Formatted System' worksheet in the Leveraged ETFs Signals Template

formattedsystem_worksheet.png (19.76 KiB) Viewed 15188 times

Also remember that in order to modify a template it should be copied to the 'My Templates' folder first. Instruction for that are contained in the following video:

http://youtu.be/qB_8E5zeLkk

Chris.