Home Home
Yahoo Stock Quotes E-mail

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 SpreadsheetRegister

Yahoo Stock Quotes

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.

Yahoo Stock Quotes

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.
 

Market Updates

Currency Converter

Convert 

into