3 New Messages
Digest #2323
| |
Messages
Thu Aug 23, 2012 6:24 pm (PDT) . Posted by:
"Ron Spruell" hashky
Randy -
Yahoo's option symbols seem to be loaded with invalid symbols. CSCO, MSFT. I am sure there are many more.
I rewrote the formula to get the correct date based on the position of the first "1" instead of the length of the symbol. It seems to work even with the invalid option symbols. The prices returned are close to those of the equivalent valid symbol.
=IF(G5>"",DATEVALUE(MID(G5,FIND("1",G5)+2,2)&"/"&MID(G5,FIND("1",G5)+4,2)&"/"&MID(G5,FIND("1",G5)+0,2)),"")
It will be a valid formula until 2020. :) Remind me to change it if we are still around and have a country.
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Wednesday, August 22, 2012 3:25 PM
>Subject: Re: [smf_addin] RCHGetTableCell - Template
>
>
>
>It's not working because Yahoo has invalid option symbols in their CSCO tables. For example:
>
>CSCO120922C0001000
>CSCO120922C00010000
>
>These look like they're meant to be the same ticker symbol (and the web page cites the same prices), but note that the first ticker symbol is too short. So when it tries to extract the date, it's in the wrong location.
>
>
>On Wed, Aug 22, 2012 at 1:12 PM, Ron Spruell <hashky@yahoo.com > wrote:
>
>
>>
>>This file does not get all the option expiry dates for CSCO. It does for CAT. It looks like it needs an if statement (or something) to get the proper link. Have you encountered this problem? If so, do you have a solution.
>>
>>Files > Templates and Examples >
RCHGetTableCell RCHGetTableCell-Template-Yahoo-Options-Quotes.xls
>>
>
>
>
>
Yahoo's option symbols seem to be loaded with invalid symbols. CSCO, MSFT. I am sure there are many more.
I rewrote the formula to get the correct date based on the position of the first "1" instead of the length of the symbol. It seems to work even with the invalid option symbols. The prices returned are close to those of the equivalent valid symbol.
=IF(G5>"",DATEVALUE
It will be a valid formula until 2020. :) Remind me to change it if we are still around and have a country.
>___________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Wednesday, August 22, 2012 3:25 PM
>Subject: Re: [smf_addin] RCHGetTableCell - Template
>
>
>
>It's not working because Yahoo has invalid option symbols in their CSCO tables. For example:
>
>CSCO120922C0001000
>CSCO120922C0001000
>
>These look like they're meant to be the same ticker symbol (and the web page cites the same prices), but note that the first ticker symbol is too short. So when it tries to extract the date, it's in the wrong location.
>
>
>On Wed, Aug 22, 2012 at 1:12 PM, Ron Spruell <hashky@yahoo.
>
>
>>
>>This file does not get all the option expiry dates for CSCO. It does for CAT. It looks like it needs an if statement (or something) to get the proper link. Have you encountered this problem? If so, do you have a solution.
>>
>>Files > Templates and Examples >
RCHGetTableCell RCHGetTableCell-
>>
>
>
>
>
Thu Aug 23, 2012 6:34 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Personally, I think you'd be better off getting the option quotes using the
option-specific functions. See:
http://finance.groups.yahoo.com/group/smf_addin/message/17234
Or, rather than using the "1", you could search for the "C" or "P" after
the 6th byte. The previous 6 digits would be the date. Then, 2020 is an
issue. :)
The other issue is that in the past those invalid ticker symbols have had
stale data on them. So, really, they should be ignored. But difficult to do
in an extraction that is all based on relative location.
On Thu, Aug 23, 2012 at 6:24 PM, Ron Spruell <hashky@yahoo.com > wrote:
>
> Yahoo's option symbols seem to be loaded with invalid symbols. CSCO,
> MSFT. I am sure there are many more.
>
> I rewrote the formula to get the correct date based on the position of the
> first "1" instead of the length of the symbol. It seems to work even with
> the invalid option symbols. The prices returned are close to those of the
> equivalent valid symbol.
>
>
> =IF(G5>"",DATEVALUE(MID(G5,FIND("1",G5)+2,2)&"/"&MID(G5,FIND("1",G5)+4,2)&"/"&MID(G5,FIND("1",G5)+0,2)),"")
>
> It will be a valid formula until 2020. :) Remind me to change it if we
> are still around and have a country.
>
option-specific functions. See:
http://finance.
Or, rather than using the "1", you could search for the "C" or "P" after
the 6th byte. The previous 6 digits would be the date. Then, 2020 is an
issue. :)
The other issue is that in the past those invalid ticker symbols have had
stale data on them. So, really, they should be ignored. But difficult to do
in an extraction that is all based on relative location.
On Thu, Aug 23, 2012 at 6:24 PM, Ron Spruell <hashky@yahoo.
>
> Yahoo's option symbols seem to be loaded with invalid symbols. CSCO,
> MSFT. I am sure there are many more.
>
> I rewrote the formula to get the correct date based on the position of the
> first "1" instead of the length of the symbol. It seems to work even with
> the invalid option symbols. The prices returned are close to those of the
> equivalent valid symbol.
>
>
> =IF(G5>"",DATEVALUE
>
> It will be a valid formula until 2020. :) Remind me to change it if we
> are still around and have a country.
>
Fri Aug 24, 2012 3:34 am (PDT) . Posted by:
"Ron Spruell" hashky
I will look into OX to see if it will do what I want to do. I normally write At The Money Cash Secured Puts 3 to 24 months out. I like to look at several Expiry dates and pick the one that gets the stock at the price I want, and has a reasonable return. I do about the same thing on CC.
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Thursday, August 23, 2012 8:34 PM
>Subject: Re: [smf_addin] RCHGetTableCell - Template
>
>
>
>Personally, I think you'd be better off getting the option quotes using the option-specific functions. See:
>
>http://finance.groups.yahoo.com/group/smf_addin/message/17234
>
>Or, rather than using the "1", you could search for the "C" or "P" after the 6th byte. The previous 6 digits would be the date. Then, 2020 is an issue. :)
>
>The other issue is that in the past those invalid ticker symbols have had stale data on them. So, really, they should be ignored. But difficult to do in an extraction that is all based on relative location.
>
>
>On Thu, Aug 23, 2012 at 6:24 PM, Ron Spruell <hashky@yahoo.com > wrote:
>
>
>>
>>Yahoo's option symbols seem to be loaded with invalid symbols. CSCO, MSFT. I am sure there are many more.
>>
>>
>>
>>I rewrote the formula to get the correct date based on the position of the first "1" instead of the length of the symbol. It seems to work even with the invalid option symbols. The prices returned are close to those of the equivalent valid symbol.
>>
>>
>>
>>=IF(G5>"",DATEVALUE(MID(G5,FIND("1",G5)+2,2)&"/"&MID(G5,FIND("1",G5)+4,2)&"/"&MID(G5,FIND("1",G5)+0,2)),"")
>>
>>
>>It will be a valid formula until 2020. :) Remind me to change it if we are still around and have a country.
>>
>
>
>
>
>___________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Thursday, August 23, 2012 8:34 PM
>Subject: Re: [smf_addin] RCHGetTableCell - Template
>
>
>
>Personally, I think you'd be better off getting the option quotes using the option-specific functions. See:
>
>http://finance.
>
>Or, rather than using the "1", you could search for the "C" or "P" after the 6th byte. The previous 6 digits would be the date. Then, 2020 is an issue. :)
>
>The other issue is that in the past those invalid ticker symbols have had stale data on them. So, really, they should be ignored. But difficult to do in an extraction that is all based on relative location.
>
>
>On Thu, Aug 23, 2012 at 6:24 PM, Ron Spruell <hashky@yahoo.
>
>
>>
>>Yahoo's option symbols seem to be loaded with invalid symbols. CSCO, MSFT. I am sure there are many more.
>>
>>
>>
>>I rewrote the formula to get the correct date based on the position of the first "1" instead of the length of the symbol. It seems to work even with the invalid option symbols. The prices returned are close to those of the equivalent valid symbol.
>>
>>
>>
>>=IF(G5>"",
>>
>>
>>It will be a valid formula until 2020. :) Remind me to change it if we are still around and have a country.
>>
>
>
>
>
Tidak ada komentar:
Posting Komentar