15 New Messages
Digest #2292
Messages
Fri Jul 27, 2012 5:42 am (PDT) . Posted by:
"Ron Spruell" hashky
Randy -
For some reason (First Day of Fall?), the option closing date was changed from 9/22/2012 to 9/21/2012. I looked at the page source code. It is different for this particular month.
This is the front end of my calculation of option returns.
Am I missing something? Is my code wrong? Is there an EASY fix for this? If it was really easy, I could fix it.
Ron Spruell
For some reason (First Day of Fall?), the option closing date was changed from 9/22/2012 to 9/21/2012. I looked at the page source code. It is different for this particular month.
This is the front end of my calculation of option returns.
Am I missing something? Is my code wrong? Is there an EASY fix for this? If it was really easy, I could fix it.
Ron Spruell
Attachments with this message:
1 of 1 File(s)
Fri Jul 27, 2012 9:08 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
What is the issue? I'm lost.
On Fri, Jul 27, 2012 at 5:42 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
> For some reason (First Day of Fall?), the option closing date was changed
> from 9/22/2012 to 9/21/2012. I looked at the page source code. It is
> different for this particular month.
>
> This is the front end of my calculation of option returns.
>
> Am I missing something? Is my code wrong? Is there an EASY fix for
> this? If it was really easy, I could fix it.
>
>
On Fri, Jul 27, 2012 at 5:42 AM, Ron Spruell <hashky@yahoo.
>
> For some reason (First Day of Fall?), the option closing date was changed
> from 9/22/2012 to 9/21/2012. I looked at the page source code. It is
> different for this particular month.
>
> This is the front end of my calculation of option returns.
>
> Am I missing something? Is my code wrong? Is there an EASY fix for
> this? If it was really easy, I could fix it.
>
>
Fri Jul 27, 2012 9:51 am (PDT) . Posted by:
"Ron Spruell" hashky
The issue is that the date returned by the Excel code is Saturday, 9/22/2012. The options actually expire on Friday, 9/21/2012. I just checked cboe.com and the Expiration date is 9/22/2012. So the issue is that Yahoo has the wrong Expiry date in September. Sorrry I posted.
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Friday, July 27, 2012 11:08 AM
>Subject: Re: [smf_addin] RCHGetWebData()-Expiry Date Error - Yahoo
>
>
>
>What is the issue? I'm lost.
>
>
>On Fri, Jul 27, 2012 at 5:42 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
>
>>
>>For some reason (First Day of Fall?), the option closing date was changed from 9/22/2012 to 9/21/2012. I looked at the page source code. It is different for this particular month.
>>
>>
>>
>>This is the front end of my calculation of option returns.
>>
>>
>>Am I missing something? Is my code wrong? Is there an EASY fix for this? If it was really easy, I could fix it.
>>
>
>
>
>
>___________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Friday, July 27, 2012 11:08 AM
>Subject: Re: [smf_addin] RCHGetWebData(
>
>
>
>What is the issue? I'm lost.
>
>
>On Fri, Jul 27, 2012 at 5:42 AM, Ron Spruell <hashky@yahoo.
>
>
>>
>>For some reason (First Day of Fall?), the option closing date was changed from 9/22/2012 to 9/21/2012. I looked at the page source code. It is different for this particular month.
>>
>>
>>
>>This is the front end of my calculation of option returns.
>>
>>
>>Am I missing something? Is my code wrong? Is there an EASY fix for this? If it was really easy, I could fix it.
>>
>
>
>
>
Fri Jul 27, 2012 9:57 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Actually, options do expire on Saturday. Friday is just the last trading
day.
If you'll note on this page:
http://finance.yahoo.com/q/op?s=MMM&m=2012-09
Yahoo does say the options expire on Friday, 9/21. However, if you look at
the ticker symbols for the options, they have a 9/22 expiration date. For
example:
http://finance.yahoo.com/q?s=MMM*120922*C00082500
On Fri, Jul 27, 2012 at 9:51 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
> The issue is that the date returned by the Excel code is Saturday,
> 9/22/2012. The options actually expire on Friday, 9/21/2012. I just
> checked cboe.com and the Expiration date is 9/22/2012. So the issue is
> that Yahoo has the wrong Expiry date in September. Sorrry I posted.
>
day.
If you'll note on this page:
http://finance.
Yahoo does say the options expire on Friday, 9/21. However, if you look at
the ticker symbols for the options, they have a 9/22 expiration date. For
example:
http://finance.
On Fri, Jul 27, 2012 at 9:51 AM, Ron Spruell <hashky@yahoo.
>
> The issue is that the date returned by the Excel code is Saturday,
> 9/22/2012. The options actually expire on Friday, 9/21/2012. I just
> checked cboe.com and the Expiration date is 9/22/2012. So the issue is
> that Yahoo has the wrong Expiry date in September. Sorrry I posted.
>
Fri Jul 27, 2012 6:58 am (PDT) . Posted by:
"Chirag Vyas" vyas.chirag
I need market cap and sector parsing for multiple UK tickers from Yahoo finance to spreadsheet.
Eg:- For VOD.L Market Cap given is 89.93bn
http://finance.yahoo.com/q?s=VOD.L&ql=1
Sector "Technology" is mentioned on profile page
http://finance.yahoo.com/q/pr?s=VOD.L+Profile
Thanks,
Chirag Vyas
Eg:- For VOD.L Market Cap given is 89.93bn
http://finance.
Sector "Technology" is mentioned on profile page
http://finance.
Thanks,
Chirag Vyas
Fri Jul 27, 2012 8:41 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Why don't use download the documentation and do a search thru the
RCHGetElementNumber-Element-Definitions.xls file?
You'll find every definition there. It even tells you what template has and
example on how to use it.
I'm as guilty as the everyone when it comes to doing our research. It is
easier to ask others and Randy seldom, if ever, disappoints.
Kermit
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Chirag Vyas
Sent: Friday, July 27, 2012 9:59 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Market Cap and Sector for UK tickers from Yahoo
Finance.
I need market cap and sector parsing for multiple UK tickers from Yahoo
finance to spreadsheet.
Eg:- For VOD.L Market Cap given is 89.93bn
<http://finance.yahoo.com/q?s=VOD.L&ql=1 >
http://finance.yahoo.com/q?s=VOD.L&ql=1
Sector "Technology" is mentioned on profile page
<http://finance.yahoo.com/q/pr?s=VOD.L+Profile >
http://finance.yahoo.com/q/pr?s=VOD.L+Profile
Thanks,
Chirag Vyas
------------------------------------
Yahoo! Groups Links
(Yahoo! ID required)
<mailto:smf_addin-fullfeatured@yahoogroups.com >
smf_addin-fullfeatured@yahoogroups.com
RCHGetElementNumber
You'll find every definition there. It even tells you what template has and
example on how to use it.
I'm as guilty as the everyone when it comes to doing our research. It is
easier to ask others and Randy seldom, if ever, disappoints.
Kermit
-----Original Message-----
From: smf_addin@yahoogrou
Of Chirag Vyas
Sent: Friday, July 27, 2012 9:59 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Market Cap and Sector for UK tickers from Yahoo
Finance.
I need market cap and sector parsing for multiple UK tickers from Yahoo
finance to spreadsheet.
Eg:- For VOD.L Market Cap given is 89.93bn
<http://finance.
http://finance.
Sector "Technology" is mentioned on profile page
<http://finance.
http://finance.
Thanks,
Chirag Vyas
------------
Yahoo! Groups Links
(Yahoo! ID required)
<mailto:smf_addin-fullfeatu
smf_addin-fullfeatu
Fri Jul 27, 2012 7:08 am (PDT) . Posted by:
"Ron" rlcarr71
Yes, just switch to the built in codes for Yahoo finance.
=RCHGetElementNumber("MMM", 990)
Make sure you take time to look at the spreadsheet in the directory you installed the add-in.
RCHGetElementNumber-Element-Definitions.xls
In addition to current yield, you can pull forward yield (4925), trailing yield (4927) and 5 year avg yield (4928).
Happy Investing.
Ron
--- In smf_addin@yahoogroups.com , Chirag Vyas <vyas.chirag@...> wrote:
>
> Hi, thanks. Is it possible to get only "Yield" value instead of "Div/Yield"?
> Â
> Regards,
> Chirag Vyas,
> (+91)9833630022
>
>
> ________________________________
> From: Randy Harmelink <rharmelink@...>
> To: smf_addin@yahoogroups.com
> Sent: Monday, 23 July 2012 3:22 PM
> Subject: Re: [smf_addin] Dividend Yield for tickers from Google Finance
>
>
> Â
> Try:
>
> =RCHGetTableCell("http://www.google.com/finance?q=MMM ",1,"Div/Yield")
>
>
> On Mon, Jul 23, 2012 at 2:37 AM, Chirag Vyas <vyas.chirag@...> wrote:
>
> I need the value of Dividend Yield for several tickers in Excel. This value is mentioned in Google finance as DIV/YIELD.
> >
>
=RCHGetElementNumbe
Make sure you take time to look at the spreadsheet in the directory you installed the add-in.
RCHGetElementNumber
In addition to current yield, you can pull forward yield (4925), trailing yield (4927) and 5 year avg yield (4928).
Happy Investing.
Ron
--- In smf_addin@yahoogrou
>
> Hi, thanks. Is it possible to get only "Yield" value instead of "Div/Yield"?
> Â
> Regards,
> Chirag Vyas,
> (+91)9833630022
>
>
> ____________
> From: Randy Harmelink <rharmelink@
> To: smf_addin@yahoogrou
> Sent: Monday, 23 July 2012 3:22 PM
> Subject: Re: [smf_addin] Dividend Yield for tickers from Google Finance
>
>
> Â
> Try:
>
> =RCHGetTableCell(
>
>
> On Mon, Jul 23, 2012 at 2:37 AM, Chirag Vyas <vyas.chirag@
>
> I need the value of Dividend Yield for several tickers in Excel. This value is mentioned in Google finance as DIV/YIELD.
> >
>
Fri Jul 27, 2012 8:42 am (PDT) . Posted by:
"whitney" thelancour
Is it possible to use smf add in for extracting data off webpages with inner html's?
Fri Jul 27, 2012 9:10 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not quite sure what you're asking, but it all depends on the web page.
On Fri, Jul 27, 2012 at 8:42 AM, whitney <thelancour@yahoo.com > wrote:
> Is it possible to use smf add in for extracting data off webpages with
> inner html's?
>
On Fri, Jul 27, 2012 at 8:42 AM, whitney <thelancour@yahoo.
> Is it possible to use smf add in for extracting data off webpages with
> inner html's?
>
Fri Jul 27, 2012 9:05 am (PDT) . Posted by:
"zarathustra_winced@yahoo.com" zarathustra_winced
When did Advfn.com start offering quarterly reports back to 1994? I thought it went only 5 years back.
Sent via BlackBerry by AT&T
Sent via BlackBerry by AT&T
Fri Jul 27, 2012 9:08 am (PDT) . Posted by:
"zarathustra_winced@yahoo.com" zarathustra_winced
Wow and 20 years for annual.
Sent via BlackBerry by AT&T
-----Original Message-----
From: zarathustra_winced@yahoo.com
Sender: smf_addin@yahoogroups.com
Date: Fri, 27 Jul 2012 16:04:54
To: <smf_addin@yahoogroups.com >
Reply-To: smf_addin@yahoogroups.com
Subject: [smf_addin] Advfn
When did Advfn.com start offering quarterly reports back to 1994? I thought it went only 5 years back.
Sent via BlackBerry by AT&T
------------------------------------
Yahoo! Groups Links
Sent via BlackBerry by AT&T
-----Original Message-----
From: zarathustra_
Sender: smf_addin@yahoogrou
Date: Fri, 27 Jul 2012 16:04:54
To: <smf_addin@yahoogrou
Reply-To: smf_addin@yahoogrou
Subject: [smf_addin] Advfn
When did Advfn.com start offering quarterly reports back to 1994? I thought it went only 5 years back.
Sent via BlackBerry by AT&T
------------
Yahoo! Groups Links
Fri Jul 27, 2012 9:10 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's always been that way....
On Fri, Jul 27, 2012 at 9:04 AM, <zarathustra_winced@yahoo.com > wrote:
> When did Advfn.com start offering quarterly reports back to 1994? I
> thought it went only 5 years back.
>
On Fri, Jul 27, 2012 at 9:04 AM, <zarathustra_
> When did Advfn.com start offering quarterly reports back to 1994? I
> thought it went only 5 years back.
>
Fri Jul 27, 2012 9:29 am (PDT) . Posted by:
"zarathustra_winced@yahoo.com" zarathustra_winced
Does the add-in have functionality to access those reports by element numbers? I only see element numbers defined for 10 annuals and 20 quarterlies, unless I missed something.
Sent via BlackBerry by AT&T
-----Original Message-----
From: Randy Harmelink <rharmelink@gmail.com >
Sender: smf_addin@yahoogroups.com
Date: Fri, 27 Jul 2012 09:10:56
To: <smf_addin@yahoogroups.com >
Reply-To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Advfn
It's always been that way....
On Fri, Jul 27, 2012 at 9:04 AM, <zarathustra_winced@yahoo.com > wrote:
> When did Advfn.com start offering quarterly reports back to 1994? I
> thought it went only 5 years back.
>
Sent via BlackBerry by AT&T
-----Original Message-----
From: Randy Harmelink <rharmelink@gmail.
Sender: smf_addin@yahoogrou
Date: Fri, 27 Jul 2012 09:10:56
To: <smf_addin@yahoogrou
Reply-To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Advfn
It's always been that way....
On Fri, Jul 27, 2012 at 9:04 AM, <zarathustra_
> When did Advfn.com start offering quarterly reports back to 1994? I
> thought it went only 5 years back.
>
Fri Jul 27, 2012 9:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's all I defined elements for. However, the smfGetAdvFNElement()
function can access all of it.
On Fri, Jul 27, 2012 at 9:29 AM, <zarathustra_winced@yahoo.com > wrote:
>
> Does the add-in have functionality to access those reports by element
> numbers? I only see element numbers defined for 10 annuals and 20
> quarterlies, unless I missed something.
>
function can access all of it.
On Fri, Jul 27, 2012 at 9:29 AM, <zarathustra_
>
> Does the add-in have functionality to access those reports by element
> numbers? I only see element numbers defined for 10 annuals and 20
> quarterlies, unless I missed something.
>
Fri Jul 27, 2012 9:53 am (PDT) . Posted by:
"zarathustra_winced@yahoo.com" zarathustra_winced
You're the man! Thanks!
Sent via BlackBerry by AT&T
-----Original Message-----
From: Randy Harmelink <rharmelink@gmail.com >
Sender: smf_addin@yahoogroups.com
Date: Fri, 27 Jul 2012 09:46:49
To: <smf_addin@yahoogroups.com >
Reply-To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Advfn
That's all I defined elements for. However, the smfGetAdvFNElement()
function can access all of it.
On Fri, Jul 27, 2012 at 9:29 AM, <zarathustra_winced@yahoo.com > wrote:
>
> Does the add-in have functionality to access those reports by element
> numbers? I only see element numbers defined for 10 annuals and 20
> quarterlies, unless I missed something.
>
Sent via BlackBerry by AT&T
-----Original Message-----
From: Randy Harmelink <rharmelink@gmail.
Sender: smf_addin@yahoogrou
Date: Fri, 27 Jul 2012 09:46:49
To: <smf_addin@yahoogrou
Reply-To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Advfn
That's all I defined elements for. However, the smfGetAdvFNElement(
function can access all of it.
On Fri, Jul 27, 2012 at 9:29 AM, <zarathustra_
>
> Does the add-in have functionality to access those reports by element
> numbers? I only see element numbers defined for 10 annuals and 20
> quarterlies, unless I missed something.
>
Tidak ada komentar:
Posting Komentar