Selasa, 31 Oktober 2017

[smf_addin] Digest Number 4187

9 Messages

Digest #4187

Messages

Tue Oct 31, 2017 1:44 am (PDT) . Posted by:

"Ian"

Hi Randy,

I had no luck with the smfGetYahooJSONField method:

=smfGetYahooJSONField("None","barChartMM","data.1.raw.newHighs")​

Then I have tried various other items mentioned in past emails all of which
get #VALUE! such as:

=smfGetYahooJSONField("MMM","earningsTrend","quoteSummary.
result.0.earningsTrend.trend.2.earningsEstimate.numberOfAnalysts.raw")

=smfGetYahooJSONField("MMM, IBM","portfolioView"," quoteResponse.result.0.
trailingPE")

=smfGetYahooJSONField("MMM, IBM","portfolioView"," quoteResponse.result.1.
trailingPE")

=smfGetYahooJSONField("MMM","incomeStatementHistory","quoteSummary.result.0.
incomeStatementHistory.incomeStatementHistory.0.totalRevenue.raw")

And from the examples in the documentation at http://ogres-crypt.com/SMF/
Documentation/viewer.php?name=smfGetYahooJSONField-Function.html:

=smfGetYahooJSONField("MMM", "cashFlowStatementHistory",
"quoteSummary.result.0.cashflowStatementHistory.cashflowStatements.0.
changeInCash.raw")

=smfGetYahooJSONField("MMM", "financialData", "quoteSummary.result.0.
financialData.targetMeanPrice.raw")

Yet, the following work:

=smfGetYahooJSONData("GIII","netSharePurchaseActivity","netPercentInsiderShares")
returns -0.003.

=smfGetYahooJSONData("VFINX","fundPerformance","lastBearMkt") returns
-0.1631

=smfGetYahooJSONData("VWEAX","fundPerformance","trailingReturns.oneMonth")
returns 0.0077

=smfGetYahooJSONData("VWEAX","fundPerformance","trailingReturns.threeMonth")
returns 0.0204

*RCH_Stock_Market_Functions.xla dated 31/10/2017 4:51pm 785kb:*

I had a look at RCH_Stock_Market_Functions.xla and found:

2017.07.05 -- Modified Yahoo processing to use smfGetYahooJSONField() to
get dataà Q 2017.07.09 -- Removed smfGetYahooJSONField() to get data, as
it was not reliable

So, perhaps that explains why smfGetYahooJSONField gives me #VALUE!

In the meantime, the hard coded method works!

=smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData(rURL)
,"NYSE","}"),"""newHighs"":""",""""))

Thanks

Ian

*From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
*Sent:* Tuesday, 31 October 2017 5:01 AM
*To:* smf_addin@yahoogroups.com
*Subject:* Re: [smf_addin] Barchart Momentum - NYSE New Highs and New Lows
and Moving Averages

It looks like Barchart has changed the web page, at least in changing the
URL and adding the 5-day moving average values.It also looks like I forgot
to change the momentum template to include the new element number instead
of the old hard-coded definitions.

However, all of my advances and declines for element definitions appear to
be coming through fine. For example:

*#*

*Value*

1146

Mon, Oct 30th, 2017

1147

758

1148

1227

1149

41

1150

408760000

1151

434810000

1152

5830000

1153

84

​The current definition of element #1153:

=RCHGetElementNumber("Definition",1153)

...should have this formula:

=smfGetYahooJSONField("None","barChartMM","data.1.raw.newHighs")​

Ø snip

Tue Oct 31, 2017 7:05 am (PDT) . Posted by:

pete_cook2001

Stock price, rchgetelementnumber (xx, 2151), is suddenly returning an error. Other arguments seem to be working. Any ideas?

Tue Oct 31, 2017 7:59 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Thanks for the heads up. They changed all of their URLs.

All IBD element definitions on smf-elements-9.txt have been updated to use
"https://" instead of "http://" in their URLs.

New files on the website:

- Change Log
<http://ogres-crypt.com/SMF/Documentation/viewer.php?name=Change-Log.html>
- smf-elements-9.txt
<http://ogres-crypt.com/SMF/Elements/smf-elements-9.txt>

Best practice is to exit EXCEL when updating SMF add-in files.

On Tue, Oct 31, 2017 at 7:05 AM, peterscottcook@
​...
wrote:

> Stock price, rchgetelementnumber (xx, 2151), is suddenly returning an
> error. Other arguments seem to be working. Any ideas?
>

Tue Oct 31, 2017 9:00 am (PDT) . Posted by:

joelfp2000

Randy,


Thanks in advance for all of your support and help.


I am having problems with the following string:


=smfGetTagContent("http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t="&A$2,"td",6,"Rank in Category (NAV)",,,,1)



The string pulls up the one year trailing M* category returns. The 3 year and 5 year category numbers also have problems and are inconsistent.


The formula works on about 75% of the mutual fund symbols (eg. wacpx, ftrbx, nofix) but not on others (eg. cfbnx, habdx, ptrix). I have added morningstar.com to the IE trusted sites, used other computers and I still get the error.


Any idea how to correct this issue?


Thanks again for your awesome support.

Joel

Tue Oct 31, 2017 9:12 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

​The problem is this web page contains no data:

http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=cfbnx

This web page apparently has the data (but no NAV):

http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t=cfbnx

Not sure when to use one vs the other...

On Tue, Oct 31, 2017 at 9:00 AM, joel.andrews@
​...
wrote:

> I am having problems with the following string:
>
> =smfGetTagContent("http://performance.morningstar.com/
> Performance/cef/trailing-total-returns.action?t="&A$2,"td",6,"Rank in
> Category (NAV)",,,,1)
>
> The string pulls up the one year trailing M* category returns. The 3 year
> and 5 year category numbers also have problems and are inconsistent.
>
> The formula works on about 75% of the mutual fund symbols (eg.
> ​​
> wacpx, ftrbx, nofix) but not on others (eg. cfbnx, habdx, ptrix). I have
> added morningstar.com to the IE trusted sites, used other computers and I
> still get the error.
>
> Any idea how to correct this issue?
>
>
>

Tue Oct 31, 2017 9:26 am (PDT) . Posted by:

e_bartsch

Randy:

I'm having an issues with smfGetOptionStrikes. . .


Is that still working for Weeklies quotes? For example:


=smfGetOptionStrikes("MMM";,"11/24/17","P")


Generates "None". I tried all the different data sources. Same result.


Likewise,


=smfGetOptionQuotes("MMM 11/17 2017 $225.00 Put","as",1,"Y")


is consistently returning "Error" for the Ask Price (although it does generate the strike price).


Any ideas?


Thanks.

Tue Oct 31, 2017 10:00 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Both functions are working fine for me. However, I did just rewrite the
smfGetOptionStrikes() routine for Yahoo, because I found out the strike
prices I had been extracting from the Yahoo JSON file were for the equity
in general, and not specific to individual expiration dates. So my new
version is returning different strike prices for different expiration dates.

225
227.5
230
232.5
235
237.5
240

Ask Price Strike Price
1.33 225

​Not sure when I'll update the ZIP file. I'm in the middle of changing some
other things, so it's not in a condition to be uploaded.​ Sorry.

Just curious -- which version of the add-in are you using?

=RCHGetElementNumber("Version&quot;)

In any case, I'm hoping "Error" on the ask price (and "None" on strike
prices?) is a temporary communication glitch with Yahoo? You aren't doing a
significant number (i.e. 1000) of web page retrievals, are you?

On Tue, Oct 31, 2017 at 9:26 AM, eabartsch@
​...
wrote:

>
> I'm having an issues with smfGetOptionStrikes. . .
>
> Is that still working for Weeklies quotes? For example:
>
> =smfGetOptionStrikes("MMM";,"11/24/17","P")
>
> Generates "None". I tried all the different data sources. Same result.
>
> Likewise,
>
> =smfGetOptionQuotes("MMM 11/17 2017 $225.00 Put","as",1,"Y")
>
> is consistently returning "Error" for the Ask Price (although it does
> generate the strike price).
>
> Any ideas?
>

Tue Oct 31, 2017 12:19 pm (PDT) . Posted by:

e_bartsch

Randy:

Thanks for the update.


Here is the return from the Version inquiry:


Stock Market Functions add-in, Version 2.1.2017.09.17 (C:\SMF Add-In; Windows (64-bit) NT :.00; 15.0; ; Local; 1)


No sweat on the updated ZIP file. I'll watch for it and pull it down when you do get around to updating it.


The "ask price" has been stubbornly defaulting to "Error". And, it isn't the web page retrievals--I'll wait hours and then recalculate only that one array with that formula.


Sounds like the JSON upgrades will eventually solve these problems, which seem to correspondence to
Yahoo blocking their data and OX going offline.


Eric
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 19.54

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)