15 New Messages
Digest #2483
Messages
Sun Jan 27, 2013 10:08 am (PST) . Posted by:
"Srini Kasturi" kasturi.srini
Randy:
You never seize to amaze with the depth of thought you put in in your responses and do them so quickly. May the Lord Almighty keep you strong, healthy forever for the benefit of us mere users of your hard work!
Sonny
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Saturday, January 26, 2013 11:50 PM
Subject: Re: [smf_addin] Re: Ex-Dividend Dates with RCHGetYahooQuotes
I've got it saved, for consideration when I am doing some work in that routine. There are two issues i have with it:
1. It would screw up that data item for people that are already handling that item as a text item. So it's not backward compatible. And you'd still need to handle something at the end anyway, when Yahoo didn't pass a date (e.g. an "NA" value or such).
2. Unfortunately, it's not as simple as the given code, because the "items" list is not all 1-byte data codes. There are also 2-byte data codes, such as "l1" and "d1". So it would actually require parsing out EACH data code in the list, popping them off one at a time. There would be no simple MID() function to use. I had originally gone down the path of that parsing process, but I decided I really didn't want to get into coding of EACH possible data code -- especially if Yahoo ever changed something. Not that they have in the past 7 years, other than making some obsolete. After all, it was just a CSV file I was converting in the first place.
I had originally put some date handling into the smfConvertData() process, where I also attempt to convert data strings into potential numbers, but had to take it out because it hosed up some data retrieval items. For example, financial statement headings are something like "12-2012" which the isDate() recognizes as a date, but CDate() converts to 12/1/2012. When it should just be a text label. There were other issues, but I remember that one.
This is the best way to offer enhancements. Then I can see if others pipe up with a "Yes, I could really use that" or have some other comments.
On Sat, Jan 26, 2013 at 9:26 PM, calhandon bozo@donandcarla.com > wrote:
Hi Randy,
>Just wondering if you saw the post below?
>Is there a better way to offer suggested enhancements to you, or do you prefer to not receive enhancements?
>Do you have a bunch of different static data that you use for testing changes to the SMF add-in?
>Thank you, Randy.
>-Don
>
You never seize to amaze with the depth of thought you put in in your responses and do them so quickly. May the Lord Almighty keep you strong, healthy forever for the benefit of us mere users of your hard work!
Sonny
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Saturday, January 26, 2013 11:50 PM
Subject: Re: [smf_addin] Re: Ex-Dividend Dates with RCHGetYahooQuotes
I've got it saved, for consideration when I am doing some work in that routine. There are two issues i have with it:
1. It would screw up that data item for people that are already handling that item as a text item. So it's not backward compatible. And you'd still need to handle something at the end anyway, when Yahoo didn't pass a date (e.g. an "NA" value or such).
2. Unfortunately, it's not as simple as the given code, because the "items" list is not all 1-byte data codes. There are also 2-byte data codes, such as "l1" and "d1"
I had originally put some date handling into the smfConvertData(
This is the best way to offer enhancements. Then I can see if others pipe up with a "Yes, I could really use that" or have some other comments.
On Sat, Jan 26, 2013 at 9:26 PM, calhandon bozo@donandcarla.
Hi Randy,
>Just wondering if you saw the post below?
>Is there a better way to offer suggested enhancements to you, or do you prefer to not receive enhancements?
>Do you have a bunch of different static data that you use for testing changes to the SMF add-in?
>Thank you, Randy.
>-Don
>
Sun Jan 27, 2013 1:22 pm (PST) . Posted by:
"calhandon" calhandon
Thank you for your reply, Randy.
> It would screw up that data item for people that are already handling
that item as a text item. So it's not backward compatible.
Good point. Can you add an additional optional parameter to
RCHGetYahooQuotes(), at the end of the existing parameter list, such as
"Convert to Excel Date if returned value is recognized by Excel as a
Date"? Just another one of the "0" or "1" parameters. Or would doing
this then break all existing user calls to this function, that are
sending only X number of parameters, when the new call would be looking
for Y number of parameters? Sorry, but I'm not sure about variable
number of parameters in VBA.
> And you'd still need to handle something at the end anyway, when Yahoo
didn't pass a date (e.g. an "NA" value or such).
It already does. If Excel can't recognize the returned string as a
valid Date, the code does nothing. The existing string simply passes
through the code, without change.
> Unfortunately, it's not as simple as the given code, because the
"items" list is not all 1-byte data codes. There are also 2-byte data
codes, such as "l1" and "d1". So it would actually require parsing out
EACH data code in the list, popping them off one at a time. There would
be no simple MID() function to use.
Thank you for pointing this out. A single character look-ahead, looking
for a numeric value, can be coded in an If statement, as shown below.
Notes: dT is dimensioned as a Date at the beginning of the Function.
iDblParam (double-parameter counter) is dimensioned as an Integer at the
beginning of the Function, and is set to zero at the beginning of the
parse section.
The entire Ex-Dividend Date (and any other dates you want) section now
looks like the following ...
If i2 + 2 <= Len(sItems) Then
If IsNumeric(Mid(sItems, i2 + iDblParam + 2, 1)) Then
iDblParam = iDblParam + 1
Else
If ((Mid(sItems, i2 + iDblParam + 1, 1) = "q") And (IsDate(s1)))
Then
dT = CDate(s1)
s1 = CStr(DateSerial(Year(dT), Month(dT), Day(dT)))
's1 = DateSerial(Year(dT), Month(dT), Day(dT))
End If
End If
End If
Since s1 is not explicitly dimensioned, but it's first assignment is to
a String, I'm not sure that it would properly handle a Date data type.
That's why there are two versions of the s1 assignment.
To see what other dates Yahoo provides, I looked through my list of
Yahoo Parameters and found the following ...
* d1 - Trade Date
* d2 - Last Trade Date
* e3 - Expiration Date
* q - Ex-Dividend Date
* r1 - Dividend Pay Date
When I plugged all of these into an Excel sheet with the following array
formula (using your official release XLA) ...
=RCHGetYahooQuotes( "MCD,TEF", "sd1d2e3qr1", , , 1 )
... the following was displayed, where "Header" is the description I
have for the parameters, and "SMF Hdr" is the header returned by the SMF
function ...
Y Param: s d1 d2 e3 q r1
Last Expiration Ex-Div
Dividend
Header: Symbol Trade Date Trade Date date Date Pay
Date
Date of Dividend/ Expiration
Ex-Div Dividend
SMF Hdr: Symbol Last Trade Share -- date
Date Pay Date
------ ---------- ---------- ---------- ----------
---------- ----------
MCD 1/25/2013 0 N/A Nov 29 Dec 17
TEF 1/25/2013 0 N/A 15-May-12
31-May-12
Please notice how the function improperly handles the e3 parameter
heading, thus skewing the actual data values from their associated
column headings. "e3" does in fact reside in the smfYahooCodeDesc()
function CASE list, but I've not debugged it to find out what's going
on.
I also compared my Yahoo parameter list to those listed in the
smfYahooCodeDesc() function, and found several that are not included in
one or the other. When I finish going through both and create a third,
I'll post the results. Right now, each time a parameter is requested by
the user, but not found in smfYahooCodeDesc(), another column heading is
dashed out ("--") and the data values are skewed further. Enter the
following formula and you'll see what I mean . . .
=RCHGetYahooQuotes( "MCD,TEF",
"saa2a5bb2b3b4b6cc1c3c6c8dd1d2ee1e7e8e9f6ghjkg1g3g4g5g6ii5j1j3j4j5j6k1k2\
k3k4k5ll1l2l3mm2m3m4m5m6m7m8nn4opp1p2p5p6qrr1r2r5r6r7ss1s7t1t6t7t8vv1v7w\
w1w4xy", , , 1 )
This produces a display where the last 11 columns contain no data (are
blank). The last data value displayed is in the "Ticker Trend" column,
with a value of "3.08", which is in fact the "Dividend Yield", which is
the last requested column, 11 columns to the right.
Personally, I've decided to not pursue this Ex-Dividend Date parsing,
because any user code to automatically set a missing year would simply
be a "best guess", which is not a good idea. It's better to visually
see what Yahoo returns and make a human decision.
Thank you again for replying to my code post, explaining additional
conditions that needed to be taken into account. I really appreciate
your time Randy, and thank you very much for all the work you do on the
SMF add-in to keep it up-to-date, and answering all the messages here in
the mailing list, which all seem to require additional research time and
effort on your part as well. You are one amazing person!
I would gladly send a donation but I read elsewhere that you prefer we
send donations to a favorite charity, so that's what I'll do. My wife
and I help support a local homeless shelter / soup kitchen, so we'll
send them an additional $100 on your behalf (and no, we won't name you).
Cheers for now,
-Don
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> I've got it saved, for consideration when I am doing some work in that
> routine. There are two issues i have with it:
>
> 1. It would screw up that data item for people that are already
handling
> that item as a text item. So it's not backward compatible. And
you'd still
> need to handle something at the end anyway, when Yahoo didn't pass
a date
> (e.g. an "NA" value or such).
>
> 2. Unfortunately, it's not as simple as the given code, because the
> "items" list is not all 1-byte data codes. There are also 2-byte
data
> codes, such as "l1" and "d1". So it would actually require parsing
out EACH
> data code in the list, popping them off one at a time. There would
be no
> simple MID() function to use. I had originally gone down the path
of that
> parsing process, but I decided I really didn't want to get into
coding of
> EACH possible data code -- especially if Yahoo ever changed
something. Not
> that they have in the past 7 years, other than making some
obsolete. After
> all, it was just a CSV file I was converting in the first place.
>
> I had originally put some date handling into the smfConvertData()
process,
> where I also attempt to convert data strings into potential numbers,
but
> had to take it out because it hosed up some data retrieval items. For
> example, financial statement headings are something like "12-2012"
which
> the isDate() recognizes as a date, but CDate() converts to 12/1/2012.
When
> it should just be a text label. There were other issues, but I
remember
> that one.
>
> This is the best way to offer enhancements. Then I can see if others
pipe
> up with a "Yes, I could really use that" or have some other comments.
>
> On Sat, Jan 26, 2013 at 9:26 PM, calhandon wrote:
>
> > Hi Randy,
> >
> > Just wondering if you saw the post below?
> >
> > Is there a better way to offer suggested enhancements to you, or do
you
> > prefer to not receive enhancements?
> >
> > Do you have a bunch of different static data that you use for
testing
> > changes to the SMF add-in?
> >
> > Thank you, Randy.
> >
> > -Don
> >
>
> It would screw up that data item for people that are already handling
that item as a text item. So it's not backward compatible.
Good point. Can you add an additional optional parameter to
RCHGetYahooQuotes(
"Convert to Excel Date if returned value is recognized by Excel as a
Date"? Just another one of the "0" or "1" parameters. Or would doing
this then break all existing user calls to this function, that are
sending only X number of parameters, when the new call would be looking
for Y number of parameters? Sorry, but I'm not sure about variable
number of parameters in VBA.
> And you'd still need to handle something at the end anyway, when Yahoo
didn't pass a date (e.g. an "NA" value or such).
It already does. If Excel can't recognize the returned string as a
valid Date, the code does nothing. The existing string simply passes
through the code, without change.
> Unfortunately, it's not as simple as the given code, because the
"items" list is not all 1-byte data codes. There are also 2-byte data
codes, such as "l1" and "d1"
EACH data code in the list, popping them off one at a time. There would
be no simple MID() function to use.
Thank you for pointing this out. A single character look-ahead, looking
for a numeric value, can be coded in an If statement, as shown below.
Notes: dT is dimensioned as a Date at the beginning of the Function.
iDblParam (double-parameter counter) is dimensioned as an Integer at the
beginning of the Function, and is set to zero at the beginning of the
parse section.
The entire Ex-Dividend Date (and any other dates you want) section now
looks like the following ...
If i2 + 2 <= Len(sItems) Then
If IsNumeric(Mid(
iDblParam = iDblParam + 1
Else
If ((Mid(sItems, i2 + iDblParam + 1, 1) = "q"
Then
dT = CDate(s1)
s1 = CStr(DateSerial(
's1 = DateSerial(Year(
End If
End If
End If
Since s1 is not explicitly dimensioned, but it's first assignment is to
a String, I'm not sure that it would properly handle a Date data type.
That's why there are two versions of the s1 assignment.
To see what other dates Yahoo provides, I looked through my list of
Yahoo Parameters and found the following ...
* d1 - Trade Date
* d2 - Last Trade Date
* e3 - Expiration Date
* q - Ex-Dividend Date
* r1 - Dividend Pay Date
When I plugged all of these into an Excel sheet with the following array
formula (using your official release XLA) ...
=RCHGetYahooQuotes( "MCD,TEF"
... the following was displayed, where "Header" is the description I
have for the parameters, and "SMF Hdr" is the header returned by the SMF
function ...
Y Param: s d1 d2 e3 q r1
Last Expiration Ex-Div
Dividend
Header: Symbol Trade Date Trade Date date Date Pay
Date
Date of Dividend/ Expiration
Ex-Div Dividend
SMF Hdr: Symbol Last Trade Share -- date
Date Pay Date
------ ---------- ---------- ---------- ----------
---------- ----------
MCD 1/25/2013 0 N/A Nov 29 Dec 17
TEF 1/25/2013 0 N/A 15-May-12
31-May-12
Please notice how the function improperly handles the e3 parameter
heading, thus skewing the actual data values from their associated
column headings. "e3" does in fact reside in the smfYahooCodeDesc(
function CASE list, but I've not debugged it to find out what's going
on.
I also compared my Yahoo parameter list to those listed in the
smfYahooCodeDesc(
one or the other. When I finish going through both and create a third,
I'll post the results. Right now, each time a parameter is requested by
the user, but not found in smfYahooCodeDesc(
dashed out ("--"
following formula and you'll see what I mean . . .
=RCHGetYahooQuotes( "MCD,TEF"
"saa2a5bb2b3b4
k3k4k5ll1l2l3mm2m3m
w1w4xy"
This produces a display where the last 11 columns contain no data (are
blank). The last data value displayed is in the "Ticker Trend" column,
with a value of "3.08"
the last requested column, 11 columns to the right.
Personally, I've decided to not pursue this Ex-Dividend Date parsing,
because any user code to automatically set a missing year would simply
be a "best guess", which is not a good idea. It's better to visually
see what Yahoo returns and make a human decision.
Thank you again for replying to my code post, explaining additional
conditions that needed to be taken into account. I really appreciate
your time Randy, and thank you very much for all the work you do on the
SMF add-in to keep it up-to-date, and answering all the messages here in
the mailing list, which all seem to require additional research time and
effort on your part as well. You are one amazing person!
I would gladly send a donation but I read elsewhere that you prefer we
send donations to a favorite charity, so that's what I'll do. My wife
and I help support a local homeless shelter / soup kitchen, so we'll
send them an additional $100 on your behalf (and no, we won't name you).
Cheers for now,
-Don
--- In smf_addin@yahoogrou
>
> I've got it saved, for consideration when I am doing some work in that
> routine. There are two issues i have with it:
>
> 1. It would screw up that data item for people that are already
handling
> that item as a text item. So it's not backward compatible. And
you'd still
> need to handle something at the end anyway, when Yahoo didn't pass
a date
> (e.g. an "NA" value or such).
>
> 2. Unfortunately, it's not as simple as the given code, because the
> "items" list is not all 1-byte data codes. There are also 2-byte
data
> codes, such as "l1" and "d1"
out EACH
> data code in the list, popping them off one at a time. There would
be no
> simple MID() function to use. I had originally gone down the path
of that
> parsing process, but I decided I really didn't want to get into
coding of
> EACH possible data code -- especially if Yahoo ever changed
something. Not
> that they have in the past 7 years, other than making some
obsolete. After
> all, it was just a CSV file I was converting in the first place.
>
> I had originally put some date handling into the smfConvertData(
process,
> where I also attempt to convert data strings into potential numbers,
but
> had to take it out because it hosed up some data retrieval items. For
> example, financial statement headings are something like "12-2012"
which
> the isDate() recognizes as a date, but CDate() converts to 12/1/2012.
When
> it should just be a text label. There were other issues, but I
remember
> that one.
>
> This is the best way to offer enhancements. Then I can see if others
pipe
> up with a "Yes, I could really use that" or have some other comments.
>
> On Sat, Jan 26, 2013 at 9:26 PM, calhandon wrote:
>
> > Hi Randy,
> >
> > Just wondering if you saw the post below?
> >
> > Is there a better way to offer suggested enhancements to you, or do
you
> > prefer to not receive enhancements?
> >
> > Do you have a bunch of different static data that you use for
testing
> > changes to the SMF add-in?
> >
> > Thank you, Randy.
> >
> > -Don
> >
>
Sun Jan 27, 2013 2:10 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I'll respond item by item below, but just thought I'd mention this -- I no
longer use ex-dividend dates from Yahoo, because they are often so
out-of-date. Sometime they reflect the previous quarter's date even when a
new ex-dividend date has been announced for over a month. I've even seen
cases where the Key Statistics web page has been updated for a week, and
the CSV file still produces the older date. Three upcoming examples:
Ticker TDAmeritrade Yahoo CSV Yahoo Key Statistics NWN 2013-01-29 Oct 31 Jan
29, 2013 HCP 2013-01-31 Nov 1 Nov 1, 2012 MSEX 2013-02-13 Nov 13 Nov 13,
2012
Although it's slower, because I need to do it one web page at a time, I get
most of my ex-dividend dates here:
=DATEVALUE(smfGetTagContent("
http://research.tdameritrade.com/public/stocks/overview/overview.asp?symbol=
"&SUBSTITUTE(B8,"-","."),"div",1,">Ex-Dividend"))
However, I typically only do it for a dozen or so dividend champions that I
know have upcoming dividends. I would never do it for a large number of
ticker symbols. I mention my upcoming dividends workbook here:
http://finance.groups.yahoo.com/group/smf_addin/message/19286
On Sun, Jan 27, 2013 at 2:22 PM, calhandon bozo@donandcarla.com > wrote:
>
> > It would screw up that data item for people that are already handling
> that item as a text item. So it's not backward compatible.
>
> Good point. Can you add an additional optional parameter to
> RCHGetYahooQuotes(), at the end of the existing parameter list, such as
> "Convert to Excel Date if returned value is recognized by Excel as a
> Date"? Just another one of the "0" or "1" parameters. Or would doing this
> then break all existing user calls to this function, that are sending only
> X number of parameters, when the new call would be looking for Y number of
> parameters? Sorry, but I'm not sure about variable number of parameters in
> VBA.
>
Possible, but inconvenient at this time. I really want the pDim1 and pDim2
parameters to be the last ones.
Sigh. Now I wish I had added a bunch of dummy parameters to all the
functions. :(
One other thing I had considered is that if I have to run the parsing
process through, maybe I could add a "q1" data code in addition to the "q"
data code.
> > And you'd still need to handle something at the end anyway, when Yahoo
> didn't pass a date (e.g. an "NA" value or such).
>
> It already does. If Excel can't recognize the returned string as a valid
> Date, the code does nothing. The existing string simply passes through the
> code, without change.
>
No. I meant on the user end. If YOU still get an NA returned from the
function, after date conversion, and need to use the date for something, it
still isn't a date, but a text string.
> > Unfortunately, it's not as simple as the given code, because the "items"
> list is not all 1-byte data codes. There are also 2-byte data codes, such
> as "l1" and "d1". So it would actually require parsing out EACH data code
> in the list, popping them off one at a time. There would be no simple MID()
> function to use.
>
> Thank you for pointing this out. A single character look-ahead, looking
> for a numeric value, can be coded in an If statement, as shown below.
> Notes: dT is dimensioned as a Date at the beginning of the Function.
> iDblParam (double-parameter counter) is dimensioned as an Integer at the
> beginning of the Function, and is set to zero at the beginning of the parse
> section.
>
Yes, that would be one method of parsing the list. That would be a possible
way to incorporate the fake "q1" data code I mentioned earlier. Then a
parameter isn't needed for the function.
Personally, I've decided to not pursue this Ex-Dividend Date parsing,
> because any user code to automatically set a missing year would simply be a
> "best guess", which is not a good idea. It's better to visually see what
> Yahoo returns and make a human decision.
>
I noticed that when I created my table at the beginning of the message.
Since all of those dates were from 2012, the CDate() function would have
incorrectly assigned them to 2013. In most cases, with quarterly and
monthly dividends, that could be handled easily, just by comparing the
month of the sent date to the current month. But that wouldn't work well
for stocks with annual or irregular ex-dividend dates.
Details, details, details... :)
And, as I noted early on, Yahoo may not be a good source for ex-dividend
dates anyway...
Thank you again for replying to my code post, explaining additional
> conditions that needed to be taken into account. I really appreciate your
> time Randy, and thank you very much for all the work you do on the SMF
> add-in to keep it up-to-date, and answering all the messages here in the
> mailing list, which all seem to require additional research time and effort
> on your part as well. You are one amazing person!
>
> I would gladly send a donation but I read elsewhere that you prefer we
> send donations to a favorite charity, so that's what I'll do. My wife and
> I help support a local homeless shelter / soup kitchen, so we'll send them
> an additional $100 on your behalf (and no, we won't name you).
>
Thanks. I'm a believer of the "pay it forward" concept...
We can all use a little help now and then.
longer use ex-dividend dates from Yahoo, because they are often so
out-of-date. Sometime they reflect the previous quarter'
new ex-dividend date has been announced for over a month. I've even seen
cases where the Key Statistics web page has been updated for a week, and
the CSV file still produces the older date. Three upcoming examples:
Ticker TDAmeritrade Yahoo CSV Yahoo Key Statistics NWN 2013-01-29 Oct 31 Jan
29, 2013 HCP 2013-01-31 Nov 1 Nov 1, 2012 MSEX 2013-02-13 Nov 13 Nov 13,
2012
Although it's slower, because I need to do it one web page at a time, I get
most of my ex-dividend dates here:
=DATEVALUE(smfGetTa
http://research.
"&SUBSTITUTE(
However, I typically only do it for a dozen or so dividend champions that I
know have upcoming dividends. I would never do it for a large number of
ticker symbols. I mention my upcoming dividends workbook here:
http://finance.
On Sun, Jan 27, 2013 at 2:22 PM, calhandon bozo@donandcarla.
>
> > It would screw up that data item for people that are already handling
> that item as a text item. So it's not backward compatible.
>
> Good point. Can you add an additional optional parameter to
> RCHGetYahooQuotes(
> "Convert to Excel Date if returned value is recognized by Excel as a
> Date"? Just another one of the "0" or "1" parameters. Or would doing this
> then break all existing user calls to this function, that are sending only
> X number of parameters, when the new call would be looking for Y number of
> parameters? Sorry, but I'm not sure about variable number of parameters in
> VBA.
>
Possible, but inconvenient at this time. I really want the pDim1 and pDim2
parameters to be the last ones.
Sigh. Now I wish I had added a bunch of dummy parameters to all the
functions. :(
One other thing I had considered is that if I have to run the parsing
process through, maybe I could add a "q1" data code in addition to the "q"
data code.
> > And you'd still need to handle something at the end anyway, when Yahoo
> didn't pass a date (e.g. an "NA" value or such).
>
> It already does. If Excel can't recognize the returned string as a valid
> Date, the code does nothing. The existing string simply passes through the
> code, without change.
>
No. I meant on the user end. If YOU still get an NA returned from the
function, after date conversion, and need to use the date for something, it
still isn't a date, but a text string.
> > Unfortunately, it's not as simple as the given code, because the "items"
> list is not all 1-byte data codes. There are also 2-byte data codes, such
> as "l1" and "d1"
> in the list, popping them off one at a time. There would be no simple MID()
> function to use.
>
> Thank you for pointing this out. A single character look-ahead, looking
> for a numeric value, can be coded in an If statement, as shown below.
> Notes: dT is dimensioned as a Date at the beginning of the Function.
> iDblParam (double-parameter counter) is dimensioned as an Integer at the
> beginning of the Function, and is set to zero at the beginning of the parse
> section.
>
Yes, that would be one method of parsing the list. That would be a possible
way to incorporate the fake "q1" data code I mentioned earlier. Then a
parameter isn't needed for the function.
Personally, I've decided to not pursue this Ex-Dividend Date parsing,
> because any user code to automatically set a missing year would simply be a
> "best guess", which is not a good idea. It's better to visually see what
> Yahoo returns and make a human decision.
>
I noticed that when I created my table at the beginning of the message.
Since all of those dates were from 2012, the CDate() function would have
incorrectly assigned them to 2013. In most cases, with quarterly and
monthly dividends, that could be handled easily, just by comparing the
month of the sent date to the current month. But that wouldn't work well
for stocks with annual or irregular ex-dividend dates.
Details, details, details... :)
And, as I noted early on, Yahoo may not be a good source for ex-dividend
dates anyway...
Thank you again for replying to my code post, explaining additional
> conditions that needed to be taken into account. I really appreciate your
> time Randy, and thank you very much for all the work you do on the SMF
> add-in to keep it up-to-date, and answering all the messages here in the
> mailing list, which all seem to require additional research time and effort
> on your part as well. You are one amazing person!
>
> I would gladly send a donation but I read elsewhere that you prefer we
> send donations to a favorite charity, so that's what I'll do. My wife and
> I help support a local homeless shelter / soup kitchen, so we'll send them
> an additional $100 on your behalf (and no, we won't name you).
>
Thanks. I'm a believer of the "pay it forward" concept...
We can all use a little help now and then.
Sun Jan 27, 2013 5:42 pm (PST) . Posted by:
"bozo" calhandon
Thank you, yet again Randy, for your reply.
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.
With Google continually threatening to disconnect their web quote service, and other financial websites removing data or generating it dynamically (via scripts), our options are getting fewer and fewer. A few years ago, we opened minimal accounts at Scottrade and TD Ameritrade in order to utilize their non-web-based tools and APIs, which have since gone away. And Interactive Brokers wants you to have a minimum of $25,000 in your account in order to use their API.
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?
Thank you for the reference to your "upcoming dividends workbook", which is available at the following link:
SMF-Template-Upcoming-Dividend-Champions.xls
I'll take a look at it.
> Sigh. Now I wish I had added a bunch of dummy parameters to all the functions. :(
Hindsight sure is great, isn't it (lol)? But, if we knew then, what we know now, we probably would have never learned how to write computer programs in the first place.
> One other thing I had considered is that if I have to run the parsing process
through, maybe I could add a "q1" data code in addition to the "q" data code.
... Yes, that would be one method of parsing the list. That would be a possible
way to incorporate the fake "q1" data code I mentioned earlier. Then a
parameter isn't needed for the function.
I can hear the gears of your mind turning ... all the way out here (lol)!
> Since all of those dates were from 2012, the CDate() function would have incorrectly assigned them to 2013.
Yep, that's exactly what it did, which means, "additional coding required" (sigh).
> But that wouldn't work well for stocks with annual or irregular ex-dividend dates.
Yep, which is why I decided to just leave well enough alone. You and I might know when a date looks right, but trying to tell a computer how to know this? That's a whole 'nother story. But it was a fun learning experience going through one of your SMF functions and figuring out how it works. Which reminds me,
the smfYahooCodeDesc() function has a few duplicate entries in it. Might shave a nanosecond or two off of the processing time (grin).
> Thanks. I'm a believer of the "pay it forward" concept.
You're very welcome, Randy. So are we.
Cheers,
-Don
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"
With Google continually threatening to disconnect their web quote service, and other financial websites removing data or generating it dynamically (via scripts), our options are getting fewer and fewer. A few years ago, we opened minimal accounts at Scottrade and TD Ameritrade in order to utilize their non-web-based tools and APIs, which have since gone away. And Interactive Brokers wants you to have a minimum of $25,000 in your account in order to use their API.
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?
Thank you for the reference to your "upcoming dividends workbook"
SMF-Template-
I'll take a look at it.
> Sigh. Now I wish I had added a bunch of dummy parameters to all the functions. :(
Hindsight sure is great, isn't it (lol)? But, if we knew then, what we know now, we probably would have never learned how to write computer programs in the first place.
> One other thing I had considered is that if I have to run the parsing process
through, maybe I could add a "q1" data code in addition to the "q" data code.
... Yes, that would be one method of parsing the list. That would be a possible
way to incorporate the fake "q1" data code I mentioned earlier. Then a
parameter isn't needed for the function.
I can hear the gears of your mind turning ... all the way out here (lol)!
> Since all of those dates were from 2012, the CDate() function would have incorrectly assigned them to 2013.
Yep, that's exactly what it did, which means, "additional coding required" (sigh).
> But that wouldn't work well for stocks with annual or irregular ex-dividend dates.
Yep, which is why I decided to just leave well enough alone. You and I might know when a date looks right, but trying to tell a computer how to know this? That's a whole 'nother story. But it was a fun learning experience going through one of your SMF functions and figuring out how it works. Which reminds me,
the smfYahooCodeDesc(
> Thanks. I'm a believer of the "pay it forward" concept.
You're very welcome, Randy. So are we.
Cheers,
-Don
Sun Jan 27, 2013 6:44 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
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.
>
> 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"
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(
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"
> 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.
Sun Jan 27, 2013 6:59 pm (PST) . Posted by:
"D DAR" randyr_cds
Instead of doing a ticker-based retrieval, could you aggregate multiple
date-based retrievals from earnings.com? I don't know how accurate their
data is.
http://earnings.com/dividend.asp?date=20130128&client=cb
Randy
On Sun, Jan 27, 2013 at 9:44 PM, Randy Harmelink rharmelink@gmail.com >wrote:
> **
>
>
> 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.
>
>
>
>
date-based retrievals from earnings.com? I don't know how accurate their
data is.
http://earnings.
Randy
On Sun, Jan 27, 2013 at 9:44 PM, Randy Harmelink rharmelink@gmail.
> **
>
>
> 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"
> 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(
> 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"
> > 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.
>
>
>
>
Sun Jan 27, 2013 7:30 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It would be better to get it by the week, instead of by the day:
http://earnings.com/dividend_week.asp?date=20130128&client=cb
...but right now it doesn't have either the HCP or MSEX ex-dividend date.
But there are a lot of tickers to be extracted from the web page, and not a
trivial extraction because it would need to be from the links on the web
page.
On Sun, Jan 27, 2013 at 7:59 PM, D DAR positive.theta@gmail.com > wrote:
>
> Instead of doing a ticker-based retrieval, could you aggregate multiple
> date-based retrievals from earnings.com? I don't know how accurate their
> data is.
>
> http://earnings.com/dividend.asp?date=20130128&client=cb
>
http://earnings.
...but right now it doesn't have either the HCP or MSEX ex-dividend date.
But there are a lot of tickers to be extracted from the web page, and not a
trivial extraction because it would need to be from the links on the web
page.
On Sun, Jan 27, 2013 at 7:59 PM, D DAR positive.theta@
>
> Instead of doing a ticker-based retrieval, could you aggregate multiple
> date-based retrievals from earnings.com? I don't know how accurate their
> data is.
>
> http://earnings.
>
Sun Jan 27, 2013 8:16 pm (PST) . Posted by:
"D DAR" randyr_cds
The daily page presents the all of the tickers on the same page, so the
links for each company link wouldn't need to be followed. But, it wouldn't
account for missing companies such as HCP or MSEX.
On Sun, Jan 27, 2013 at 10:30 PM, Randy Harmelink rharmelink@gmail.com >wrote:
> **
>
>
> It would be better to get it by the week, instead of by the day:
>
> http://earnings.com/dividend_week.asp?date=20130128&client=cb
>
> ...but right now it doesn't have either the HCP or MSEX ex-dividend date.
> But there are a lot of tickers to be extracted from the web page, and not a
> trivial extraction because it would need to be from the links on the web
> page.
>
>
> On Sun, Jan 27, 2013 at 7:59 PM, D DAR positive.theta@gmail.com > wrote:
>
>>
>> Instead of doing a ticker-based retrieval, could you aggregate multiple
>> date-based retrievals from earnings.com? I don't know how accurate
>> their data is.
>>
>> http://earnings.com/dividend.asp?date=20130128&client=cb
>>
>
>
>
links for each company link wouldn't need to be followed. But, it wouldn't
account for missing companies such as HCP or MSEX.
On Sun, Jan 27, 2013 at 10:30 PM, Randy Harmelink rharmelink@gmail.
> **
>
>
> It would be better to get it by the week, instead of by the day:
>
> http://earnings.
>
> ...but right now it doesn't have either the HCP or MSEX ex-dividend date.
> But there are a lot of tickers to be extracted from the web page, and not a
> trivial extraction because it would need to be from the links on the web
> page.
>
>
> On Sun, Jan 27, 2013 at 7:59 PM, D DAR positive.theta@
>
>>
>> Instead of doing a ticker-based retrieval, could you aggregate multiple
>> date-based retrievals from earnings.com? I don't know how accurate
>> their data is.
>>
>> http://earnings.
>>
>
>
>
Sun Jan 27, 2013 10:15 am (PST) . Posted by:
"Randy Harmelink" rharmelink
What you can do is create a file in the same folder as add-in, called
"smf-AdvFN-Prefix.txt", All the file should contain is the two letters
"uk". You can create the file with Notepad. This file overrides the add-in
default, and the add-in will then use the "uk" version of the URL instead
of the default "www" version of the URL.
You'll need the 2.1.2012.12.29 version of the add-in for this to work...
On Sun, Jan 27, 2013 at 7:26 AM, Rosendo Manuel rosendo.jose@gmail.com >wrote:
>
> I'm living in Lisbon (Portugal) and you are right. When I entered your
> suggested address the browser redirected me to "
> http://uk.advfn.com/p.php?pid=financials&symbol=MMM ".
> Is there a way to force it to work properly (as I desire, of course :))?
>
"smf-AdvFN-
"uk"
default, and the add-in will then use the "uk" version of the URL instead
of the default "www" version of the URL.
You'll need the 2.1.2012.12.
On Sun, Jan 27, 2013 at 7:26 AM, Rosendo Manuel rosendo.jose@
>
> I'm living in Lisbon (Portugal) and you are right. When I entered your
> suggested address the browser redirected me to "
> http://uk.advfn.
> Is there a way to force it to work properly (as I desire, of course :))?
>
Sun Jan 27, 2013 10:16 pm (PST) . Posted by:
"Roger" rogerdiazbernal
Hi Randy:How I can get the implied volatility of www.ivolatility.comi.e.
for
QQQhttp://www.ivolatility.com/options.j?ticker=QQQ&R=0&top_lookup__is__s\
ent=1
I need data for: Current / 52wk High Date /52 wk Low Date of IV Index
meanThese data are in Table Implied Volatility / IV Index mean
Roger
for
QQQhttp://www.
ent=1
I need data for: Current / 52wk High Date /52 wk Low Date of IV Index
meanThese data are in Table Implied Volatility / IV Index mean
Roger
Sun Jan 27, 2013 11:20 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Not a trivial task -- see:
http://finance.groups.yahoo.com/group/smf_addin/message/9476
http://finance.groups.yahoo.com/group/smf_addin/message/9744
...and the Problem-ivolatility-data-extraction.xls file in the "Requested
samples" folder of the files area, which gets the implied volatility values
from the CBOE website. However, you do need to create the correct security
cookie first, before it will work. And the extraction process is not
trivial, as you'll note from the workbook, since it's extracting the data
from JavaScript code instead of out of tables.
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
>
>
http://finance.
http://finance.
...and the Problem-ivolatility
samples" folder of the files area, which gets the implied volatility values
from the CBOE website. However, you do need to create the correct security
cookie first, before it will work. And the extraction process is not
trivial, as you'll note from the workbook, since it's extracting the data
from JavaScript code instead of out of tables.
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
>
>
Sun Jan 27, 2013 10:21 pm (PST) . Posted by:
"tenenbaum88" tenenbaum88
Hi Randy,
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.
If anyone else has any insight here too, please feel free to chime in. Thanks in advance and thanks again, Randy, for making such brilliant software.
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.
If anyone else has any insight here too, please feel free to chime in. Thanks in advance and thanks again, Randy, for making such brilliant software.
Sun Jan 27, 2013 11:25 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
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 kenneth.dooley@gmail.com >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.
>
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 kenneth.dooley@
>
> 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 5:09 am (PST) . Posted by:
"tenenbaum88" tenenbaum88
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.
> >
>
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 6:10 am (PST) . Posted by:
"Simona G" simona4051
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.
> > >
> >
>
>
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.
> > >
> >
>
>
Tidak ada komentar:
Posting Komentar