InvestorsHub Logo
Followers 2
Posts 1185
Boards Moderated 0
Alias Born 07/15/2014

Re: None

Thursday, 08/24/2017 12:46:15 AM

Thursday, August 24, 2017 12:46:15 AM

Post# of 47083
Hi Gang, In digging through some old stuff I came across a potentially useful query.

https://finance.yahoo.com/d/quotes.csv?s=stock symbol+stock symbol+stock symbol+stock symbol+stock symbol+stock symbol+stock symbol&f=sd1t1l1ohgvwdyrc1pjkn

Just replace the red stock symbols with your choice that you want to check. As far as I can tell you can add as many stock symbols as you like. If you only want to check one, just delete the rest, but note that the last one has the ampersand (&) right after it.

The part in green is the following:

s Symbol
d Date
1t Time
1l Close
1o Open
h High
g Low
v Volume
w 52 Week Range Low to High
d Dividend
y Dividend Yield %
r ??? (I have not figured this one out)
c Price Change at the end of the day
1p Previous Close
j 52 Week Low
k 52 Week High
n Company Name

If you set up a spreadsheet with these headings in the first row you can copy the data from the downloaded spreadsheet under them to make it easier to follow what is happening.

Best,

Allen


Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.