15 New Messages
Digest #2485
Messages
Mon Jan 28, 2013 7:58 am (PST) . Posted by:
"Roger Diaz" rogerdiazbernal
Randy:
Thanks, but
How to create the correct security cookie?
2013/1/28 Randy Harmelink rharmelink@gmail.com >
> create the correct security cookie first,
Thanks, but
How to create the correct security cookie?
2013/1/28 Randy Harmelink rharmelink@gmail.
> create the correct security cookie first,
Mon Jan 28, 2013 9:32 am (PST) . Posted by:
"Randy Harmelink" rharmelink
As noted in the file description: "Note that you need to view an
iVolatility data display from CBOE in either IE or the EXCEL Web Query
process before using the add-in so that the add-in has a security cookie to
be able to access the data."
On Mon, Jan 28, 2013 at 8:57 AM, Roger Diaz rogerdiazb@gmail.com > wrote:
>
> Thanks, but
> How to create the correct security cookie?
>
> 2013/1/28 Randy Harmelink rharmelink@gmail.com >
>
>> create the correct security cookie first,
>>
>
iVolatility data display from CBOE in either IE or the EXCEL Web Query
process before using the add-in so that the add-in has a security cookie to
be able to access the data."
On Mon, Jan 28, 2013 at 8:57 AM, Roger Diaz rogerdiazb@gmail.
>
> Thanks, but
> How to create the correct security cookie?
>
> 2013/1/28 Randy Harmelink rharmelink@gmail.
>
>> create the correct security cookie first,
>>
>
Mon Jan 28, 2013 9:58 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Another possibility -- if you are using version 2.1.2012.12.29 of the
add-in, tell me whether these works for you:
=smfGet888OptionQuote("QQQ","C","2/16/2013",,"HV10L")
=smfGet888OptionQuote("QQQ","C","2/16/2013",,"HV10LD")
If not, visit this web page with IE or the EXCEL Web Query dialog:
http://oic.ivolatility.com/oic_adv_options.j?exp_date=-1&ticker=QQQ
...and then run smfForceRecalculation and try again.
Let me know what happens.
If that does work, you can find documentation for that function in the
"Works in Progress" folder of the files area.
On Sun, Jan 27, 2013 at 11:16 PM, Roger rogerdiazb@gmail.com > wrote:
>
> How I can get the implied volatility of www.ivolatility.com
> i.e. for QQQ
> http://www.ivolatility.com/options.j?ticker=QQQ&R=0&top_lookup__is__sent=1
>
> I need data for: Current / 52wk High Date /52 wk Low Date of IV Index mean
> These data are in Table Implied Volatility / IV Index mean
>
>
add-in, tell me whether these works for you:
=smfGet888OptionQuo
=smfGet888OptionQuo
If not, visit this web page with IE or the EXCEL Web Query dialog:
http://oic.ivolatil
...and then run smfForceRecalculati
Let me know what happens.
If that does work, you can find documentation for that function in the
"Works in Progress" folder of the files area.
On Sun, Jan 27, 2013 at 11:16 PM, Roger rogerdiazb@gmail.
>
> How I can get the implied volatility of www.ivolatility.
> i.e. for QQQ
> http://www.ivolatil
>
> I need data for: Current / 52wk High Date /52 wk Low Date of IV Index mean
> These data are in Table Implied Volatility / IV Index mean
>
>
Mon Jan 28, 2013 10:13 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Actually, those two formulas don't even need the 2nd and 3rd parameters.
They can just be:
=smfGet888OptionQuote("QQQ",,,,"HV10L")
=smfGet888OptionQuote("QQQ",,,,"HV10LD")
On Mon, Jan 28, 2013 at 10:58 AM, Randy Harmelink rharmelink@gmail.com >wrote:
> Another possibility -- if you are using version 2.1.2012.12.29 of the
> add-in, tell me whether these works for you:
>
> =smfGet888OptionQuote("QQQ","C","2/16/2013",,"HV10L")
> =smfGet888OptionQuote("QQQ","C","2/16/2013",,"HV10LD")
>
> If not, visit this web page with IE or the EXCEL Web Query dialog:
>
> http://oic.ivolatility.com/oic_adv_options.j?exp_date=-1&ticker=QQQ
>
> ...and then run smfForceRecalculation and try again.
>
> Let me know what happens.
>
> If that does work, you can find documentation for that function in the
> "Works in Progress" folder of the files area.
>
They can just be:
=smfGet888OptionQuo
=smfGet888OptionQuo
On Mon, Jan 28, 2013 at 10:58 AM, Randy Harmelink rharmelink@gmail.
> Another possibility -- if you are using version 2.1.2012.12.
> add-in, tell me whether these works for you:
>
> =smfGet888OptionQuo
> =smfGet888OptionQuo
>
> If not, visit this web page with IE or the EXCEL Web Query dialog:
>
> http://oic.ivolatil
>
> ...and then run smfForceRecalculati
>
> Let me know what happens.
>
> If that does work, you can find documentation for that function in the
> "Works in Progress" folder of the files area.
>
Mon Jan 28, 2013 9:22 am (PST) . Posted by:
"Simona G" simona4051
Many thanks I will check them tonight
Simona
Sent from my iPhone
On 28.01.2013, at 15:34, "Kermit W. Prather" kermitp@tampabay.rr.com > wrote:
> I list 4 really good stockscreener on the link page of my website. I, also, have lots of other useful links.
>
>
>
> http://tradingourway.com/Site_linkage.html
>
>
>
> I use Worden's TC2000.com but it is not free. http://www.worden.com/CURRENTAFPROMO.aspx?AFCODE=131
>
>
>
>
>
>
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Simona G
> Sent: Monday, January 28, 2013 9:11 AM
> To: smf_addin@yahoogroups.com
> Cc: smf_addin@yahoogroups.com
> Subject: [smf_addin] Historical Stock screener
>
>
>
>
>
>
>
> Hello
>
> Does anybody know of a good reliable stockscreener, linked to historical finance data where one can screen go multiple value parameters based on historical finance data from 10 years ago?
>
> Many thanks
>
> Simona
>
> Sent from my iPhone
>
>
> On 28.01.2013, at 14:09, "tenenbaum88" kenneth.dooley@gmail.com > wrote:
>
>
>
> Good catch, thanks ... however, we should add preferred shares and minority interest to be accurate. I might have to use data from a few sites in order to get at it.
>
> Thanks
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
> >
> > I've never looked at the details of it. Just used the value as is.
> >
> > But everything you need is right there on the Key Statistics page, right?
> >
> > EV = Market Cap + Total Cash - Total Debt
> >
> > That matches for MMM:
> >
> > EV = 69.11B + 4.53B - 6.00B = 70.58B
> >
> > All four of those amounts are there.
> >
> > On Sun, Jan 27, 2013 at 11:21 PM, tenenbaum88 wrote:
> >
> > >
> > > This question is not specific to the smf addon, but I have a feeling you
> > > more than anyone might have a decent sense of the quality of data found on
> > > the main free financial data sites. Do you have a sense of how good the
> > > 'enterprise value' data is from Yahoo? I ask because it is noted on their
> > > site that the data is "derived from multiple sources or calculated by
> > > Yahoo! Finance" ... which sounds potentially dubious to me.
> > >
> >
>
>
>
>
>
>
>
Simona
Sent from my iPhone
On 28.01.2013, at 15:34, "Kermit W. Prather" kermitp@tampabay.
> I list 4 really good stockscreener on the link page of my website. I, also, have lots of other useful links.
>
>
>
> http://tradingourwa
>
>
>
> I use Worden's TC2000.com but it is not free. http://www.worden.
>
>
>
>
>
>
>
> From: smf_addin@yahoogrou
> Sent: Monday, January 28, 2013 9:11 AM
> To: smf_addin@yahoogrou
> Cc: smf_addin@yahoogrou
> Subject: [smf_addin] Historical Stock screener
>
>
>
>
>
>
>
> Hello
>
> Does anybody know of a good reliable stockscreener, linked to historical finance data where one can screen go multiple value parameters based on historical finance data from 10 years ago?
>
> Many thanks
>
> Simona
>
> Sent from my iPhone
>
>
> On 28.01.2013, at 14:09, "tenenbaum88&q
>
>
>
> Good catch, thanks ... however, we should add preferred shares and minority interest to be accurate. I might have to use data from a few sites in order to get at it.
>
> Thanks
>
> --- In smf_addin@yahoogrou
> >
> > I've never looked at the details of it. Just used the value as is.
> >
> > But everything you need is right there on the Key Statistics page, right?
> >
> > EV = Market Cap + Total Cash - Total Debt
> >
> > That matches for MMM:
> >
> > EV = 69.11B + 4.53B - 6.00B = 70.58B
> >
> > All four of those amounts are there.
> >
> > On Sun, Jan 27, 2013 at 11:21 PM, tenenbaum88 wrote:
> >
> > >
> > > This question is not specific to the smf addon, but I have a feeling you
> > > more than anyone might have a decent sense of the quality of data found on
> > > the main free financial data sites. Do you have a sense of how good the
> > > 'enterprise value' data is from Yahoo? I ask because it is noted on their
> > > site that the data is "derived from multiple sources or calculated by
> > > Yahoo! Finance" ... which sounds potentially dubious to me.
> > >
> >
>
>
>
>
>
>
>
Mon Jan 28, 2013 9:22 am (PST) . Posted by:
"Simona G" simona4051
Many thanks Randy, I will try those
Simona
Sent from my iPhone
On 28.01.2013, at 15:55, Randy Harmelink rharmelink@gmail.com > wrote:
> Portfolio123.com and StockScreen123.com both have backtesters with point-in-time data back to 1999. And they have a number of data items that refer to financial statement items, which can go back for 10 annual periods or 20 quarterly periods at each point-in-time.
>
> However, they're not cheap. They currently use CompuStat data.
>
>
> On Mon, Jan 28, 2013 at 7:10 AM, Simona G simona4051@yahoo.com > wrote:
>> Does anybody know of a good reliable stockscreener, linked to historical finance data where one can screen go multiple value parameters based on historical finance data from 10 years ago?
>
>
Simona
Sent from my iPhone
On 28.01.2013, at 15:55, Randy Harmelink rharmelink@gmail.
> Portfolio123.
>
> However, they're not cheap. They currently use CompuStat data.
>
>
> On Mon, Jan 28, 2013 at 7:10 AM, Simona G simona4051@yahoo.
>> Does anybody know of a good reliable stockscreener, linked to historical finance data where one can screen go multiple value parameters based on historical finance data from 10 years ago?
>
>
Mon Jan 28, 2013 5:44 pm (PST) . Posted by:
"bozo" calhandon
Hi Randy,
The 5-minute data is only price and volume, for intraday charting. Day-based data is only updated at the end-of-day, unless I manually issue an update command.
> Another "quick" source you may want to look at is FinViz.
You can grab their entire stock coverage in one Internet access.
We've been using them for a while, but did not realize they had a data feed. I've not looked at the workbook you reference, so maybe you mean getting all of the data in a single SMF call.
> You may also want to look at the Zacks screener.
We used their site for quite a while, and even tried their Premium service, but found a lot of their data to be outdated and didn't like all of the daily junk mail and advertising they sent out. Like everyone else, it seems, they too use a proprietary (developed-in-house) sector/industry classification system, which doesn't follow any of the other major systems (Dow Jones/S&P, Bloomberg, etc.). And our tax dollars are hard at work maintaining yet another system that nobody in the equity markets uses (heavy sigh). And then there is the International system that the U.S. is not supporting. Grrrr. Since we obtain data from many different sites, we've not settled on a specific sector/industry system to use.
> Maybe a good question at this point is HOW do you use the ex-dividend date?
Just like you -- to be informed when an upcoming date is near. But we only pay close attention to it when it's for a security we are watching closely, and I've been updating these manually. They can be very profitable to trade around.
Thanks again for all of your help and suggestions, Randy. They are much appreciated.
Have a great week!
-Don
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Sunday, January 27, 2013 7:44 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Ex-Dividend Dates with RCHGetYahooQuotes
On Sun, Jan 27, 2013 at 6:42 PM, bozo bozo@donandcarla.com > wrote:
>
> Yes, the points you mention about the Yahoo CSV data have been on my/our
> minds for some time now. However, it looks like Yahoo is the only data
> provider for Ex-Div Date in SMF?
>
> We track and record 5-minute price intervals for about 1,400 securities,
> storing the 5-minute intraday data for 60 days. And the Yahoo CSV feed is
> the only one I know of that's free and can download a whole batch of data
> for 100-200 securities at a time. We live in a rural area where there is no
> "fast" Internet connection, only DSL (384-400 kbps on a good day), so a
> "live", or by-the-individual-security data feed might not work very well for
> us.
As I noted, I was using the add-in to extract ex-dividend dates from another, more reliable, source. But it is an issue if you are doing the 1400 securities. The advantage of the RCHGetYahooQuotes() function is that it can grab 200 multiple data items on 200 stocks in a single Internet access.
Not much use if the data isn't current, though. :(
However, not all of that data actually changes on 5-minute intervals, and ex-dividend dates of quarterly-paying stocks only change once per quarter. So why retrieve it every 5 minutes?
Another "quick" source you may want to look at is FinViz. You can grab their entire stock coverage in one Internet access. Check out the FinViz item in the LINKS area of the Yahoo group for more info.
You may also want to look at the Zacks screener. I sometimes just use a screening criteria of "Price > 5" and then choose which data items I want to see, and export data on about 6000 companies. For example, several of the useful data items Zacks has that Yahoo doesn't have on their CSV file are Next EPS Report date, sector, and industry:
Company Name
Ticker
Next EPS Report Date
Sector
Industry
Last Close
AGILENT TECH
A
20130213
Computer and Technology
ELEC TEST EQUIPTMENT
45.29
ALCOA INC
AA
20130409
Basic Materials
MINING -NON FERR
9.03
AAC TECH HLDGS
AACAY
20130329
Computer and Technology
ELEC-MISC COMPONENTS
36.46
Unfortunately, neither FinViz nor Zacks have the ex-dividend date as a possible output field.
> Any other suggestions for a case like ours, besides "quit watching 1,400
> securities" (grin)? Is there a reasonably priced quote service that can
> provide this data, that SMF is already hooked into?
Maybe a good question at this point is HOW do you use the ex-dividend date? If you've been living with out-of-date info, it can't be a critical item for you?
It sounds to me like you should parse out the pieces of data you're retrieving, and retrieve them when they are needed and/or updated, instead of retrieving every piece of data simultaneously.
> Thank you for the reference to your "upcoming dividends workbook", which
> is available at the following link:
> SMF-Template-Upcoming-Dividend-Champions.xls
That is an example of me retrieving the data only as needed.
In fact, it ANTICIPATES the announcement of ex-dividend dates. For example, two of those in the table I cited earlier -- HCP and MSEX -- just announced the dividends on Friday. But HCP had an ex-dividend date last year of 2012-02-02 and MSEX was 2012-02-13. So I was expecting the declaration of those dividends, before they were announced. That's what that workbook is for.
I've got it set up to show me stocks where I'm expecting an ex-dividend date within the next 5 weeks. And it confirms for me whether one has been declared yet.
But since I'm only dealing with "Dividend Champions" in that workbook, they will be on a pretty regular schedule.
The 5-minute data is only price and volume, for intraday charting. Day-based data is only updated at the end-of-day, unless I manually issue an update command.
> Another "quick" source you may want to look at is FinViz.
You can grab their entire stock coverage in one Internet access.
We've been using them for a while, but did not realize they had a data feed. I've not looked at the workbook you reference, so maybe you mean getting all of the data in a single SMF call.
> You may also want to look at the Zacks screener.
We used their site for quite a while, and even tried their Premium service, but found a lot of their data to be outdated and didn't like all of the daily junk mail and advertising they sent out. Like everyone else, it seems, they too use a proprietary (developed-in-
> Maybe a good question at this point is HOW do you use the ex-dividend date?
Just like you -- to be informed when an upcoming date is near. But we only pay close attention to it when it's for a security we are watching closely, and I've been updating these manually. They can be very profitable to trade around.
Thanks again for all of your help and suggestions, Randy. They are much appreciated.
Have a great week!
-Don
From: smf_addin@yahoogrou
Sent: Sunday, January 27, 2013 7:44 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Re: Ex-Dividend Dates with RCHGetYahooQuotes
On Sun, Jan 27, 2013 at 6:42 PM, bozo bozo@donandcarla.
>
> Yes, the points you mention about the Yahoo CSV data have been on my/our
> minds for some time now. However, it looks like Yahoo is the only data
> provider for Ex-Div Date in SMF?
>
> We track and record 5-minute price intervals for about 1,400 securities,
> storing the 5-minute intraday data for 60 days. And the Yahoo CSV feed is
> the only one I know of that's free and can download a whole batch of data
> for 100-200 securities at a time. We live in a rural area where there is no
> "fast" Internet connection, only DSL (384-400 kbps on a good day), so a
> "live"
> us.
As I noted, I was using the add-in to extract ex-dividend dates from another, more reliable, source. But it is an issue if you are doing the 1400 securities. The advantage of the RCHGetYahooQuotes(
Not much use if the data isn't current, though. :(
However, not all of that data actually changes on 5-minute intervals, and ex-dividend dates of quarterly-paying stocks only change once per quarter. So why retrieve it every 5 minutes?
Another "quick" source you may want to look at is FinViz. You can grab their entire stock coverage in one Internet access. Check out the FinViz item in the LINKS area of the Yahoo group for more info.
You may also want to look at the Zacks screener. I sometimes just use a screening criteria of "Price > 5" and then choose which data items I want to see, and export data on about 6000 companies. For example, several of the useful data items Zacks has that Yahoo doesn't have on their CSV file are Next EPS Report date, sector, and industry:
Company Name
Ticker
Next EPS Report Date
Sector
Industry
Last Close
AGILENT TECH
A
20130213
Computer and Technology
ELEC TEST EQUIPTMENT
45.29
ALCOA INC
AA
20130409
Basic Materials
MINING -NON FERR
9.03
AAC TECH HLDGS
AACAY
20130329
Computer and Technology
ELEC-MISC COMPONENTS
36.46
Unfortunately, neither FinViz nor Zacks have the ex-dividend date as a possible output field.
> Any other suggestions for a case like ours, besides "quit watching 1,400
> securities" (grin)? Is there a reasonably priced quote service that can
> provide this data, that SMF is already hooked into?
Maybe a good question at this point is HOW do you use the ex-dividend date? If you've been living with out-of-date info, it can't be a critical item for you?
It sounds to me like you should parse out the pieces of data you're retrieving, and retrieve them when they are needed and/or updated, instead of retrieving every piece of data simultaneously.
> Thank you for the reference to your "upcoming dividends workbook"
> is available at the following link:
> SMF-Template-
That is an example of me retrieving the data only as needed.
In fact, it ANTICIPATES the announcement of ex-dividend dates. For example, two of those in the table I cited earlier -- HCP and MSEX -- just announced the dividends on Friday. But HCP had an ex-dividend date last year of 2012-02-02 and MSEX was 2012-02-13. So I was expecting the declaration of those dividends, before they were announced. That's what that workbook is for.
I've got it set up to show me stocks where I'm expecting an ex-dividend date within the next 5 weeks. And it confirms for me whether one has been declared yet.
But since I'm only dealing with "Dividend Champions" in that workbook, they will be on a pretty regular schedule.
Mon Jan 28, 2013 6:07 pm (PST) . Posted by:
"calhandon" calhandon
The following is a complete list of Yahoo CSV Feed Parameters, based on
multiple sources, as of Jan 28, 2013.
The parameters marked with an asterisk are not recognized by the SMF
add-in (as of Jan 28, 2013). If you use one of these in a
RCHGetYahooQuotes() function, where you are also requesting column
headings, the data being retrieved will get out of sync with the column
headings.
Enjoy ...
Param Description
a Ask a2 Average Daily Volume a5 Ask Size b
Bid b2 Ask (Real-Time) b3 Bid (Real-Time) b4
Book Value b6 Bid Size c Change $ - Change % (as pct)
c1 Change c3* Commission (Yahoo="-" SMF=N) c6
Change (Real-Time) c8 After Hour Change (Real-Time) d
Dividend/Share d1 Last Trade Date d2* Trade Date
(Yahoo="-" SMF=N) e Earnings/Share e1* Error (N/A or
error text and URLs) SMF=N e3 Expiration date (Yahoo="N/A"
even with valid Option symbol) e7 EPS Estimate Current Year
e8 EPS Estimate Next Year e9 EPS Estimate Next Quarter SMF=N
f6 Float Shares g Day's Low g1* Holding Gain %
g3* Annualized Gain g4* Holding Gain g5 Holding Gain %
(Real-Time) g6 Holding Gain (Real-Time) h Day's High
i* More Info i5 Order Book (Real-Time) j 52-Week Low
j1 Market Capitalization j3 Market Cap (Real-Time) j4
EBITDA j5 Change from 52-Week Low j6 % Change from
52-Week Low k 52-Week High k1 Last Trade with Time
(Real-Time) k2 Change % (Real-Time) k3 Last Trade Size
k4 Change from 52-Week High k5 % Change from 52-Week Low
l Last Trade with Time l1* Last Trade (Price Only) l2*
High Limit l3 Low Limit m Day's Range m2 Day's
Range (Real-Time) m3 50-Day Mov Avg m4 200-Day Mov Avg
m5 Change from 200-Day Mov Avg m6 % Change from 200-Day Mov
Avg m7 Change from 50-Day Mov Avg m8 % Change from
50-Day Mov Avg n Name n4* Notes o Open o1
Open interest? p Previous Close p1* Price Paid p2
Change in % p3 Type of option p5 Price/Sales p6
Price/Book q Ex-Dividend Date r P/E Ratio r1
Dividend Pay Date r2 P/E Ratio (Real-Time) r5 PEG Ratio
r6 Price/EPS Estimate Current Year r7 Price/EPS Estimate Next
Year s Symbol s1* Shares Owned s3 Strike price
s7 Short Ratio t1 Last Trade Time t6* Trade Links
t7 Ticker Trend t8 Analyst One-Year Target v Volume
v1* Holding Value v7 Holding Value (Real-Time) w
52-Week Range w1* Day's Value Change w4 Day's Value
Change (Real-Time) x Stock Exchange y Dividend Yield
multiple sources, as of Jan 28, 2013.
The parameters marked with an asterisk are not recognized by the SMF
add-in (as of Jan 28, 2013). If you use one of these in a
RCHGetYahooQuotes(
headings, the data being retrieved will get out of sync with the column
headings.
Enjoy ...
Param Description
a Ask a2 Average Daily Volume a5 Ask Size b
Bid b2 Ask (Real-Time) b3 Bid (Real-Time) b4
Book Value b6 Bid Size c Change $ - Change % (as pct)
c1 Change c3* Commission (Yahoo="
Change (Real-Time) c8 After Hour Change (Real-Time) d
Dividend/Share d1 Last Trade Date d2* Trade Date
(Yahoo="
error text and URLs) SMF=N e3 Expiration date (Yahoo="
even with valid Option symbol) e7 EPS Estimate Current Year
e8 EPS Estimate Next Year e9 EPS Estimate Next Quarter SMF=N
f6 Float Shares g Day's Low g1* Holding Gain %
g3* Annualized Gain g4* Holding Gain g5 Holding Gain %
(Real-Time) g6 Holding Gain (Real-Time) h Day's High
i* More Info i5 Order Book (Real-Time) j 52-Week Low
j1 Market Capitalization j3 Market Cap (Real-Time) j4
EBITDA j5 Change from 52-Week Low j6 % Change from
52-Week Low k 52-Week High k1 Last Trade with Time
(Real-Time) k2 Change % (Real-Time) k3 Last Trade Size
k4 Change from 52-Week High k5 % Change from 52-Week Low
l Last Trade with Time l1* Last Trade (Price Only) l2*
High Limit l3 Low Limit m Day's Range m2 Day's
Range (Real-Time) m3 50-Day Mov Avg m4 200-Day Mov Avg
m5 Change from 200-Day Mov Avg m6 % Change from 200-Day Mov
Avg m7 Change from 50-Day Mov Avg m8 % Change from
50-Day Mov Avg n Name n4* Notes o Open o1
Open interest? p Previous Close p1* Price Paid p2
Change in % p3 Type of option p5 Price/Sales p6
Price/Book q Ex-Dividend Date r P/E Ratio r1
Dividend Pay Date r2 P/E Ratio (Real-Time) r5 PEG Ratio
r6 Price/EPS Estimate Current Year r7 Price/EPS Estimate Next
Year s Symbol s1* Shares Owned s3 Strike price
s7 Short Ratio t1 Last Trade Time t6* Trade Links
t7 Ticker Trend t8 Analyst One-Year Target v Volume
v1* Holding Value v7 Holding Value (Real-Time) w
52-Week Range w1* Day's Value Change w4 Day's Value
Change (Real-Time) x Stock Exchange y Dividend Yield
Mon Jan 28, 2013 6:36 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
That's because all of those items (except for "l1", which the add-in does
use) can only be used by MyYahoo's portfolios, and have no context outside
of that. So I never implemented them in the add-in. I'm not sure Yahoo even
uses them -- have you generated a CSV file with those fields populated with
meaningful data?
One of the exercises I used to do with the RCHGetYahooQuotes() function is
to return data for every letter, as well as every letter with a number
appended. That's 286 combinations. There are a lot of data items I didn't
use, simply because the data wasn't useful, or unidentifiable. Many of them
are for HTML displays. For example, "g2" returns something like:
"3M Company Common (NYSE:MMM)
-Trade: http://edit.finance.yahoo.com/ef?.intl=us&.done=http://finance.yahoo.com/d/quotes.csv%3fs%3dMMM%26f%3dg2%26e%3d.csv
">Choose Brokerage"
On Mon, Jan 28, 2013 at 7:07 PM, calhandon bozo@donandcarla.com > wrote:
>
> The following is a complete list of Yahoo CSV Feed Parameters, based on
> multiple sources, as of Jan 28, 2013.
>
> The parameters marked with an asterisk are not recognized by the SMF
> add-in (as of Jan 28, 2013). If you use one of these in a
> RCHGetYahooQuotes() function, where you are also requesting column
> headings, the data being retrieved will get out of sync with the column
> headings.
>
> Enjoy ...
>
> *Param* *Description*
> a Ask a2 Average Daily Volume a5 Ask Size b Bid b2 Ask (Real-Time)
> b3 Bid (Real-Time) b4 Book Value b6 Bid Size c Change $ - Change % (as
> pct) c1 Change c3* Commission (Yahoo="-" SMF=N) c6 Change (Real-Time)
> c8 After Hour Change (Real-Time) d Dividend/Share d1 Last Trade Date
> d2* Trade Date (Yahoo="-" SMF=N) e Earnings/Share e1* Error (N/A or
> error text and URLs) SMF=N e3 Expiration date (Yahoo="N/A" even with
> valid Option symbol) e7 EPS Estimate Current Year e8 EPS Estimate Next
> Year e9 EPS Estimate Next Quarter SMF=N f6 Float Shares g Day's Low
> g1* Holding Gain % g3* Annualized Gain g4* Holding Gain g5 Holding
> Gain % (Real-Time) g6 Holding Gain (Real-Time) h Day's High i* More
> Info i5 Order Book (Real-Time) j 52-Week Low j1 Market Capitalization
> j3 Market Cap (Real-Time) j4 EBITDA j5 Change from 52-Week Low j6 %
> Change from 52-Week Low k 52-Week High k1 Last Trade with Time
> (Real-Time) k2 Change % (Real-Time) k3 Last Trade Size k4 Change from
> 52-Week High k5 % Change from 52-Week Low l Last Trade with Time l1* Last
> Trade (Price Only) l2* High Limit l3 Low Limit m Day's Range m2 Day's
> Range (Real-Time) m3 50-Day Mov Avg m4 200-Day Mov Avg m5 Change from
> 200-Day Mov Avg m6 % Change from 200-Day Mov Avg m7 Change from 50-Day
> Mov Avg m8 % Change from 50-Day Mov Avg n Name n4* Notes o Open o1 Open
> interest? p Previous Close p1* Price Paid p2 Change in % p3 Type of
> option p5 Price/Sales p6 Price/Book q Ex-Dividend Date r P/E Ratio r1 Dividend
> Pay Date r2 P/E Ratio (Real-Time) r5 PEG Ratio r6 Price/EPS Estimate
> Current Year r7 Price/EPS Estimate Next Year s Symbol s1* Shares Owned
> s3 Strike price s7 Short Ratio t1 Last Trade Time t6* Trade Links t7 Ticker
> Trend t8 Analyst One-Year Target v Volume v1* Holding Value v7 Holding
> Value (Real-Time) w 52-Week Range w1* Day's Value Change w4 Day's
> Value Change (Real-Time) x Stock Exchange y Dividend Yield
>
>
use) can only be used by MyYahoo'
of that. So I never implemented them in the add-in. I'm not sure Yahoo even
uses them -- have you generated a CSV file with those fields populated with
meaningful data?
One of the exercises I used to do with the RCHGetYahooQuotes(
to return data for every letter, as well as every letter with a number
appended. That's 286 combinations. There are a lot of data items I didn't
use, simply because the data wasn't useful, or unidentifiable. Many of them
are for HTML displays. For example, "g2" returns something like:
"3M Company Common (NYSE:MMM)
-
">Choose&nb
On Mon, Jan 28, 2013 at 7:07 PM, calhandon bozo@donandcarla.
>
> The following is a complete list of Yahoo CSV Feed Parameters, based on
> multiple sources, as of Jan 28, 2013.
>
> The parameters marked with an asterisk are not recognized by the SMF
> add-in (as of Jan 28, 2013). If you use one of these in a
> RCHGetYahooQuotes(
> headings, the data being retrieved will get out of sync with the column
> headings.
>
> Enjoy ...
>
> *Param* *Description*
> a Ask a2 Average Daily Volume a5 Ask Size b Bid b2 Ask (Real-Time)
> b3 Bid (Real-Time) b4 Book Value b6 Bid Size c Change $ - Change % (as
> pct) c1 Change c3* Commission (Yahoo="
> c8 After Hour Change (Real-Time) d Dividend/Share d1 Last Trade Date
> d2* Trade Date (Yahoo="
> error text and URLs) SMF=N e3 Expiration date (Yahoo="
> valid Option symbol) e7 EPS Estimate Current Year e8 EPS Estimate Next
> Year e9 EPS Estimate Next Quarter SMF=N f6 Float Shares g Day's Low
> g1* Holding Gain % g3* Annualized Gain g4* Holding Gain g5 Holding
> Gain % (Real-Time) g6 Holding Gain (Real-Time) h Day's High i* More
> Info i5 Order Book (Real-Time) j 52-Week Low j1 Market Capitalization
> j3 Market Cap (Real-Time) j4 EBITDA j5 Change from 52-Week Low j6 %
> Change from 52-Week Low k 52-Week High k1 Last Trade with Time
> (Real-Time) k2 Change % (Real-Time) k3 Last Trade Size k4 Change from
> 52-Week High k5 % Change from 52-Week Low l Last Trade with Time l1* Last
> Trade (Price Only) l2* High Limit l3 Low Limit m Day's Range m2 Day's
> Range (Real-Time) m3 50-Day Mov Avg m4 200-Day Mov Avg m5 Change from
> 200-Day Mov Avg m6 % Change from 200-Day Mov Avg m7 Change from 50-Day
> Mov Avg m8 % Change from 50-Day Mov Avg n Name n4* Notes o Open o1 Open
> interest? p Previous Close p1* Price Paid p2 Change in % p3 Type of
> option p5 Price/Sales p6 Price/Book q Ex-Dividend Date r P/E Ratio r1 Dividend
> Pay Date r2 P/E Ratio (Real-Time) r5 PEG Ratio r6 Price/EPS Estimate
> Current Year r7 Price/EPS Estimate Next Year s Symbol s1* Shares Owned
> s3 Strike price s7 Short Ratio t1 Last Trade Time t6* Trade Links t7 Ticker
> Trend t8 Analyst One-Year Target v Volume v1* Holding Value v7 Holding
> Value (Real-Time) w 52-Week Range w1* Day's Value Change w4 Day's
> Value Change (Real-Time) x Stock Exchange y Dividend Yield
>
>
Mon Jan 28, 2013 7:54 pm (PST) . Posted by:
"bozo" calhandon
Hi Randy,
I'm sorry I starred l1 and l2 instead of l2 and l3 (heavy sigh), along with
leaving in some half-finished research. Just sent a follow-up message.
Yes, I am in a multi-day (week?) process of attempting to define exactly
what Yahoo returns, and in what format, along with what SMF displays, as I'm
seeing a lot of messed up data and don't know if it's Yahoo or SMF.
Yes, some of the starred fields contain valid data and yes, some of the
fields are Yahoo Portfolio specific (not of use in SMF). Off the top of my
head ... enter an invalid symbol and Yahoo returns the error in a string via
"e1". To me, it's useful information to know that the symbol I'm trying to
use is wrong.
Regardless of the usefulness of a particular parameter, if SMF chooses not
to recognize it, then it should place both a column heading and data value
in the column telling the user that this parameter is not supported by SMF.
Right now, SMF places a "--" in the column heading but does not place a data
value in the column itself, thus shifting HALF of the display (column
heading) by one column, leaving the data portion of the column unshifted. I
spent a lot of time documenting this and entering a long message via the
online group's Message function, but I never saw it come across in the email
feed. Did you see it?
Also, are you aware that Yahoo sometimes uses the thousands separator (yes,
a comma!!!) in numbers? If you read this before the market opens on
Tuesday, plug in AMAT, with "saa2a5bb2b3b4b6cc1c6c8dd1ee7e8e9" and column
headings. Yahoo returns an UNquoted value of 2,000 for Ask Size, which
places "2" in Ask Size and "0" in the next column, shifting all column data.
It doesn't look like SMF checks the number of items returned and split
(using ",") against the number of items requested by the user? If you check
this, and the two don't match, then you know Yahoo stuck a comma in where it
does not belong, and could do something of your own choice.
Thanks Randy,
-Don
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of calhandon
Sent: Monday, January 28, 2013 7:07 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Yahoo CSV Feed Parameter List
The following is a complete list of Yahoo CSV Feed Parameters, based on
multiple sources, as of Jan 28, 2013.
The parameters marked with an asterisk are not recognized by the SMF add-in
(as of Jan 28, 2013). If you use one of these in a RCHGetYahooQuotes()
function, where you are also requesting column headings, the data being
retrieved will get out of sync with the column headings.
Enjoy ...
Param Description
a
Ask
a2
Average Daily Volume
a5
Ask Size
b
Bid
b2
Ask (Real-Time)
b3
Bid (Real-Time)
b4
Book Value
b6
Bid Size
c
Change $ - Change % (as pct)
c1
Change
c3*
Commission (Yahoo="-" SMF=N)
c6
Change (Real-Time)
c8
After Hour Change (Real-Time)
d
Dividend/Share
d1
Last Trade Date
d2*
Trade Date (Yahoo="-" SMF=N)
e
Earnings/Share
e1*
Error (N/A or error text and URLs) SMF=N
e3
Expiration date (Yahoo="N/A" even with valid Option symbol)
e7
EPS Estimate Current Year
e8
EPS Estimate Next Year
e9
EPS Estimate Next Quarter SMF=N
f6
Float Shares
g
Day's Low
g1*
Holding Gain %
g3*
Annualized Gain
g4*
Holding Gain
g5
Holding Gain % (Real-Time)
g6
Holding Gain (Real-Time)
h
Day's High
i*
More Info
i5
Order Book (Real-Time)
j
52-Week Low
j1
Market Capitalization
j3
Market Cap (Real-Time)
j4
EBITDA
j5
Change from 52-Week Low
j6
% Change from 52-Week Low
k
52-Week High
k1
Last Trade with Time (Real-Time)
k2
Change % (Real-Time)
k3
Last Trade Size
k4
Change from 52-Week High
k5
% Change from 52-Week Low
l
Last Trade with Time
l1*
Last Trade (Price Only)
l2*
High Limit
l3
Low Limit
m
Day's Range
m2
Day's Range (Real-Time)
m3
50-Day Mov Avg
m4
200-Day Mov Avg
m5
Change from 200-Day Mov Avg
m6
% Change from 200-Day Mov Avg
m7
Change from 50-Day Mov Avg
m8
% Change from 50-Day Mov Avg
n
Name
n4*
Notes
o
Open
o1
Open interest?
p
Previous Close
p1*
Price Paid
p2
Change in %
p3
Type of option
p5
Price/Sales
p6
Price/Book
q
Ex-Dividend Date
r
P/E Ratio
r1
Dividend Pay Date
r2
P/E Ratio (Real-Time)
r5
PEG Ratio
r6
Price/EPS Estimate Current Year
r7
Price/EPS Estimate Next Year
s
Symbol
s1*
Shares Owned
s3
Strike price
s7
Short Ratio
t1
Last Trade Time
t6*
Trade Links
t7
Ticker Trend
t8
Analyst One-Year Target
v
Volume
v1*
Holding Value
v7
Holding Value (Real-Time)
w
52-Week Range
w1*
Day's Value Change
w4
Day's Value Change (Real-Time)
x
Stock Exchange
y
Dividend Yield
I'm sorry I starred l1 and l2 instead of l2 and l3 (heavy sigh), along with
leaving in some half-finished research. Just sent a follow-up message.
Yes, I am in a multi-day (week?) process of attempting to define exactly
what Yahoo returns, and in what format, along with what SMF displays, as I'm
seeing a lot of messed up data and don't know if it's Yahoo or SMF.
Yes, some of the starred fields contain valid data and yes, some of the
fields are Yahoo Portfolio specific (not of use in SMF). Off the top of my
head ... enter an invalid symbol and Yahoo returns the error in a string via
"e1"
use is wrong.
Regardless of the usefulness of a particular parameter, if SMF chooses not
to recognize it, then it should place both a column heading and data value
in the column telling the user that this parameter is not supported by SMF.
Right now, SMF places a "--" in the column heading but does not place a data
value in the column itself, thus shifting HALF of the display (column
heading) by one column, leaving the data portion of the column unshifted. I
spent a lot of time documenting this and entering a long message via the
online group's Message function, but I never saw it come across in the email
feed. Did you see it?
Also, are you aware that Yahoo sometimes uses the thousands separator (yes,
a comma!!!) in numbers? If you read this before the market opens on
Tuesday, plug in AMAT, with "saa2a5bb2b3b4
headings. Yahoo returns an UNquoted value of 2,000 for Ask Size, which
places "2" in Ask Size and "0" in the next column, shifting all column data.
It doesn't look like SMF checks the number of items returned and split
(using ","
this, and the two don't match, then you know Yahoo stuck a comma in where it
does not belong, and could do something of your own choice.
Thanks Randy,
-Don
From: smf_addin@yahoogrou
Of calhandon
Sent: Monday, January 28, 2013 7:07 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Yahoo CSV Feed Parameter List
The following is a complete list of Yahoo CSV Feed Parameters, based on
multiple sources, as of Jan 28, 2013.
The parameters marked with an asterisk are not recognized by the SMF add-in
(as of Jan 28, 2013). If you use one of these in a RCHGetYahooQuotes(
function, where you are also requesting column headings, the data being
retrieved will get out of sync with the column headings.
Enjoy ...
Param Description
a
Ask
a2
Average Daily Volume
a5
Ask Size
b
Bid
b2
Ask (Real-Time)
b3
Bid (Real-Time)
b4
Book Value
b6
Bid Size
c
Change $ - Change % (as pct)
c1
Change
c3*
Commission (Yahoo="
c6
Change (Real-Time)
c8
After Hour Change (Real-Time)
d
Dividend/Share
d1
Last Trade Date
d2*
Trade Date (Yahoo="
e
Earnings/Share
e1*
Error (N/A or error text and URLs) SMF=N
e3
Expiration date (Yahoo="
e7
EPS Estimate Current Year
e8
EPS Estimate Next Year
e9
EPS Estimate Next Quarter SMF=N
f6
Float Shares
g
Day's Low
g1*
Holding Gain %
g3*
Annualized Gain
g4*
Holding Gain
g5
Holding Gain % (Real-Time)
g6
Holding Gain (Real-Time)
h
Day's High
i*
More Info
i5
Order Book (Real-Time)
j
52-Week Low
j1
Market Capitalization
j3
Market Cap (Real-Time)
j4
EBITDA
j5
Change from 52-Week Low
j6
% Change from 52-Week Low
k
52-Week High
k1
Last Trade with Time (Real-Time)
k2
Change % (Real-Time)
k3
Last Trade Size
k4
Change from 52-Week High
k5
% Change from 52-Week Low
l
Last Trade with Time
l1*
Last Trade (Price Only)
l2*
High Limit
l3
Low Limit
m
Day's Range
m2
Day's Range (Real-Time)
m3
50-Day Mov Avg
m4
200-Day Mov Avg
m5
Change from 200-Day Mov Avg
m6
% Change from 200-Day Mov Avg
m7
Change from 50-Day Mov Avg
m8
% Change from 50-Day Mov Avg
n
Name
n4*
Notes
o
Open
o1
Open interest?
p
Previous Close
p1*
Price Paid
p2
Change in %
p3
Type of option
p5
Price/Sales
p6
Price/Book
q
Ex-Dividend Date
r
P/E Ratio
r1
Dividend Pay Date
r2
P/E Ratio (Real-Time)
r5
PEG Ratio
r6
Price/EPS Estimate Current Year
r7
Price/EPS Estimate Next Year
s
Symbol
s1*
Shares Owned
s3
Strike price
s7
Short Ratio
t1
Last Trade Time
t6*
Trade Links
t7
Ticker Trend
t8
Analyst One-Year Target
v
Volume
v1*
Holding Value
v7
Holding Value (Real-Time)
w
52-Week Range
w1*
Day's Value Change
w4
Day's Value Change (Real-Time)
x
Stock Exchange
y
Dividend Yield
Mon Jan 28, 2013 7:54 pm (PST) . Posted by:
"bozo" calhandon
Please disregard this list for now. There are some errors in it that I need
to fix. Sorry!
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of calhandon
Sent: Monday, January 28, 2013 7:07 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Yahoo CSV Feed Parameter List
The following is a complete list of Yahoo CSV Feed Parameters, based on
multiple sources, as of Jan 28, 2013.
The parameters marked with an asterisk are not recognized by the SMF add-in
(as of Jan 28, 2013). If you use one of these in a RCHGetYahooQuotes()
function, where you are also requesting column headings, the data being
retrieved will get out of sync with the column headings.
Enjoy ...
Param Description
a
Ask
a2
Average Daily Volume
a5
Ask Size
b
Bid
b2
Ask (Real-Time)
b3
Bid (Real-Time)
b4
Book Value
b6
Bid Size
c
Change $ - Change % (as pct)
c1
Change
c3*
Commission (Yahoo="-" SMF=N)
c6
Change (Real-Time)
c8
After Hour Change (Real-Time)
d
Dividend/Share
d1
Last Trade Date
d2*
Trade Date (Yahoo="-" SMF=N)
e
Earnings/Share
e1*
Error (N/A or error text and URLs) SMF=N
e3
Expiration date (Yahoo="N/A" even with valid Option symbol)
e7
EPS Estimate Current Year
e8
EPS Estimate Next Year
e9
EPS Estimate Next Quarter SMF=N
f6
Float Shares
g
Day's Low
g1*
Holding Gain %
g3*
Annualized Gain
g4*
Holding Gain
g5
Holding Gain % (Real-Time)
g6
Holding Gain (Real-Time)
h
Day's High
i*
More Info
i5
Order Book (Real-Time)
j
52-Week Low
j1
Market Capitalization
j3
Market Cap (Real-Time)
j4
EBITDA
j5
Change from 52-Week Low
j6
% Change from 52-Week Low
k
52-Week High
k1
Last Trade with Time (Real-Time)
k2
Change % (Real-Time)
k3
Last Trade Size
k4
Change from 52-Week High
k5
% Change from 52-Week Low
l
Last Trade with Time
l1*
Last Trade (Price Only)
l2*
High Limit
l3
Low Limit
m
Day's Range
m2
Day's Range (Real-Time)
m3
50-Day Mov Avg
m4
200-Day Mov Avg
m5
Change from 200-Day Mov Avg
m6
% Change from 200-Day Mov Avg
m7
Change from 50-Day Mov Avg
m8
% Change from 50-Day Mov Avg
n
Name
n4*
Notes
o
Open
o1
Open interest?
p
Previous Close
p1*
Price Paid
p2
Change in %
p3
Type of option
p5
Price/Sales
p6
Price/Book
q
Ex-Dividend Date
r
P/E Ratio
r1
Dividend Pay Date
r2
P/E Ratio (Real-Time)
r5
PEG Ratio
r6
Price/EPS Estimate Current Year
r7
Price/EPS Estimate Next Year
s
Symbol
s1*
Shares Owned
s3
Strike price
s7
Short Ratio
t1
Last Trade Time
t6*
Trade Links
t7
Ticker Trend
t8
Analyst One-Year Target
v
Volume
v1*
Holding Value
v7
Holding Value (Real-Time)
w
52-Week Range
w1*
Day's Value Change
w4
Day's Value Change (Real-Time)
x
Stock Exchange
y
Dividend Yield
to fix. Sorry!
From: smf_addin@yahoogrou
Of calhandon
Sent: Monday, January 28, 2013 7:07 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Yahoo CSV Feed Parameter List
The following is a complete list of Yahoo CSV Feed Parameters, based on
multiple sources, as of Jan 28, 2013.
The parameters marked with an asterisk are not recognized by the SMF add-in
(as of Jan 28, 2013). If you use one of these in a RCHGetYahooQuotes(
function, where you are also requesting column headings, the data being
retrieved will get out of sync with the column headings.
Enjoy ...
Param Description
a
Ask
a2
Average Daily Volume
a5
Ask Size
b
Bid
b2
Ask (Real-Time)
b3
Bid (Real-Time)
b4
Book Value
b6
Bid Size
c
Change $ - Change % (as pct)
c1
Change
c3*
Commission (Yahoo="
c6
Change (Real-Time)
c8
After Hour Change (Real-Time)
d
Dividend/Share
d1
Last Trade Date
d2*
Trade Date (Yahoo="
e
Earnings/Share
e1*
Error (N/A or error text and URLs) SMF=N
e3
Expiration date (Yahoo="
e7
EPS Estimate Current Year
e8
EPS Estimate Next Year
e9
EPS Estimate Next Quarter SMF=N
f6
Float Shares
g
Day's Low
g1*
Holding Gain %
g3*
Annualized Gain
g4*
Holding Gain
g5
Holding Gain % (Real-Time)
g6
Holding Gain (Real-Time)
h
Day's High
i*
More Info
i5
Order Book (Real-Time)
j
52-Week Low
j1
Market Capitalization
j3
Market Cap (Real-Time)
j4
EBITDA
j5
Change from 52-Week Low
j6
% Change from 52-Week Low
k
52-Week High
k1
Last Trade with Time (Real-Time)
k2
Change % (Real-Time)
k3
Last Trade Size
k4
Change from 52-Week High
k5
% Change from 52-Week Low
l
Last Trade with Time
l1*
Last Trade (Price Only)
l2*
High Limit
l3
Low Limit
m
Day's Range
m2
Day's Range (Real-Time)
m3
50-Day Mov Avg
m4
200-Day Mov Avg
m5
Change from 200-Day Mov Avg
m6
% Change from 200-Day Mov Avg
m7
Change from 50-Day Mov Avg
m8
% Change from 50-Day Mov Avg
n
Name
n4*
Notes
o
Open
o1
Open interest?
p
Previous Close
p1*
Price Paid
p2
Change in %
p3
Type of option
p5
Price/Sales
p6
Price/Book
q
Ex-Dividend Date
r
P/E Ratio
r1
Dividend Pay Date
r2
P/E Ratio (Real-Time)
r5
PEG Ratio
r6
Price/EPS Estimate Current Year
r7
Price/EPS Estimate Next Year
s
Symbol
s1*
Shares Owned
s3
Strike price
s7
Short Ratio
t1
Last Trade Time
t6*
Trade Links
t7
Ticker Trend
t8
Analyst One-Year Target
v
Volume
v1*
Holding Value
v7
Holding Value (Real-Time)
w
52-Week Range
w1*
Day's Value Change
w4
Day's Value Change (Real-Time)
x
Stock Exchange
y
Dividend Yield
Mon Jan 28, 2013 7:54 pm (PST) . Posted by:
"bozo" calhandon
Here is the data Yahoo returns for AMAT, via a manually-entered URL...
"AMAT",12.96,12878900,2,000,12.89,12.96,12.89,6.044,300,"+0.13 -
+1.01%",+0.13,"+0.13","N/A - N/A",0.26,"1/28/2013",0.086,0.53,0.95,0.11
Also, just checked online, and the long message I wrote is here:
http://finance.groups.yahoo.com/group/smf_addin/message/21070
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of calhandon
Sent: Monday, January 28, 2013 7:07 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Yahoo CSV Feed Parameter List
The following is a complete list of Yahoo CSV Feed Parameters, based on
multiple sources, as of Jan 28, 2013.
The parameters marked with an asterisk are not recognized by the SMF add-in
(as of Jan 28, 2013). If you use one of these in a RCHGetYahooQuotes()
function, where you are also requesting column headings, the data being
retrieved will get out of sync with the column headings.
Enjoy ...
Param Description
a
Ask
a2
Average Daily Volume
a5
Ask Size
b
Bid
b2
Ask (Real-Time)
b3
Bid (Real-Time)
b4
Book Value
b6
Bid Size
c
Change $ - Change % (as pct)
c1
Change
c3*
Commission (Yahoo="-" SMF=N)
c6
Change (Real-Time)
c8
After Hour Change (Real-Time)
d
Dividend/Share
d1
Last Trade Date
d2*
Trade Date (Yahoo="-" SMF=N)
e
Earnings/Share
e1*
Error (N/A or error text and URLs) SMF=N
e3
Expiration date (Yahoo="N/A" even with valid Option symbol)
e7
EPS Estimate Current Year
e8
EPS Estimate Next Year
e9
EPS Estimate Next Quarter SMF=N
f6
Float Shares
g
Day's Low
g1*
Holding Gain %
g3*
Annualized Gain
g4*
Holding Gain
g5
Holding Gain % (Real-Time)
g6
Holding Gain (Real-Time)
h
Day's High
i*
More Info
i5
Order Book (Real-Time)
j
52-Week Low
j1
Market Capitalization
j3
Market Cap (Real-Time)
j4
EBITDA
j5
Change from 52-Week Low
j6
% Change from 52-Week Low
k
52-Week High
k1
Last Trade with Time (Real-Time)
k2
Change % (Real-Time)
k3
Last Trade Size
k4
Change from 52-Week High
k5
% Change from 52-Week Low
l
Last Trade with Time
l1*
Last Trade (Price Only)
l2*
High Limit
l3
Low Limit
m
Day's Range
m2
Day's Range (Real-Time)
m3
50-Day Mov Avg
m4
200-Day Mov Avg
m5
Change from 200-Day Mov Avg
m6
% Change from 200-Day Mov Avg
m7
Change from 50-Day Mov Avg
m8
% Change from 50-Day Mov Avg
n
Name
n4*
Notes
o
Open
o1
Open interest?
p
Previous Close
p1*
Price Paid
p2
Change in %
p3
Type of option
p5
Price/Sales
p6
Price/Book
q
Ex-Dividend Date
r
P/E Ratio
r1
Dividend Pay Date
r2
P/E Ratio (Real-Time)
r5
PEG Ratio
r6
Price/EPS Estimate Current Year
r7
Price/EPS Estimate Next Year
s
Symbol
s1*
Shares Owned
s3
Strike price
s7
Short Ratio
t1
Last Trade Time
t6*
Trade Links
t7
Ticker Trend
t8
Analyst One-Year Target
v
Volume
v1*
Holding Value
v7
Holding Value (Real-Time)
w
52-Week Range
w1*
Day's Value Change
w4
Day's Value Change (Real-Time)
x
Stock Exchange
y
Dividend Yield
"AMAT"
+1.01%"
Also, just checked online, and the long message I wrote is here:
http://finance.
From: smf_addin@yahoogrou
Of calhandon
Sent: Monday, January 28, 2013 7:07 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Yahoo CSV Feed Parameter List
The following is a complete list of Yahoo CSV Feed Parameters, based on
multiple sources, as of Jan 28, 2013.
The parameters marked with an asterisk are not recognized by the SMF add-in
(as of Jan 28, 2013). If you use one of these in a RCHGetYahooQuotes(
function, where you are also requesting column headings, the data being
retrieved will get out of sync with the column headings.
Enjoy ...
Param Description
a
Ask
a2
Average Daily Volume
a5
Ask Size
b
Bid
b2
Ask (Real-Time)
b3
Bid (Real-Time)
b4
Book Value
b6
Bid Size
c
Change $ - Change % (as pct)
c1
Change
c3*
Commission (Yahoo="
c6
Change (Real-Time)
c8
After Hour Change (Real-Time)
d
Dividend/Share
d1
Last Trade Date
d2*
Trade Date (Yahoo="
e
Earnings/Share
e1*
Error (N/A or error text and URLs) SMF=N
e3
Expiration date (Yahoo="
e7
EPS Estimate Current Year
e8
EPS Estimate Next Year
e9
EPS Estimate Next Quarter SMF=N
f6
Float Shares
g
Day's Low
g1*
Holding Gain %
g3*
Annualized Gain
g4*
Holding Gain
g5
Holding Gain % (Real-Time)
g6
Holding Gain (Real-Time)
h
Day's High
i*
More Info
i5
Order Book (Real-Time)
j
52-Week Low
j1
Market Capitalization
j3
Market Cap (Real-Time)
j4
EBITDA
j5
Change from 52-Week Low
j6
% Change from 52-Week Low
k
52-Week High
k1
Last Trade with Time (Real-Time)
k2
Change % (Real-Time)
k3
Last Trade Size
k4
Change from 52-Week High
k5
% Change from 52-Week Low
l
Last Trade with Time
l1*
Last Trade (Price Only)
l2*
High Limit
l3
Low Limit
m
Day's Range
m2
Day's Range (Real-Time)
m3
50-Day Mov Avg
m4
200-Day Mov Avg
m5
Change from 200-Day Mov Avg
m6
% Change from 200-Day Mov Avg
m7
Change from 50-Day Mov Avg
m8
% Change from 50-Day Mov Avg
n
Name
n4*
Notes
o
Open
o1
Open interest?
p
Previous Close
p1*
Price Paid
p2
Change in %
p3
Type of option
p5
Price/Sales
p6
Price/Book
q
Ex-Dividend Date
r
P/E Ratio
r1
Dividend Pay Date
r2
P/E Ratio (Real-Time)
r5
PEG Ratio
r6
Price/EPS Estimate Current Year
r7
Price/EPS Estimate Next Year
s
Symbol
s1*
Shares Owned
s3
Strike price
s7
Short Ratio
t1
Last Trade Time
t6*
Trade Links
t7
Ticker Trend
t8
Analyst One-Year Target
v
Volume
v1*
Holding Value
v7
Holding Value (Real-Time)
w
52-Week Range
w1*
Day's Value Change
w4
Day's Value Change (Real-Time)
x
Stock Exchange
y
Dividend Yield
Mon Jan 28, 2013 8:12 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Yup. But I thought the only one was float.
If you have multiple items that might have numeric fields with commas,
there would be multiple ways to parse them into individual fields. What I
wrote is a fairly simple CSV parser (in fact, it's my generic CSV parser),
but I will note that if you open the CSV file with those items in it, EXCEL
will also parse the items into separate columns.
It's a Yahoo error in the creation of the CSV file. For example, this:
http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sf6&e=.csv
...returns:
"MMM", 684,453,000
Obviously, 4 fields in any definition of a CSV file. EXCEL agrees. :)
On Mon, Jan 28, 2013 at 8:54 PM, bozo bozo@donandcarla.com > wrote:
>
>
> Also, are you aware that Yahoo sometimes uses the thousands separator
> (yes, a comma!!!) in numbers? If you read this before the market opens
> on Tuesday, plug in AMAT, with "saa2a5bb2b3b4b6cc1c6c8dd1ee7e8e9" and
> column headings. Yahoo returns an UNquoted value of 2,000 for Ask Size,
> which places "2" in Ask Size and "0" in the next column, shifting all
> column data. It doesn't look like SMF checks the number of items
> returned and split (using ",") against the number of items requested by the
> user? If you check this, and the two don't match, then you know Yahoo
> stuck a comma in where it does not belong, and could do something of your
> own choice.****
>
>
>
If you have multiple items that might have numeric fields with commas,
there would be multiple ways to parse them into individual fields. What I
wrote is a fairly simple CSV parser (in fact, it's my generic CSV parser),
but I will note that if you open the CSV file with those items in it, EXCEL
will also parse the items into separate columns.
It's a Yahoo error in the creation of the CSV file. For example, this:
http://download.
...returns:
"MMM"
Obviously, 4 fields in any definition of a CSV file. EXCEL agrees. :)
On Mon, Jan 28, 2013 at 8:54 PM, bozo bozo@donandcarla.
>
>
> Also, are you aware that Yahoo sometimes uses the thousands separator
> (yes, a comma!!!) in numbers? If you read this before the market opens
> on Tuesday, plug in AMAT, with "saa2a5bb2b3b4
> column headings. Yahoo returns an UNquoted value of 2,000 for Ask Size,
> which places "2" in Ask Size and "0" in the next column, shifting all
> column data. It doesn't look like SMF checks the number of items
> returned and split (using ","
> user? If you check this, and the two don't match, then you know Yahoo
> stuck a comma in where it does not belong, and could do something of your
> own choice.****
>
>
>
Mon Jan 28, 2013 9:54 pm (PST) . Posted by:
"bozo" calhandon
Yes, that's what Excel would do. However, Excel doesn't know how many data items the user asked for, but SMF does. All it has to do is check that number against the number of split items from the returned data, and if they do not agree, do something to let the user know the data is screwed up *somewhere* in this row. Even if it's only to put an asterisk in the very first field.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Monday, January 28, 2013 9:13 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo CSV Feed Parameter List
Yup. But I thought the only one was float.
If you have multiple items that might have numeric fields with commas, there would be multiple ways to parse them into individual fields. What I wrote is a fairly simple CSV parser (in fact, it's my generic CSV parser), but I will note that if you open the CSV file with those items in it, EXCEL will also parse the items into separate columns.
It's a Yahoo error in the creation of the CSV file. For example, this:
http://download.finance.yahoo.com/d/quotes.csv?s=MMM http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sf6&e=.csv > &f=sf6&e=.csv
...returns:
"MMM", 684,453,000
Obviously, 4 fields in any definition of a CSV file. EXCEL agrees. :)
On Mon, Jan 28, 2013 at 8:54 PM, bozo bozo@donandcarla.com > wrote:
Also, are you aware that Yahoo sometimes uses the thousands separator (yes, a comma!!!) in numbers? If you read this before the market opens on Tuesday, plug in AMAT, with "saa2a5bb2b3b4b6cc1c6c8dd1ee7e8e9" and column headings. Yahoo returns an UNquoted value of 2,000 for Ask Size, which places "2" in Ask Size and "0" in the next column, shifting all column data. It doesn't look like SMF checks the number of items returned and split (using ",") against the number of items requested by the user? If you check this, and the two don't match, then you know Yahoo stuck a comma in where it does not belong, and could do something of your own choice.
From: smf_addin@yahoogrou
Sent: Monday, January 28, 2013 9:13 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Yahoo CSV Feed Parameter List
Yup. But I thought the only one was float.
If you have multiple items that might have numeric fields with commas, there would be multiple ways to parse them into individual fields. What I wrote is a fairly simple CSV parser (in fact, it's my generic CSV parser), but I will note that if you open the CSV file with those items in it, EXCEL will also parse the items into separate columns.
It's a Yahoo error in the creation of the CSV file. For example, this:
http://download.
...returns:
"MMM"
Obviously, 4 fields in any definition of a CSV file. EXCEL agrees. :)
On Mon, Jan 28, 2013 at 8:54 PM, bozo bozo@donandcarla.
Also, are you aware that Yahoo sometimes uses the thousands separator (yes, a comma!!!) in numbers? If you read this before the market opens on Tuesday, plug in AMAT, with "saa2a5bb2b3b4
Tidak ada komentar:
Posting Komentar