9 Messages
Digest #4135
Messages
Thu Aug 31, 2017 5:53 am (PDT) . Posted by:
joelfp2000
Randy,
As always, thank you so very much for keeping this group going. I use your elements, etc. every day and so a few of my friends. A tremendous resource!
I use the following to determine the M* rating for funds.
=smfGetYahooJSONField($D7,"defaultKeyStatistics","quoteSummary.result.0.defaultKeyStatistics.morningStarOverallRating.raw")
Do you know of any formula that I can use to capture the M* for ETF's? Years ago the website page was a nightmare, now I'm wondering if the star rating is available somewhere.
Thanks in advance.
Joel
As always, thank you so very much for keeping this group going. I use your elements, etc. every day and so a few of my friends. A tremendous resource!
I use the following to determine the M* rating for funds.
=smfGetYahooJSONFie
Do you know of any formula that I can use to capture the M* for ETF's? Years ago the website page was a nightmare, now I'm wondering if the star rating is available somewhere.
Thanks in advance.
Joel
Thu Aug 31, 2017 9:04 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32468
On Thu, Aug 31, 2017 at 5:53 AM, joel.andrews@
...
wrote:
> As always, thank you so very much for keeping this group going. I use
> your elements, etc. every day and so a few of my friends. A tremendous
> resource!
>
> I use the following to determine the M* rating for funds.
>
> =smfGetYahooJSONField($D7,"defaultKeyStatistics","quoteSummary.result.0.
> defaultKeyStatistics.morningStarOverallRating.raw")
>
> Do you know of any formula that I can use to capture the M* for ETF's?
> Years ago the website page was a nightmare, now I'm wondering if the star
> rating is available somewhere.
>
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32468
On Thu, Aug 31, 2017 at 5:53 AM, joel.andrews@
...
wrote:
> As always, thank you so very much for keeping this group going. I use
> your elements, etc. every day and so a few of my friends. A tremendous
> resource!
>
> I use the following to determine the M* rating for funds.
>
> =smfGetYahooJSONFie
> defaultKeyStatistic
>
> Do you know of any formula that I can use to capture the M* for ETF's?
> Years ago the website page was a nightmare, now I'm wondering if the star
> rating is available somewhere.
>
>
>
Thu Aug 31, 2017 9:48 am (PDT) . Posted by:
a.bereziuk
Now both functions smfGetTagContent and RCHGetTableCell are working. The problem was, that I haven't put https instead of old http, like you wrote.They have updated the protocol )) And Finviz has http, so it worked. Thank you.
Thu Aug 31, 2017 10:35 am (PDT) . Posted by:
joshi_mandar
Hi All,
I use smfGetOptionQuotes to get options quotes from yahoo. Last few weeks I have noticed it works in some cases and doesnt work in some.
For example:
=smfGetOptionQuotes("dis Jan 18 80 call","l",0,"Y") works well.
But =smfGetOptionQuotes("dis Jan 18 80 call","c",0,"Y") doesnt work. It used to work until few weeks ago. I got the latest version of add-in (dated 8/13). But still it doesnt work. Any idea?
Mandar
I use smfGetOptionQuotes to get options quotes from yahoo. Last few weeks I have noticed it works in some cases and doesnt work in some.
For example:
=smfGetOptionQuotes
But =smfGetOptionQuotes
Mandar
Thu Aug 31, 2017 10:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Looks like Yahoo changed the web page again. They inserted comments into
the code. I don't know if the change is permanent or temporary, so I'm not
anxious to change the add-in's extraction method.
Yahoo options are something I have on my (long) "to do" list to go back and
look at again. In the meantime, a workaround might be to get the previous
close and compute the change yourself.
On Thu, Aug 31, 2017 at 10:35 AM, joshi_mandar@
...
wrote:
> I use smfGetOptionQuotes to get options quotes from yahoo. Last few weeks
> I have noticed it works in some cases and doesnt work in some.
>
> For example:
>
> =smfGetOptionQuotes("dis Jan 18 80 call","l",0,"Y") works well.
>
> But =smfGetOptionQuotes("dis Jan 18 80 call","c",0,"Y") doesnt work. It
> used to work until few weeks ago. I got the latest version of add-in
> (dated 8/13). But still it doesnt work. Any idea?
>
>
>
the code. I don't know if the change is permanent or temporary, so I'm not
anxious to change the add-in's extraction method.
Yahoo options are something I have on my (long) "to do" list to go back and
look at again. In the meantime, a workaround might be to get the previous
close and compute the change yourself.
On Thu, Aug 31, 2017 at 10:35 AM, joshi_mandar@
...
wrote:
> I use smfGetOptionQuotes to get options quotes from yahoo. Last few weeks
> I have noticed it works in some cases and doesnt work in some.
>
> For example:
>
> =smfGetOptionQuotes
>
> But =smfGetOptionQuotes
> used to work until few weeks ago. I got the latest version of add-in
> (dated 8/13). But still it doesnt work. Any idea?
>
>
>
Thu Aug 31, 2017 11:34 am (PDT) . Posted by:
buckleca
Hi Randy,
On a pay site that I've extracted for many years suddenly stopped working. Still works with webquery and sometimes with the I/E parameter on the SMF function (mostly not). Using smfGetTagContent
When I run it via Excel I/E it gives a script error - but runs after that prompt.
With I/E 11 or Firefox it works without error.
All data still in the source, so something causing it to bounce out with the error. Wondering if there's a method to get past whatever is causing the function to return an error?
Thanks
On a pay site that I've extracted for many years suddenly stopped working. Still works with webquery and sometimes with the I/E parameter on the SMF function (mostly not). Using smfGetTagContent
When I run it via Excel I/E it gives a script error - but runs after that prompt.
With I/E 11 or Firefox it works without error.
All data still in the source, so something causing it to bounce out with the error. Wondering if there's a method to get past whatever is causing the function to return an error?
Thanks
Thu Aug 31, 2017 11:53 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It could be you just need to change the parameters of the function. They
may have changed some of the source code within the web page.
On Thu, Aug 31, 2017 at 11:34 AM, buckleca@
...
wrote:
> On a pay site that I've extracted for many years suddenly stopped working.
> Still works with webquery and sometimes with the I/E parameter on the SMF
> function (mostly not). Using smfGetTagContent
>
> When I run it via Excel I/E it gives a script error - but runs after that
> prompt.
>
> With I/E 11 or Firefox it works without error.
>
> All data still in the source, so something causing it to bounce out with
> the error. Wondering if there's a method to get past whatever is causing
> the function to return an error?
>
>
>
may have changed some of the source code within the web page.
On Thu, Aug 31, 2017 at 11:34 AM, buckleca@
...
wrote:
> On a pay site that I've extracted for many years suddenly stopped working.
> Still works with webquery and sometimes with the I/E parameter on the SMF
> function (mostly not). Using smfGetTagContent
>
> When I run it via Excel I/E it gives a script error - but runs after that
> prompt.
>
> With I/E 11 or Firefox it works without error.
>
> All data still in the source, so something causing it to bounce out with
> the error. Wondering if there's a method to get past whatever is causing
> the function to return an error?
>
>
>
Thu Aug 31, 2017 3:21 pm (PDT) . Posted by:
buckleca
In the Quick-webpage-examination spreadsheet:
smfGetTagContent($C$7,$C$8,B12,$C$9) - always returns error
smfGetTagContent($C$7,$C$8,B12,$C$9,,,,,,1) - sometimes returns the correct results - but mostly returns error.
Maybe I'll try debugging the code and see what might be happening.
Thanks
smfGetTagContent(
smfGetTagContent(
Maybe I'll try debugging the code and see what might be happening.
Thanks
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar