Hi Gang, Sometimes my curiosity gets me and I was looking at the Gummy AIM.xls wondering how to add commission costs to the way it is done. Took a bit of fiddling but eventually got it. But along the way came across a an Excel formula I did not understand.
=Units*Price+Q$8:Q$65536 - It is the Q$8:Q$65536 part I don't get. Can anyone explain?
The I got to fiddling around and wondered how it was getting it's data from Yahoo and if one could get weekly and daily as well as monthly.
Monthly: chart.yahoo.com/table.csv?s=GM&a=3&b=13&c=2015&d=3&e=14&f=2017&g=m&q=q&y=0&z=GM&x=.csv
Weekly: chart.yahoo.com/table.csv?s=GM&a=3&b=13&c=2015&d=3&e=14&f=2017&g=w&q=q&y=0&z=GM&x=.csv
Daily: chart.yahoo.com/table.csv?s=GM&a=3&b=13&c=2015&d=3&e=14&f=2017&g=d&q=q&y=0&z=GM&x=.csv
The bold and italic black is the stock symbol and the red is where the change is for monthly, weekly, and daily. The other parts, a=3&b=13&c=2015&d=3&e=14&f=2017, are for the dates with the first part for the starting month, day, and year while the second part is for the end month, day, and year point for the data.
Hope this proves useful.
Best,
Allen