|
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
|
|
|
Announcements
|