Some time ago I was using a spreadsheet that could grab certain bits of Yahoo finance data right from a cell formula. I can't find my spreadsheet and I can't find anything on the Yahoo Finance web site. Anyone know how to do this or have a link to Yahoo's instructions? Thanks
im me I send you the code via email or download... P.S. it is not a cell formula however but VBA code
oil trader, the way I had it set up was the cell contained a certain URL of Yahoo Finance, along with the symbol and a constant which specified the type of data (close, volume, float, etc)
Glad to help Bundle. You might find the following useful as well. - Spydertrader http://dirk.eddelbuettel.com/code/yahooquote.html The full list of available fields, along with their query format symbols is : Symbol s Name n Last Trade (With Time) l Last Trade (Price Only) l1 Last Trade Date d1 Last Trade Time t1 Last Trade Size k3 Change and Percent Change c Change c1 Change in Percent p2 Ticker Trend t7 Volume v Average Daily Volume a2 More Info i Trade Links t6 Bid b Bid Size b6 Ask a Ask Size a5 Previous Close p Open o Day's Range m 52-week Range w Change From 52-wk Low j5 Pct Chg From 52-wk Low j6 Change From 52-wk High k4 Pct Chg From 52-wk High k5 Earnings/Share e P/E Ratio r Short Ratio s7 Dividend Pay Date r1 Ex-Dividend Date q Dividend/Share d Dividend Yield y Float Shares f6 Market Capitalization j1 1yr Target Price t8 EPS Est. Current Yr e7 EPS Est. Next Year e8 EPS Est. Next Quarter e9 Price/EPS Est. Current Yr r6 Price/EPS Est. Next Yr r7 PEG Ratio r5 Book Value b4 Price/Book p6 Price/Sales p5 EBITDA j4 50-day Moving Avg m3 Change From 50-day Moving Avg m7 Pct Chg From 50-day Moving Avg m8 200-day Moving Avg m4 Change From 200-day Moving Avg m5 Pct Chg From 200-day Moving Avg m6 Shares Owned s1 Price Paid p1 Commission c3 Holdings Value v1 Day's Value Change w1, Holdings Gain Percent g1 Holdings Gain g4 Trade Date d2 Annualized Gain g3 High Limit l2 Low Limit l3 Notes n4 Last Trade (Real-time) with Time k1 Bid (Real-time) b3 Ask (Real-time) b2 Change Percent (Real-time) k2 Change (Real-time) c6 Holdings Value (Real-time) v7 Day's Value Change (Real-time) w4 Holdings Gain Pct (Real-time) g5 Holdings Gain (Real-time) g6 Day's Range (Real-time) m2 Market Cap (Real-time) j3 P/E (Real-time) r2 After Hours Change (Real-time) c8 Order Book (Real-time) i5 Stock Exchange x
Hi, I saw your post and by coincidence have just finished making myself an online trade monitor sheet. I have uploaded it to my website on the downloads page if its any help to you. www.precisiontradingsystems.com If anyone knows how to make the updates more crisp, (as mine becomes slow once more than 20 symbols are added) then please let me know
It should work the same as the example sheet I posted on my website, providing the tables in the webpage are accessable, the little yellow arrows will show what can be extracted and what cant. I posted up instructions for people to read, I dont know if you tried it? I am not a subcriber to IBD so I cant test it but if you send me your log in details to the email address on my site, I will try it for you. Or you can read the instructions on my downloads page on my site, www.precisiontradingsystems.com