7 New Messages
Digest #2623
Messages
Sun May 19, 2013 2:44 pm (PDT) . Posted by:
"jonbeyer_39" jonbeyer_39
Randy
I have been using smfGetOptionQuotes() in a table to get option quotes successfully for a long time. However, I am having a problem with one particular call option for ConocoPhillips: "COP Jan 2014 65 call"
It turns out there are two different COP 65.00 calls for January 2013.
One is the standard call for 100 shares COP, (currently priced at 2.10). The Yahoo page for the standard call is "http://finance.yahoo.com/q?s=COP140118C00065000 "
The other is a special call consisting of 100 shares COP and 50 shares PSX (currently priced at 26.70). This is due to the PSX spinoff from COP of last year. The Yahoo page for the special call is "http://finance.yahoo.com/q?s=COP1140118C00065000 "
The problem is that when I use smfGetOptionQuotes(), I am getting data for the special call instead of the standard call.
What is the best way to go directly to the yahoo page to extract the price?
Thanks so much for your great addin.
Jon
I have been using smfGetOptionQuotes(
It turns out there are two different COP 65.00 calls for January 2013.
One is the standard call for 100 shares COP, (currently priced at 2.10). The Yahoo page for the standard call is "http://finance.
The other is a special call consisting of 100 shares COP and 50 shares PSX (currently priced at 26.70). This is due to the PSX spinoff from COP of last year. The Yahoo page for the special call is "http://finance.
The problem is that when I use smfGetOptionQuotes(
What is the best way to go directly to the yahoo page to extract the price?
Thanks so much for your great addin.
Jon
Sun May 19, 2013 3:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
As written, smfGetOptionQuotes() will unfortunately have that problem. It
currently ends up doing this for bid price:
=RCHGetTableCell("http://finance.yahoo.com/q/op?s=COP&m=2014-01
",3,"140118C00065000")
...which just uses the date, C/P indicator, and strike price to find the
call. In this case, that's not specific enough. In fact, you may randomly
get one or the other, depending on whether Yahoo puts them in a specific
order or not.
In your case, you need:
=RCHGetTableCell("http://finance.yahoo.com/q/op?s=COP&m=2014-01
",3,"COP140118C00065000")
...to make sure it gets the "COP" option instead of the special "COP1"
option. Note that I could specifically get the other with:
=RCHGetTableCell("http://finance.yahoo.com/q/op?s=COP&m=2014-01
",3,"COP1140118C00065000")
On Sun, May 19, 2013 at 2:43 PM, jonbeyer_39 <jonabeyer@gmail.com > wrote:
>
> I have been using smfGetOptionQuotes() in a table to get option quotes
> successfully for a long time. However, I am having a problem with one
> particular call option for ConocoPhillips: "COP Jan 2014 65 call"
>
> It turns out there are two different COP 65.00 calls for January 2013.
>
> One is the standard call for 100 shares COP, (currently priced at 2.10).
> The Yahoo page for the standard call is "
> http://finance.yahoo.com/q?s=COP140118C00065000 "
>
> The other is a special call consisting of 100 shares COP and 50 shares PSX
> (currently priced at 26.70). This is due to the PSX spinoff from COP of
> last year. The Yahoo page for the special call is "
> http://finance.yahoo.com/q?s=COP1140118C00065000 "
>
> The problem is that when I use smfGetOptionQuotes(), I am getting data for
> the special call instead of the standard call.
>
> What is the best way to go directly to the yahoo page to extract the price?
>
currently ends up doing this for bid price:
=RCHGetTableCell(
",3,"
...which just uses the date, C/P indicator, and strike price to find the
call. In this case, that's not specific enough. In fact, you may randomly
get one or the other, depending on whether Yahoo puts them in a specific
order or not.
In your case, you need:
=RCHGetTableCell(
",3,"
...to make sure it gets the "COP" option instead of the special "COP1"
option. Note that I could specifically get the other with:
=RCHGetTableCell(
",3,"
On Sun, May 19, 2013 at 2:43 PM, jonbeyer_39 <jonabeyer@gmail.
>
> I have been using smfGetOptionQuotes(
> successfully for a long time. However, I am having a problem with one
> particular call option for ConocoPhillips: "COP Jan 2014 65 call"
>
> It turns out there are two different COP 65.00 calls for January 2013.
>
> One is the standard call for 100 shares COP, (currently priced at 2.10).
> The Yahoo page for the standard call is "
> http://finance.
>
> The other is a special call consisting of 100 shares COP and 50 shares PSX
> (currently priced at 26.70). This is due to the PSX spinoff from COP of
> last year. The Yahoo page for the special call is "
> http://finance.
>
> The problem is that when I use smfGetOptionQuotes(
> the special call instead of the standard call.
>
> What is the best way to go directly to the yahoo page to extract the price?
>
Sun May 19, 2013 3:23 pm (PDT) . Posted by:
"bobc94595" bobc94595
I am having the same problem of inability to get Zacks Element numbers, or even get Zacks.com on either IE or Firefox. After loading the latest SMF files, Zacks did work for about one day, but over the last several days, I can get no info from Zacks. Do you have any remedy for this. Exactly what is the Cntl F5 intended to do, and when and how do you employ it? How do you clean out the Zacks cookies (CCleaner?)
Any help will be appreciated.
Bob
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> If the Zacks website isn't up, you won't be able to get the rating. Because
> the add-in just uses a browser object to grab the source code of the web
> page, and then extract the data. So if it can't get the web page...
>
> On Fri, May 10, 2013 at 8:24 PM, zbgb952 <mb0329@...> wrote:
>
> > Anyone having trouble getting Zacks rating? I also note that the
> > www.zacks.com website isn't working recently.
> >
> >
>
Any help will be appreciated.
Bob
--- In smf_addin@yahoogrou
>
> If the Zacks website isn't up, you won't be able to get the rating. Because
> the add-in just uses a browser object to grab the source code of the web
> page, and then extract the data. So if it can't get the web page...
>
> On Fri, May 10, 2013 at 8:24 PM, zbgb952 <mb0329@.
>
> > Anyone having trouble getting Zacks rating? I also note that the
> > www.zacks.com website isn't working recently.
> >
> >
>
Sun May 19, 2013 3:44 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Ctrl+F5 forces the browser to get fresh copies of EVERYTHING, instead of
just a fresh copy of the web page source. That means any external files,
like style sheets and Javascript. Otherwise, those may come from cached
copies. I've used it whenever a web page doesn't come in as I suspect. And,
in a few cases, where the provider actually suggests it, because they have
updated styles for the web site. In the vast majority of cases, it doesn't
do a thing, because those external files are only updated rarely.
Deleting cookies is dependent upon your browser. I've not done it in IE, so
I can't really say how to do it. You should be able to search Google and
find some examples. In FireFox, I would just do it through their > Tools >
Options menu.
I just tried both FireFox and the EXCEL Web Query dialog, and both worked
fine for me with:
http://www.zacks.com/stock/quote/MMM
On Sun, May 19, 2013 at 3:23 PM, bobc94595 <conlonrc@comcast.net > wrote:
> I am having the same problem of inability to get Zacks Element numbers, or
> even get Zacks.com on either IE or Firefox. After loading the latest SMF
> files, Zacks did work for about one day, but over the last several days, I
> can get no info from Zacks. Do you have any remedy for this. Exactly what
> is the Cntl F5 intended to do, and when and how do you employ it? How do
> you clean out the Zacks cookies (CCleaner?)
>
> Any help will be appreciated.
>
just a fresh copy of the web page source. That means any external files,
like style sheets and Javascript. Otherwise, those may come from cached
copies. I've used it whenever a web page doesn't come in as I suspect. And,
in a few cases, where the provider actually suggests it, because they have
updated styles for the web site. In the vast majority of cases, it doesn't
do a thing, because those external files are only updated rarely.
Deleting cookies is dependent upon your browser. I've not done it in IE, so
I can't really say how to do it. You should be able to search Google and
find some examples. In FireFox, I would just do it through their > Tools >
Options menu.
I just tried both FireFox and the EXCEL Web Query dialog, and both worked
fine for me with:
http://www.zacks.
On Sun, May 19, 2013 at 3:23 PM, bobc94595 <conlonrc@comcast.
> I am having the same problem of inability to get Zacks Element numbers, or
> even get Zacks.com on either IE or Firefox. After loading the latest SMF
> files, Zacks did work for about one day, but over the last several days, I
> can get no info from Zacks. Do you have any remedy for this. Exactly what
> is the Cntl F5 intended to do, and when and how do you employ it? How do
> you clean out the Zacks cookies (CCleaner?)
>
> Any help will be appreciated.
>
Sun May 19, 2013 9:21 pm (PDT) . Posted by:
"V. Shankar" tarakayan
ZACKS in their website (think comes under media room) have made changes in their reports. They now have so many with several options. All my templates that work with downloads have to be redone.
Sent from Yahoo! Mail on my iPad
Sent from Yahoo! Mail on my iPad
Sun May 19, 2013 4:37 pm (PDT) . Posted by:
"jdolson83" jdolson83
If i create a form and input ticker symbols, will the form re-run whenever I open the file?
Thanks
Thanks
Sun May 19, 2013 4:40 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The add-in doesn't use forms.
If you use a function, it will be subject to the same rules as normal -- it
will recalculate when you open the file, unless you have automatic
recalculation turned off.
However, some functions extract data from saved copies of web pages. Those
saved copies of web pages can only be purged by either exiting and
restarting EXCEL, or by running the smfForceRecalculation macro (see LINKS
area of the group for more info).
On Sun, May 19, 2013 at 3:53 PM, jdolson83 <avido83@gmail.com > wrote:
> If i create a form and input ticker symbols, will the form re-run whenever
> I open the file?
>
If you use a function, it will be subject to the same rules as normal -- it
will recalculate when you open the file, unless you have automatic
recalculation turned off.
However, some functions extract data from saved copies of web pages. Those
saved copies of web pages can only be purged by either exiting and
restarting EXCEL, or by running the smfForceRecalculati
area of the group for more info).
On Sun, May 19, 2013 at 3:53 PM, jdolson83 <avido83@gmail.
> If i create a form and input ticker symbols, will the form re-run whenever
> I open the file?
>
Tidak ada komentar:
Posting Komentar