6 New Messages
Digest #2622
1a
Re: Yahoo .CSV (smfPricesByDates and RCHGetYahooHistory) not Adjusti by "Randy Harmelink" rharmelink
Messages
Fri May 17, 2013 2:29 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried the two formulas, and I got the $129.91 an $72.47...
My CSV file was correct as well.
As you note, hopefully just a temporary glitch on Yahoo's part?
On Fri, May 17, 2013 at 1:05 AM, anagoge <anagoge@yahoo.com > wrote:
> I'm unable to get smfPricesByDates and RCHGetYahooHistory to adjust for
> dividends. For example, both of these:
> =smfPricesByDates("VIIIX";,"12/31/2012") = 130.53 instead of Adj of 129.91
> =smfPricesByDates("IWD","12/31/2012") = 72.82 instead of Adj of 72.47
>
> return the values under Close instead of Adj Close on the web site based
> on these reference Links:
>
> http://finance.yahoo.com/q/hp?s=VIIIX&d=4&e=17&f=2013&g=d&a=7&b=19&c=1997&z=66&y=66
>
> http://finance.yahoo.com/q/hp?s=IWD&d=4&e=17&f=2013&g=d&a=4&b=26&c=2000&z=66&y=66
>
> The web site numbers seem to properly adjust for dividends, but the link
> at the bottom to download the .csv does not adjust for dividends (Close =
> Adj Close) for that date. I assume this is a Yahoo bug, and there is
> nothing we can do about it? Or maybe the web site data and csv data get
> calculated/updated on different schedules?
>
My CSV file was correct as well.
As you note, hopefully just a temporary glitch on Yahoo's part?
On Fri, May 17, 2013 at 1:05 AM, anagoge <anagoge@yahoo.
> I'm unable to get smfPricesByDates and RCHGetYahooHistory to adjust for
> dividends. For example, both of these:
> =smfPricesByDates(
> =smfPricesByDates(
>
> return the values under Close instead of Adj Close on the web site based
> on these reference Links:
>
> http://finance.
>
> http://finance.
>
> The web site numbers seem to properly adjust for dividends, but the link
> at the bottom to download the .csv does not adjust for dividends (Close =
> Adj Close) for that date. I assume this is a Yahoo bug, and there is
> nothing we can do about it? Or maybe the web site data and csv data get
> calculated/updated on different schedules?
>
Fri May 17, 2013 3:11 am (PDT) . Posted by:
"anagoge" anagoge
I'm also getting the expected numbers now, so it looks like it was a temporary glitch. Thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I just tried the two formulas, and I got the $129.91 an $72.47...
>
> My CSV file was correct as well.
>
> As you note, hopefully just a temporary glitch on Yahoo's part?
>
> On Fri, May 17, 2013 at 1:05 AM, anagoge <anagoge@...> wrote:
>
> > I'm unable to get smfPricesByDates and RCHGetYahooHistory to adjust for
> > dividends. For example, both of these:
> > =smfPricesByDates("VIIIX";,"12/31/2012") = 130.53 instead of Adj of 129.91
> > =smfPricesByDates("IWD","12/31/2012") = 72.82 instead of Adj of 72.47
> >
> > return the values under Close instead of Adj Close on the web site based
> > on these reference Links:
> >
> > http://finance.yahoo.com/q/hp?s=VIIIX&d=4&e=17&f=2013&g=d&a=7&b=19&c=1997&z=66&y=66
> >
> > http://finance.yahoo.com/q/hp?s=IWD&d=4&e=17&f=2013&g=d&a=4&b=26&c=2000&z=66&y=66
> >
> > The web site numbers seem to properly adjust for dividends, but the link
> > at the bottom to download the .csv does not adjust for dividends (Close =
> > Adj Close) for that date. I assume this is a Yahoo bug, and there is
> > nothing we can do about it? Or maybe the web site data and csv data get
> > calculated/updated on different schedules?
> >
>
--- In smf_addin@yahoogrou
>
> I just tried the two formulas, and I got the $129.91 an $72.47...
>
> My CSV file was correct as well.
>
> As you note, hopefully just a temporary glitch on Yahoo's part?
>
> On Fri, May 17, 2013 at 1:05 AM, anagoge <anagoge@
>
> > I'm unable to get smfPricesByDates and RCHGetYahooHistory to adjust for
> > dividends. For example, both of these:
> > =smfPricesByDates(
> > =smfPricesByDates(
> >
> > return the values under Close instead of Adj Close on the web site based
> > on these reference Links:
> >
> > http://finance.
> >
> > http://finance.
> >
> > The web site numbers seem to properly adjust for dividends, but the link
> > at the bottom to download the .csv does not adjust for dividends (Close =
> > Adj Close) for that date. I assume this is a Yahoo bug, and there is
> > nothing we can do about it? Or maybe the web site data and csv data get
> > calculated/updated on different schedules?
> >
>
Fri May 17, 2013 2:31 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
smfForceRecalculation forces the add-in to reload ALL web pages that are
needed. If you're getting data from a lot of different web pages, that can
take some time.
However, going back to a previously loaded ticker should be quick, because
it will just use the previously saved web pages, and doesn't go back to the
web for a fresh copy of the web page.
That's the different between and EXCEL recalculate and
smfForceRecalculation -- updates of the saved web pages.
On Fri, May 17, 2013 at 1:28 AM, sri yanto <sri.yanto@yahoo.com > wrote:
>
> l had tried smfforcecalculation for the woorbook
>
> it's works properly, and any ticker that before can't load,
> now can loaded
>
> but it take slower than before
> does always like that?
>
needed. If you're getting data from a lot of different web pages, that can
take some time.
However, going back to a previously loaded ticker should be quick, because
it will just use the previously saved web pages, and doesn't go back to the
web for a fresh copy of the web page.
That's the different between and EXCEL recalculate and
smfForceRecalculati
On Fri, May 17, 2013 at 1:28 AM, sri yanto <sri.yanto@yahoo.
>
> l had tried smfforcecalculation for the woorbook
>
> it's works properly, and any ticker that before can't load,
> now can loaded
>
> but it take slower than before
> does always like that?
>
Fri May 17, 2013 7:53 am (PDT) . Posted by:
"PeteA" option2z
Willem,
I've been using Excel 2013 for quite a while. Don't get that message. BUT,
I do have 16GB of memory. My guess is that something else is wrong.
Perhaps you should try a reinstall, or a repair of excel (from the control
panel). If you have a 2013 subscription, it will do a full reinstall with
almost no effort, and takes (in my network world) less than 5 minutes.
Pete A
RE:
<mailto:willemlenaerts@
"willemlenaert
Hello everybody,
Just updated to Excel 2013, and a previously perfectly functioning workbook
now gives the Visual Basic "Insufficient Memory" Error.
I've tried a new workbook, with only one call to the smf addin, but I get
the same error. Is there anybody with the same experience, and how can this
be fixed?
Thanks in advance!
Kind regards,
Willem
Fri May 17, 2013 1:33 pm (PDT) . Posted by:
"bob_15861586" bob_15861586
I am trying to get the delta of an option expiring on December 31 of this year. As such, I used the following function call:
=smfGetOptionQuotes("SPX Dec 31 2013 $1700 Call","5",,"OX")
However, what I get is invalid put/call indicator. What am I doing wrong?
I also want to say thanks to Randy Harmelink for the answer to my last question.
Bob
=smfGetOptionQuotes
However, what I get is invalid put/call indicator. What am I doing wrong?
I also want to say thanks to Randy Harmelink for the answer to my last question.
Bob
Fri May 17, 2013 2:01 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The month and day should be a single parameter, which is why you get the
error message you do.
However, it appears you can't get SPX quotes from OX either. because they
also do special coding of their ticker symbols for the options.
For example, typically something like "IWM" will have an option ticker
symbol like "IWM^^^...". But, for SPX, it appear the weeklies are
"SPXW^^..." and the quarterlies are "SPXQ^^^...". So the option prefixes
aren't matching the web page ticker symbol.
So, for example, this is what the add-in is using to try to get the data:
=RCHGetTableCell("
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Range=0&lstMarket=0&ChainType=3&lstMonths=12/31/2013;3&sLabel&Symbol=SPX
",-5,"SPX^^^131231C01700000")
...but this is what is actually needed:
=RCHGetTableCell("
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Range=0&lstMarket=0&ChainType=3&lstMonths=12/31/2013;3&sLabel&Symbol=SPX
",-5,"SPXQ^^131231C01700000")
On Fri, May 17, 2013 at 1:33 PM, bob_15861586 <bob_15861586@yahoo.com >wrote:
> I am trying to get the delta of an option expiring on December 31 of this
> year. As such, I used the following function call:
> =smfGetOptionQuotes("SPX Dec 31 2013 $1700 Call","5",,"OX")
> However, what I get is invalid put/call indicator. What am I doing wrong?
>
error message you do.
However, it appears you can't get SPX quotes from OX either. because they
also do special coding of their ticker symbols for the options.
For example, typically something like "IWM" will have an option ticker
symbol like "IWM^^^
"SPXW^^
aren't matching the web page ticker symbol.
So, for example, this is what the add-in is using to try to get the data:
=RCHGetTableCell(
https://www.
",-5,"
...but this is what is actually needed:
=RCHGetTableCell(
https://www.
",-5,"
On Fri, May 17, 2013 at 1:33 PM, bob_15861586 <bob_15861586@
> I am trying to get the delta of an option expiring on December 31 of this
> year. As such, I used the following function call:
> =smfGetOptionQuotes
> However, what I get is invalid put/call indicator. What am I doing wrong?
>
Tidak ada komentar:
Posting Komentar