5 Messages
Digest #3939
Messages
Fri Mar 10, 2017 8:55 pm (PST) . Posted by:
sjagers
Hey Randy.... This is weird. Your fix for GetElements 850 is working on most symbols, but I'm still getting a few errors.
I used it today for about 100 symbols. It worked on all of them except: XOG, CIE, NXRT, RDNT, TLP, AXAS, FRAC, REN, JAG, JBL, USPH, XCO, UNXL. Those symbols returned an error.
The odd thing is..... I tried your smfGetTagContent function (from your post to me on 2/24/17) on those symbols and it worked.
FYI.
I used it today for about 100 symbols. It worked on all of them except: XOG, CIE, NXRT, RDNT, TLP, AXAS, FRAC, REN, JAG, JBL, USPH, XCO, UNXL. Those symbols returned an error.
The odd thing is..... I tried your smfGetTagContent function (from your post to me on 2/24/17) on those symbols and it worked.
FYI.
Fri Mar 10, 2017 10:39 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It's because the industry name is so long. Element #850 is using a formula
like:
=TRIM(smfStrExtr(RCHGetWebData("https://www.zacks.com/stock/quote/XOG
","/industry/",100),"""name"":","}"))
The "100" characters isn't enough to capture the full length of everything
needed for the extraction. All I did was up it to 200 and it works:
=TRIM(smfStrExtr(RCHGetWebData("https://www.zacks.com/stock/quote/XOG
","/industry/",200),"""name"":","}"))
On Fri, Mar 10, 2017 at 9:55 PM, sjagers@
...wrote:
>
> Hey Randy.... This is weird. Your fix for GetElements 850 is working on
> most symbols, but I'm still getting a few errors.
>
> I used it today for about 100 symbols. It worked on all of them except:
> XOG, CIE, NXRT, RDNT, TLP, AXAS, FRAC, REN, JAG, JBL, USPH, XCO, UNXL.
> Those symbols returned an error.
>
> The odd thing is..... I tried your smfGetTagContent function (from your
> post to me on 2/24/17) on those symbols and it worked.
>
like:
=TRIM(smfStrExtr(RCHGetWebData("https://www.zacks.com/stock/quote/XOG
","/industry/",100),"""name"":","}"))
The "100" characters isn't enough to capture the full length of everything
needed for the extraction. All I did was up it to 200 and it works:
=TRIM(smfStrExtr(RCHGetWebData("https://www.zacks.com/stock/quote/XOG
","
On Fri, Mar 10, 2017 at 9:55 PM, sjagers@
...wrote:
>
> Hey Randy.... This is weird. Your fix for GetElements 850 is working on
> most symbols, but I'm still getting a few errors.
>
> I used it today for about 100 symbols. It worked on all of them except:
> XOG, CIE, NXRT, RDNT, TLP, AXAS, FRAC, REN, JAG, JBL, USPH, XCO, UNXL.
> Those symbols returned an error.
>
> The odd thing is..... I tried your smfGetTagContent function (from your
> post to me on 2/24/17) on those symbols and it worked.
>
Sat Mar 11, 2017 3:30 am (PST) . Posted by:
mokwit
Trying to think of the best way to tell if a stock has options written on it - the key thing is it has to be doable from just the stock ticker as input without strike and date. The data itself doesn't matter which field so long as it is in a form where I can recognise a yes or no answer - so e.g. if total options open interest was retrievable just with ticker that would be OK - it is a positive number if the stock has options and a error , a '0' or a N/A or somesuch if not.
So, anybody have any ideas which field would be the best for this?
So, anybody have any ideas which field would be the best for this?
Sat Mar 11, 2017 4:07 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Something like this might work:
=NOT(ISTEXT(smfGetOptionExpirations(D8)))
These would give you an idea of the sum of the opening interest for the
first options page on Yahoo, for calls or puts:
=SUM(INDEX(RCHGetHTMLTable("http://finance.yahoo.com/quote/
"&D8&"/options",">Calls",1,,,,200,10),,9))
=SUM(INDEX(RCHGetHTMLTable("http://finance.yahoo.com/quote/
"&D8&"/options",">Puts",1,,,,200,10),,9))
They should return zero if no options are available at all.
On Sat, Mar 11, 2017 at 4:27 AM, pmanz@
...wrote:
>
> Trying to think of the best way to tell if a stock has options written on
> it - the key thing is it has to be doable from just the stock ticker as
> input without strike and date. The data itself doesn't matter which field
> so long as it is in a form where I can recognise a yes or no answer - so
> e.g. if total options open interest was retrievable just with ticker that
> would be OK - it is a positive number if the stock has options and a error
> , a '0' or a N/A or somesuch if not.
>
> So, anybody have any ideas which field would be the best for this?
>
=NOT(ISTEXT(smfGetOptionExpirations(D8)))
These would give you an idea of the sum of the opening interest for the
first options page on Yahoo, for calls or puts:
=SUM(INDEX(RCHGetHTMLTable("http://finance.yahoo.com/quote/
"&D8&"/options",">Calls",1,,,,200,10),,9))
=SUM(INDEX(RCHGetHTMLTable("http://finance.yahoo.com/quote/
"&D8&"
They should return zero if no options are available at all.
On Sat, Mar 11, 2017 at 4:27 AM, pmanz@
...wrote:
>
> Trying to think of the best way to tell if a stock has options written on
> it - the key thing is it has to be doable from just the stock ticker as
> input without strike and date. The data itself doesn't matter which field
> so long as it is in a form where I can recognise a yes or no answer - so
> e.g. if total options open interest was retrievable just with ticker that
> would be OK - it is a positive number if the stock has options and a error
> , a '0' or a N/A or somesuch if not.
>
> So, anybody have any ideas which field would be the best for this?
>
Sat Mar 11, 2017 4:53 pm (PST) . Posted by:
mokwit
Randy, many thanks for your reply - seems to be what I was looking for - just one Q - where do I insert the cell reference of the cell with the ticker inputted (do I replace "D8" or is that not a excel cell reference?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar