7 Messages
Digest #4373
Messages
Thu Aug 2, 2018 9:21 am (PDT) . Posted by:
"Tim Young" timy2matoe
Randy,
Thank you for what you do!
I've used smfGetBarchartOptionQuote() to get option Implied Volatility for a good while but that quit mid July. I saw where you were not optimistic for its return.
When I use =smfGetOptionQuotes() I can retrieve the title for Implied Volatility but it returns "Unrecognized item ID:6" where the Implied Volatility should be.
Any suggestions or know of another source?
Tim
Thank you for what you do!
I've used smfGetBarchartOptio
When I use =smfGetOptionQuotes
Any suggestions or know of another source?
Tim
Thu Aug 2, 2018 10:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
At the moment, I don't know of a source...
There is a possibility of using iVolatility data, but I've used them in the
past several times only to have it disappear from the service that was
hosting them. And it requires a setup, so it can't just be used on the fly.
On Thu, Aug 2, 2018 at 9:17 AM, Tim Young timy2matoe@
....
wrote:
>
> I've used smfGetBarchartOptionQuote() to get option Implied Volatility for
> a good while but that quit mid July. I saw where you were not optimistic
> for its return.
>
> When I use =smfGetOptionQuotes() I can retrieve the title for Implied
> Volatility but it returns "Unrecognized item ID:6" where the Implied
> Volatility should be.
>
> Any suggestions or know of another source?
>
>
There is a possibility of using iVolatility data, but I've used them in the
past several times only to have it disappear from the service that was
hosting them. And it requires a setup, so it can't just be used on the fly.
On Thu, Aug 2, 2018 at 9:17 AM, Tim Young timy2matoe@
....
wrote:
>
> I've used smfGetBarchartOptio
> a good while but that quit mid July. I saw where you were not optimistic
> for its return.
>
> When I use =smfGetOptionQuotes
> Volatility but it returns "Unrecognized item ID:6" where the Implied
> Volatility should be.
>
> Any suggestions or know of another source?
>
>
Thu Aug 2, 2018 12:16 pm (PDT) . Posted by:
"Tim Young" timy2matoe
No problem... Thanks again for what you do.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, August 2, 2018 12:33 PM
Subject: Re: [smf_addin] Implied Volatility
At the moment, I don't know of a source....
There is a possibility of using iVolatility data, but I've used them in the past several times only to have it disappear from the service that was hosting them. And it requires a setup, so it can't just be used on the fly.
On Thu, Aug 2, 2018 at 9:17 AM, Tim Young timy2matoe@.
I've used smfGetBarchartOptio
When I use =smfGetOptionQuotes
Any suggestions or know of another source?
#yiv9467796904 #yiv9467796904 -- #yiv9467796904ygrp-
Thu Aug 2, 2018 7:37 pm (PDT) . Posted by:
sjagers
Hi Randy... Sorry to bother you again, but I have another question about getting data from Zacks website.
Your GetElementNumbers for Zacks data work great on my Windows 10 (Excel 2007) PC, but they quit working on my Windows Vista (Excel 2007, Internet Explorer 9, Firefox 52.9) laptop over a month ago.
I can open and view Zacks website on my Vista machine with Firefox, but I can no longer access their website with Internet Explorer 9; I always get a "Internet Explorer cannot display the webpage" error.
Any idea why I have this problem on Vista and not Windows 10? Do you know of any workaround?
Thanks.
Your GetElementNumbers for Zacks data work great on my Windows 10 (Excel 2007) PC, but they quit working on my Windows Vista (Excel 2007, Internet Explorer 9, Firefox 52.9) laptop over a month ago.
I can open and view Zacks website on my Vista machine with Firefox, but I can no longer access their website with Internet Explorer 9; I always get a "Internet Explorer cannot display the webpage" error.
Any idea why I have this problem on Vista and not Windows 10? Do you know of any workaround?
Thanks.
Thu Aug 2, 2018 8:55 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I doubt it's the operating system that is making the difference. And
FireFox is irrelevant.
EXCEL uses its own version of on IE object. On my machine (Windows 10),
it's completely separate from the browser version of IE. I can log in with
the IE object within EXCEL and the IE browser has no security cookie. And
vice versa. And I have no idea how to update the version of the IE object
that EXCEL uses. I know it changes with versions of EXCEL, but no idea if
it can be updated manually.
The best way to check for compatibility is to try out a site with the IE
object within EXCEL (keyboard shortcut alt+d+d+w).
The only workaround I can think of is to actually use the IE browser. But I
haven't found that to be reliable between various versions of EXCEL, which
is why I use the XMLHTTP process to grab a web page's source code. It's
also faster, because the web page doesn't need to resolve images and such.
Try these three functions on each machine and tell me what you get:
=RCHGetWebData("https://www.zacks.com/stock/quote/MMM",">Zacks Rank:",250)
=RCHGetWebData("https://www.zacks.com/stock/quote/MMM",">Zacks
Rank:",250,,0)
=RCHGetWebData("https://www.zacks.com/stock/quote/MMM",">Zacks
Rank:",250,,1)
The first two should be the exact same process, using XMLHTTP to get the
source code of the page from the server. The third should use the actual
browser and grab the source code of the rendered page. It's slower and not
as consistent between machines configurations.
All three return the same thing for me:
>Zacks Rank:</a> <span class="info-tooltip"
rel="quote_rank_ribbon";></span> </label> <p
class="rank_view"> 4-Sell
<span class="rank_chip rankrect_1"> </s
On Thu, Aug 2, 2018 at 7:37 PM, sjagers@
....
wrote:
>
> Hi Randy... Sorry to bother you again, but I have another question about
> getting data from Zacks website.
>
> Your GetElementNumbers for Zacks data work great on my Windows 10 (Excel
> 2007) PC, but they quit working on my Windows Vista (Excel 2007, Internet
> Explorer 9, Firefox 52.9) laptop over a month ago.
>
> I can open and view Zacks website on my Vista machine with Firefox, but I
> can no longer access their website with Internet Explorer 9; I always get a
> "Internet Explorer cannot display the webpage" error.
>
> Any idea why I have this problem on Vista and not Windows 10? Do you know
> of any workaround?
>
>
FireFox is irrelevant.
EXCEL uses its own version of on IE object. On my machine (Windows 10),
it's completely separate from the browser version of IE. I can log in with
the IE object within EXCEL and the IE browser has no security cookie. And
vice versa. And I have no idea how to update the version of the IE object
that EXCEL uses. I know it changes with versions of EXCEL, but no idea if
it can be updated manually.
The best way to check for compatibility is to try out a site with the IE
object within EXCEL (keyboard shortcut alt+d+d+w).
The only workaround I can think of is to actually use the IE browser. But I
haven't found that to be reliable between various versions of EXCEL, which
is why I use the XMLHTTP process to grab a web page's source code. It's
also faster, because the web page doesn't need to resolve images and such.
Try these three functions on each machine and tell me what you get:
=RCHGetWebData("https://www.zacks.com/stock/quote/MMM",">Zacks Rank:",250)
=RCHGetWebData("https://www.zacks.com/stock/quote/MMM",">Zacks
Rank:",250,,0)
=RCHGetWebData("https://www.zacks.com/stock/quote/MMM","
Rank:",
The first two should be the exact same process, using XMLHTTP to get the
source code of the page from the server. The third should use the actual
browser and grab the source code of the rendered page. It's slower and not
as consistent between machines configurations.
All three return the same thing for me:
>Zacks Rank:</a> <span class="
rel="quote_
class="
<span class="
On Thu, Aug 2, 2018 at 7:37 PM, sjagers@
....
wrote:
>
> Hi Randy... Sorry to bother you again, but I have another question about
> getting data from Zacks website.
>
> Your GetElementNumbers for Zacks data work great on my Windows 10 (Excel
> 2007) PC, but they quit working on my Windows Vista (Excel 2007, Internet
> Explorer 9, Firefox 52.9) laptop over a month ago.
>
> I can open and view Zacks website on my Vista machine with Firefox, but I
> can no longer access their website with Internet Explorer 9; I always get a
> "Internet Explorer cannot display the webpage" error.
>
> Any idea why I have this problem on Vista and not Windows 10? Do you know
> of any workaround?
>
>
Thu Aug 2, 2018 9:45 pm (PDT) . Posted by:
mff2805
Hi Randy,
Is there a way to caputure barchart's weightd alpha number into a spreadsheet cell, such as from this page
https://www.barchart.com/stocks/quotes/BA/overview https://www.barchart.com/stocks/quotes/BA/overview
i've tried a variety of things, but no luck.
thanks,
Mike
Is there a way to caputure barchart's weightd alpha number into a spreadsheet cell, such as from this page
https://www.barchart.com/stocks/quotes/BA/overview https://www.barchart.com/stocks/quotes/BA/overview
i've tried a variety of things, but no luck.
thanks,
Mike
Fri Aug 3, 2018 1:00 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The problem is that it's displayed within a part of the web page that is
dynamically generated. However, it is buried with the text of the web page.
This appears to work:
=smfstrExtr(smfWord(RCHGetWebData("https://www.barchart.com/stocks/quotes/"&
B4&"/overview","quoteOverviewCtrl",5000),3,"weightedAlpha"),
":"",""",1)
On Thu, Aug 2, 2018 at 9:45 PM, mff3429@
....
wrote:
> Is there a way to caputure barchart's weightd alpha number into a
> spreadsheet cell, such as from this page
>
> https://www.barchart.com/stocks/quotes/BA/overview
>
> i've tried a variety of things, but no luck.
>
>
>
dynamically generated. However, it is buried with the text of the web page.
This appears to work:
=smfstrExtr(smfWord(RCHGetWebData("https://www.barchart.com/stocks/quotes/"&
B4&"/overview","quoteOverviewCtrl",5000),3,"weightedAlpha"),
":"",""",1)
On Thu, Aug 2, 2018 at 9:45 PM, mff3429@
....
wrote:
> Is there a way to caputure barchart's weightd alpha number into a
> spreadsheet cell, such as from this page
>
> https://www.barchart.com/stocks/quotes/BA/overview
>
> i've tried a variety of things, but no luck.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar