UnThreaded | Threaded | Whole Thread (3) | Ignore Thread Prev | Next
Author: StevnFool Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: of 243410  
Subject: Re: Web Query in Excel XP Date: 3/31/2003 10:38 AM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Recommendations: 2
I don't know if you got a satisfactory response to your message, but
I use XP and the following should work.

If it is the last price you want, cut and paste the text between the
"***" symbols into a file with a ".iqy" extension and it should work.
The actual data returned is determine by the "&f=l1" part of the URL.
If you want different data, you will need to replace the "l1" with
a different "Yahoo format code".  There is a list at the bottom of
this message.  You can combine more than one format code for example
"&f=l1p2" returns the last price and the % change separated by a comma.
You will then need to convert text to column's based on comma separation.

I am posting this here as others may find it useful

Regards
StevnFool

***
WEB
1
http://quote.yahoo.com/d/quotes.csv?s=["QUOTE","Enter stock symbols separated by commas."]&f=l1&ext=.csv

Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
CommaDelimiter = True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
***

 ==================================
 Yahoo format codes
 ==================================
a  Ask Price
a2 Average Daily Volume
b  Bid Price
c,c2,c5 change string with "-" that Excel takes as a formula
c  change (percent)
c1 change (dollars)
c4 Currency code (USD, CAD, etc)
c5 - code "c" plus html italic codes and
d  Div/share
d1 date
e  Earnings/share
e2 Option settlement date (often Saturday)
e3 Option last trade date, text with day-of-week
e4 Option date - sometimes settlement, sometimes first of month
e7 Estimated earnings
g  Low today
h  High today
i  More Info
j  52-week low
j1 Market Capitalization
j2 Common Shares Outstanding
k  52-week high
l1 Last Trade (Price Only)
n  Name (full company name)
n2 New Highs
n3 New Lows
n4 Notes
o  Open
o1 Open Interest (Options only)
p  Prev. close
p2 % change
q  Ex-Dividend Date
r  P/E Ratio
r1 Dividend Pay Date
s  Symbol
t1 time of last trade
v  volume
w1 Last trade change
x  exchange name
y  Dividend Yield
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Print the post  
UnThreaded | Threaded | Whole Thread (3) | Ignore Thread Prev | Next

Announcements

Invest Better Hub
Take advantage of our newest free service, Invest Better!
New Fool-Branded Credit Card Available!
How does your card compare to ours?
Post of the Day:
Berkshire Hathaway

Coolidge Lessons for Today
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
Facebook Fool Fan Club
Be a fan of the Fool over on Facebook!
Community Home
Speak Your Mind, Start Your Blog, Rate Your Stocks

Community Team Fools - who are those TMF's?
Get the Fool Phone App
Save and share content, zero in on sectors, podcasts, and much more!
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and "#1 Media Company to Work For" (BusinessInsider 2011)! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.
Advertisement