15 Messages
Digest #4064
Messages
Tue Jun 20, 2017 6:56 am (PDT) . Posted by:
codyklein
I don't see smfGetGuruFocusItem in the documentation. Is it still available?
Tue Jun 20, 2017 9:49 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry. Looks like the only documentation at the moment is the template in
the "Works in Progress" folder...
On Tue, Jun 20, 2017 at 6:56 AM, codyklein@
...
wrote:
>
> I don't see smfGetGuruFocusItem in the documentation. Is it still
> available?
>
>
>
the "Works in Progress" folder...
On Tue, Jun 20, 2017 at 6:56 AM, codyklein@
...
wrote:
>
> I don't see smfGetGuruFocusItem in the documentation. Is it still
> available?
>
>
>
Tue Jun 20, 2017 9:58 am (PDT) . Posted by:
codyklein
Thanks Randy, I opened the template and it doesn't seem to be working. All the cells are filled with "Error". I tried AAPL.
Tue Jun 20, 2017 10:55 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You do have the 2017.05.03 version (or later), right?
It appears to be working fine here:
*AAPL*
Fiscal Periods Sep02 Sep03 Sep04 Sep05 Sep06
Revenue per Share 1.13 1.23 1.53 2.32 3.14
EBITDA per Share 0.03 0.04 0.1 0.3 0.44
I am a subscriber (and logged in with EXCEL), so I'll have more data
available....
What do you get with:
=RCHGetElementNumber("Version")
=smfGetGuruFocusItem("AAPL",1,"TTM")
=smfConvertData(smfGetTagContent("https://www.gurufocus.com/financials/AAPL",
"div", -1, "id=""Rf""", "/term/per share rev/", "yesttm"))
On Tue, Jun 20, 2017 at 9:58 AM, codyklein@
...
wrote:
>
> Thanks Randy, I opened the template and it doesn't seem to be working. All
> the cells are filled with "Error". I tried AAPL.
>
>
>
It appears to be working fine here:
*AAPL*
Fiscal Periods Sep02 Sep03 Sep04 Sep05 Sep06
Revenue per Share 1.13 1.23 1.53 2.32 3.14
EBITDA per Share 0.03 0.04 0.1 0.3 0.44
I am a subscriber (and logged in with EXCEL), so I'll have more data
available....
What do you get with:
=RCHGetElementNumber("Version")
=smfGetGuruFocusItem("AAPL",1,"TTM")
=smfConvertData(smfGetTagContent("https://www.gurufocus.com/financials/AAPL",
"div"
On Tue, Jun 20, 2017 at 9:58 AM, codyklein@
...
wrote:
>
> Thanks Randy, I opened the template and it doesn't seem to be working. All
> the cells are filled with "Error"
>
>
>
Tue Jun 20, 2017 11:47 am (PDT) . Posted by:
jimw1705
Anyone know what happened to the Yahoo Finance portfolios? Comes up with nothing now.
Also, looks like we will have to find another data source, just based on what may be coming. Are there any sources that work with smh_addin?
hanks
Also, looks like we will have to find another data source, just based on what may be coming. Are there any sources that work with smh_addin?
hanks
Tue Jun 20, 2017 1:35 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The portfolio view data is now delivered as JSON data, and they dynamically
build the table from that data. I've been playing around with it, creating
an artificial Yahoo "module" for the smfGetYahooJSONField() function. For
example, I can currently get the trailing P/E for MMM and IBM using:
=smfGetYahooJSONField("MMM,IBM","portfolioView","quoteResponse.result.0.
trailingPE")
=smfGetYahooJSONField("MMM,IBM","portfolioView","quoteResponse.result.1.
trailingPE")
...where the function is:
=smfGetYahooJSONField(tickerlist,"portfolioView",fullyqualifiedfieldname)
...but I'm not sure the returned data is always positional (i.e. the second
to last qualifier n the field name varying from 0 to n). What I'm
considering is changing smfGetYahooPortfolioView() to obsolete the "pView"
parameter, just return each ticker in the JSON file, but use the "pItems"
parameter to allow the choices of the several dozen fields available.
On Tue, Jun 20, 2017 at 11:47 AM, jimw@
...
wrote:
> Anyone know what happened to the Yahoo Finance portfolios? Comes up with
> nothing now.
>
> Also, looks like we will have to find another data source, just based on
> what may be coming. Are there any sources that work with smh_addin?
>
build the table from that data. I've been playing around with it, creating
an artificial Yahoo "module" for the smfGetYahooJSONFiel
example, I can currently get the trailing P/E for MMM and IBM using:
=smfGetYahooJSONFie
trailingPE"
=smfGetYahooJSONFie
trailingPE"
...where the function is:
=smfGetYahooJSONFie
...but I'm not sure the returned data is always positional (i.e. the second
to last qualifier n the field name varying from 0 to n). What I'm
considering is changing smfGetYahooPortfoli
parameter, just return each ticker in the JSON file, but use the "pItems"
parameter to allow the choices of the several dozen fields available.
On Tue, Jun 20, 2017 at 11:47 AM, jimw@
...
wrote:
> Anyone know what happened to the Yahoo Finance portfolios? Comes up with
> nothing now.
>
> Also, looks like we will have to find another data source, just based on
> what may be coming. Are there any sources that work with smh_addin?
>
Tue Jun 20, 2017 1:16 pm (PDT) . Posted by:
friedman_steve
I'm trying to download the full table showing institutional holders, but having trouble.
here's website link
http://www.nasdaq.com/symbol/mmm/institutional-holdings http://www.nasdaq.com/symbol/mmm/institutional-holdings
could you help? Thanks in advance.
here's website link
http://www.nasdaq.com/symbol/mmm/institutional-holdings http://www.nasdaq.com/symbol/mmm/institutional-holdings
could you help? Thanks in advance.
Tue Jun 20, 2017 1:55 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=RCHGetHTMLTable("http://www.nasdaq.com/symbol/mmm/institutional-holdings",">Owner
Name")
On Tue, Jun 20, 2017 at 1:16 PM, friedman_steve@
...
wrote:
>
> I'm trying to download the full table showing institutional holders, but
> having trouble.
>
> here's website link
> http://www.nasdaq.com/symbol/mmm/institutional-holdings
>
> could you help? Thanks in advance.
>
=RCHGetHTMLTable("http://www.nasdaq.com/symbol/mmm/institutional-holdings",">Owner
Name")
On Tue, Jun 20, 2017 at 1:16 PM, friedman_steve@
...
wrote:
>
> I'm trying to download the full table showing institutional holders, but
> having trouble.
>
> here's website link
> http://www.nasdaq.com/symbol/mmm/institutional-holdings
>
> could you help? Thanks in advance.
>
Tue Jun 20, 2017 1:25 pm (PDT) . Posted by:
tonyestep
Randy, I am getting confusing results with the latest Historical Quotes version.
I use a date window from 1 year ago today, through today. If I run the fetch routine during the day, of course the price it gets for today is the delayed last-sale price at that time. So far, so good.
But if I re-run it after the close, it does not get the closing price. Instead it again returns the price it got earlier in the day. Trying to recalc the sheet either manually or via VBA does not cause it to renew the prices. Only quitting Excel and starting over from scratch can make it deliver the correct prices.
The previous version did not display this behavior. It could be updated any time by recalculating the workbook. I have a copy of the previous version, but it's no longer on the ogres-crypt site, so if I were to lose it I'd have to use the present version.
Can you offer some advice here?
Thanks,
Tony
I use a date window from 1 year ago today, through today. If I run the fetch routine during the day, of course the price it gets for today is the delayed last-sale price at that time. So far, so good.
But if I re-run it after the close, it does not get the closing price. Instead it again returns the price it got earlier in the day. Trying to recalc the sheet either manually or via VBA does not cause it to renew the prices. Only quitting Excel and starting over from scratch can make it deliver the correct prices.
The previous version did not display this behavior. It could be updated any time by recalculating the workbook. I have a copy of the previous version, but it's no longer on the ogres-crypt site, so if I were to lose it I'd have to use the present version.
Can you offer some advice here?
Thanks,
Tony
Tue Jun 20, 2017 1:38 pm (PDT) . Posted by:
tonyestep
Re my previous posting, all I need is a way to force the spreadsheet to go back to Yahoo and reload the page. The older add-in did this on a recalc, but the new one doesn't. Something seems to buffer the Yahoo reply in a strange way. If for example I go for a different ticker, the answer comes back instantly, without re-accessing Yahoo. If I change the date range, it does go to Yahoo to get the new data, but if I then restore the date range to the original query, the prices pop up instantly without going to Yahoo, as if that whole mass of prices has been buffered somewhere. I'm running out of things to try.
Tue Jun 20, 2017 1:59 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Because it's now retrieving the data from a web page instead of a CSV file,
the add-in is saving a copy of the web page and then extracting the data.
The only way to get a new copy of the web page is to run the
smfForceRecalculation macro (or to exit and restart EXCEL). Any type of
EXCEL recalculation won't do the trick, as it will just re-extract the data
from the same saved copy of the web page.
On Tue, Jun 20, 2017 at 1:38 PM, tonyestep@
...
wrote:
>
> Re my previous posting, all I need is a way to force the spreadsheet to go
> back to Yahoo and reload the page. The older add-in did this on a recalc,
> but the new one doesn't. Something seems to buffer the Yahoo reply in a
> strange way. If for example I go for a different ticker, the answer comes
> back instantly, without re-accessing Yahoo. If I change the date range, it
> does go to Yahoo to get the new data, but if I then restore the date range
> to the original query, the prices pop up instantly without going to Yahoo,
> as if that whole mass of prices has been buffered somewhere. I'm running
> out of things to try.
>
the add-in is saving a copy of the web page and then extracting the data.
The only way to get a new copy of the web page is to run the
smfForceRecalculati
EXCEL recalculation won't do the trick, as it will just re-extract the data
from the same saved copy of the web page.
On Tue, Jun 20, 2017 at 1:38 PM, tonyestep@
...
wrote:
>
> Re my previous posting, all I need is a way to force the spreadsheet to go
> back to Yahoo and reload the page. The older add-in did this on a recalc,
> but the new one doesn't. Something seems to buffer the Yahoo reply in a
> strange way. If for example I go for a different ticker, the answer comes
> back instantly, without re-accessing Yahoo. If I change the date range, it
> does go to Yahoo to get the new data, but if I then restore the date range
> to the original query, the prices pop up instantly without going to Yahoo,
> as if that whole mass of prices has been buffered somewhere. I'm running
> out of things to try.
>
Tue Jun 20, 2017 2:24 pm (PDT) . Posted by:
tonyestep
Thanks for your reply, Randy. The smfForceRecalculation is what I need.
However, when I try to invoke it I get a "Sub or Function not defined" error. How do I fix this?
However, when I try to invoke it I get a "Sub or Function not defined" error. How do I fix this?
Tue Jun 20, 2017 2:28 pm (PDT) . Posted by:
tonyestep
I can find the smfForceRecalculation() procedure, but for whatever reason I can't invoke it with VBA code from my spreadsheet. I must be a dummy. What am I doing wrong???
Tue Jun 20, 2017 2:29 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
In VBA, you need to set a reference to the add-in to have it available.
On Tue, Jun 20, 2017 at 2:24 PM, tonyestep@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks for your reply, Randy. The smfForceRecalculation is what I need.
>
> However, when I try to invoke it I get a "Sub or Function not defined"
> error. How do I fix this?
>
On Tue, Jun 20, 2017 at 2:24 PM, tonyestep@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks for your reply, Randy. The smfForceRecalculati
>
> However, when I try to invoke it I get a "Sub or Function not defined"
> error. How do I fix this?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar