Minggu, 20 September 2015

[smf_addin] Digest Number 3517

12 Messages

Digest #3517

Messages

Sat Sep 19, 2015 6:42 am (PDT) . Posted by:

mickmurphy

I have a synthetic long on BRK.B. When I enter the symbol BRKB, I get the stock quote back, but that symbol returns an error, when trying to get the option price using Google. When I use Yahoo it works fine. With Yahoo not returning anything today, I wanted to get Google working. Does anyone know what I'm doing wrong?


I'm passing "BRKB 01/20 2017 140 Call" to smfGetOptionQuotes.


-Mick



Sat Sep 19, 2015 7:09 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

This works fine here:

=smfGetOptionQuotes("BRK.B 01/20 2017 140 Call","l",,"G")

On Sat, Sep 19, 2015 at 6:35 AM, mickmurphy@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I have a synthetic long on BRK.B. When I enter the symbol BRKB, I get the
> stock quote back, but that symbol returns an error, when trying to get the
> option price using Google. When I use Yahoo it works fine. With Yahoo not
> returning anything today, I wanted to get Google working. Does anyone know
> what I'm doing wrong?
>
> I'm passing "BRKB 01/20 2017 140 Call" to smfGetOptionQuotes.
>

Sat Sep 19, 2015 10:16 am (PDT) . Posted by:

mickmurphy

User error. I was trying to use a single cell for the ticker, however Yahoo and Google want different formats.

RCHGetYahooQuotes wants BRKB.



smfGetOptionQuotes("BRK.B 01/20 2017 140 Call","l",,"G") wants BRK.B as you demonstrated.



Thanks for your help.

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :

This works fine here:

=smfGetOptionQuotes("BRK.B 01/20 2017 140 Call","l",,"G")

On Sat, Sep 19, 2015 at 6:35 AM, mickmurphy@... mailto:mickmurphy@... [smf_addin] <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:
I have a synthetic long on BRK.B. When I enter the symbol BRKB, I get the stock quote back, but that symbol returns an error, when trying to get the option price using Google. When I use Yahoo it works fine. With Yahoo not returning anything today, I wanted to get Google working. Does anyone know what I'm doing wrong?

I'm passing "BRKB 01/20 2017 140 Call" to smfGetOptionQuotes.








Sat Sep 19, 2015 11:01 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm surprised BRKB works. The actual Yahoo ticker symbol is BRK-B.

On Sat, Sep 19, 2015 at 10:16 AM, mickmurphy@... wrote:

>
> User error. I was trying to use a single cell for the ticker, however
> Yahoo and Google want different formats.
>
> RCHGetYahooQuotes wants BRKB.
>
> smfGetOptionQuotes("BRK.B 01/20 2017 140 Call","l",,"G") wants BRK.B as
> you demonstrated.
>
>
>

Sat Sep 19, 2015 7:43 am (PDT) . Posted by:

tonyestep

Yep. After getting Randy's valuable help I got my options price call working, and it returned prices all day Thursday. But when I started up again on Friday, it just returned "Error." Same result this morning (Saturday 9/19). I hope this is not a permanent situation!

Tony Estep

Sat Sep 19, 2015 8:46 am (PDT) . Posted by:

tonyestep

Sorry, Randy, typo. Between 2.50 and 2.70. Anyway, my point was that it was returning a price but that the price was incorrect. Maybe something on Yahoo's end.

Sat Sep 19, 2015 8:56 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Give the lack of options listings last night on IE, I'm thinking Yahoo is
having some IE problems...

On Sat, Sep 19, 2015 at 8:46 AM, tonyestep@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Sorry, Randy, typo. Between 2.50 and 2.70. Anyway, my point was that it
> was returning a price but that the price was incorrect. Maybe something on
> Yahoo's end.
>

Sat Sep 19, 2015 10:12 am (PDT) . Posted by:

tonyestep

I discovered today that I was getting no options prices. However, Randy posted a query string referring to a BRK.B option that worked for him, and sure enough it worked for me too. After some experimentation, I found that I can get prices for options on individual stocks, but not on ETFs. So for example, I get prices for nearby options on XOM or GM, but not on SPY or USO. This is true both with smfGetOptionQuotes and smfGetYahooOptionQuote. The problem appears to be at the source. I sure hope they fix it soon.

Tony

Sat Sep 19, 2015 8:25 pm (PDT) . Posted by:

ctgottapee

Currently I'm seeing 'Error&#39; for all my Put options requesting from yahoo, but Call options are returning a value, started 2 days ago

Sat Sep 19, 2015 9:12 pm (PDT) . Posted by:

ctgottapee

Updating the SMF files to the latest beta files has resolved this issue for all my options, calls and puts of ETFs and typical stocks with various ranges

Sat Sep 19, 2015 9:49 am (PDT) . Posted by:

"Fred Wright" fredwwright

I used to be able to pull the top 5 stocks in an industry group using:
=smfstrExtr(smfGetTagContent("http://research.investors.com/stockcheckup.aspx?symbol="&A3,"dt",-1,"Group Leaders","_rptComposite"),"Symbol=","""")

where A3 was a symbol within a group. 
I think IBD changed the structure of the stockcheckup page recently (was working on 9/14)and this no returns blank.  Fortunately all the detailed fields still work.

In another spreadsheet I was previously (but no longer) able to pull up the name of the IBD Industry Subgroup by using a two step process:

first in column P I have: 
=IF(Q4="","", "http://research.investors.com/stockcheckup/"&smfstrExtr(RCHGetWebData("http://www.investors.com/search/searchresults.aspx?Ntt="&Q4,"/quotes/"),"/quotes/",".htm";))&".ASPX" 
where Q4 has a symbol in the group
Then in column O I have: 
=IF(Q4="","", smfstrExtr(smfGetTagContent(P4,"p",-1,"RANK WITHIN THE"),"THE "," GROUP"))

which returns the name of the subgroup.  

Any advice on how to extract this info now?  the most important to me is the top 5 stocks in the industry sub-group.
Fred

Sat Sep 19, 2015 12:07 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Thanks for the heads up. Indeed, IBD has changed the Stock Checkup web
page. Again. :(

I've updated the RCHGetTableCell-Template-IBD-Stock-Checkup.xls on the
"Templates" web page of the SMF add-in web site.

Unfortunately, the top five are no longer available, unless the stock in
question is one of the top 5.

I also added the group name to the template...

On Sat, Sep 19, 2015 at 9:49 AM, Fred Wright fredwwright@...wrote:

>
> I used to be able to pull the top 5 stocks in an industry group using:
>
> =smfstrExtr(smfGetTagContent("
> http://research.investors.com/stockcheckup.aspx?symbol="&A3,"dt",-1,"Group
> Leaders","_rptComposite"),"Symbol=","""")
>
> where A3 was a symbol within a group.
>
> I think IBD changed the structure of the stockcheckup page recently (was
> working on 9/14)and this no returns blank. Fortunately all the detailed
> fields still work.
>
> In another spreadsheet I was previously (but no longer) able to pull up
> the name of the IBD Industry Subgroup by using a two step process:
>
> first in column P I have:
>
> =IF(Q4="","", "http://research.investors.com/stockcheckup/
> "&smfstrExtr(RCHGetWebData("
> http://www.investors.com/search/searchresults.aspx?Ntt=
> "&Q4,"/quotes/"),"/quotes/",".htm";))&".ASPX"
>
> where Q4 has a symbol in the group
>
> Then in column O I have:
>
> =IF(Q4="","", smfstrExtr(smfGetTagContent(P4,"p",-1,"RANK WITHIN
> THE"),"THE "," GROUP"))
>
> which returns the name of the subgroup.
>
> Any advice on how to extract this info now? the most important to me is
> the top 5 stocks in the industry sub-group.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 01.56

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)