|
Yahoo Finance portal provides some URL parameters that you can use to download stock quotes information.
You can download a single stock quote information or you can download several quotes information in just one single URL request.
Before we start, let's take a look at the list of parameters provided by Yahoo Finance.
| a |
Ask |
|
k5 |
% Change from 52-W |
| a2 |
Average Daily Volume |
|
l |
Last Trade with Time |
| a5 |
Ask Size |
|
l1 |
Last Trade (Price Only) |
| b |
Bid |
|
l2 |
High Limit |
| b2 |
Ask (RT) |
|
l3 |
Low Limit |
| b3 |
Bid (RT) |
|
m |
Day's Range |
| b4 |
Book Value |
|
m2 |
Day's Range (RT) |
| b6 |
Bid Size |
|
m3 |
50-Day MA |
| c |
% Change |
|
m4 |
200-D MA |
| c1 |
Change |
|
m5 |
Change from 200-D MA |
| c3 |
Commission |
|
m6 |
% Change from 200-D MA |
| c6 |
Change (RT) |
|
m7 |
Change from 50-D MA |
| c8 |
After Hour Change (RT) |
|
m8 |
% Change from 50-D MA |
| d |
Dividend/Sahre |
|
n |
Name |
| d1 |
Last Trade Date |
|
n4 |
Notes |
| d2 |
Trade Date |
|
o |
Open |
| e |
Earning/Share |
|
p |
Previous Close |
| e1 |
Error Indication |
|
p1 |
Price Paid |
| e7 |
EPS Estimate Current Year |
|
p2 |
Change in % |
| e8 |
EPS Estimate Next Year |
|
p5 |
Price/Sales |
| e9 |
EPS Estimate Next Quarter |
|
p6 |
Price/Book |
| f6 |
Float Shares |
|
q |
Ex-Dividend Date |
| g |
Day's Low |
|
r |
P/E Ratio |
| h |
Day's High |
|
r1 |
Dividend Pay Date |
| j |
52-Week Low |
|
r2 |
P/E Ratio (RT) |
| k |
52-Week High |
|
r5 |
PEG Ratio |
| g1 |
Holding Gain % |
|
r6 |
Price/EPS Estimate Current Year |
| g3 |
Annualized Gain |
|
r7 |
Price/EPS Estimate Next Year |
| g4 |
Holding Gain |
|
s |
Symbol |
| g5 |
Holding Gain % (RT) |
|
s1 |
Shares Owned |
| g6 |
Holding Gain (RT) |
|
s7 |
Short Ratio |
| i |
More Info |
|
t1 |
Last Trade Time |
| i5 |
Order Book (RT) |
|
t6 |
Trade Links |
| j1 |
Market Capitalization |
|
t7 |
Ticker Trend |
| j3 |
Market Cap (RT) |
|
t8 |
1 Year Target |
| j4 |
EBITDA |
|
v |
Volume |
| j5 |
Cahnge from 52-W Low |
|
v1 |
Holding Value |
| j6 |
% Change from 52-W Low |
|
v7 |
Holding Value (RT) |
| k1 |
Last Trade with Time (RT) |
|
w |
52-W Range |
| k2 |
Change % (RT) |
|
w1 |
Day's Value Change |
| k3 |
Last Trade Size |
|
w4 |
Day's Value Change(RT) |
| k4 |
Change from 52-W High |
|
x |
Stock Exchange |
|
|
|
y |
dividend Yeild |
Login or Register to download this Excel Spreadsheet
Let's say that you have the following quotes in your portfolioCAT, WMT, SLB, AAPLYou want to get the Name, Last Price, Last Traded Volume, 52-Week High, 52-Week Low and 50-Day MA.
From the table above, we can find out that the parameters needed are as follow:
Name - n
Last Price- l1
Last Traded Volume - v
52-Week High - k
52-Week Low - j
50-Day MA - m3
All you need to do is to construct the URL with the given parameters above.
The URL will looks like this:
http://quote.yahoo.com/d/quotes.csv?s=CAT WMT SLB AAPL&f= nl1vkjm3
http://quote.yahoo.com/d/quotes.csv? - The default URL to get the information
's=' - Append your stocks information after this
& - to join the string
'f=' - Append the URL parameters after this with no spaces in between
Depends on you Internet browser setting, You maybe asked to save the results into a filename call "quotes.csv" or the follow page will appear in your browser.
The script you have downloaded above will parses Yahoo Finance website base on the parameters you entered, and then import the data into the Excel spreadsheet according to the columns or rows you defined in the script.
What you need to do is to enter the list of the stocks symbol start right from column A7, and then enter your parameters in cell C2 according to the table given above, change the title in the Row 4 and click on the "Execute" button. The script will read the data from the website and then arrange it into the row and column accordingly.
|
