Kamis, 04 Mei 2017

[smf_addin] Digest Number 3995

14 Messages

Digest #3995
2a
2c
Re: smf's price functions by "Randy Harmelink" rharmelink
3a
4b
Re: Option functions not working this week by "Randy Harmelink" rharmelink
5a
Re: Automatically build data sheets by "koby vlotchek" vlotchek@gmail.com
5b
Re: Automatically build data sheets by "Randy Harmelink" rharmelink
6a
6b
Re: Are they out to get us? by "Randy Harmelink" rharmelink
7
Yahoo KS page by indinvestor111

Messages

Thu May 4, 2017 5:16 am (PDT) . Posted by:

bushpilote

Good morning Randy,
the dinosaur in me was forced to move from vista to windows 10, hence all the questions of the last two days.

smfLastPrice, smfPricesByDates, smfPricesBetween and smfLowBetween have stopped working for me in excel 2007 with latest smf add-in. Are you experiencing the same issues?




Thu May 4, 2017 5:26 am (PDT) . Posted by:

bushpilote

Randy,
could this be another "http"-"https" issue and if so how do I fix it?

Thu May 4, 2017 9:46 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

smfLastPrice() and smfLowBetween() are not supported functions.

smfPricesByDates() and smfPricesBetween() require the most recent version
of the add-in. They did stop working last month.

On Thu, May 4, 2017 at 5:16 AM, bushpilote@
​...wrote:

>
> the dinosaur in me was forced to move from vista to windows 10, hence all
> the questions of the last two days.
>
> smfLastPrice, smfPricesByDates, smfPricesBetween and smfLowBetween have
> stopped working for me in excel 2007 with latest smf add-in. Are you
> experiencing the same issues?
>
>
>
>
>
>
>

Thu May 4, 2017 11:07 am (PDT) . Posted by:

bushpilote

I thought 03-15 was the latest version. All is good.
Thanks Randy.

Thu May 4, 2017 8:56 am (PDT) . Posted by:

trendsekr

Stock functions are fine, but all options functions return errors of nothing for both yahoo and google. Did something happen?


Thanks,


Michael

Thu May 4, 2017 9:51 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Without any examples to test, my best guess is that you need the most
recent version of the add-in. There were a lot of Yahoo changes last week.
In any case, Google is missing a lot of expiration dates. Yahoo and
Barchart returned a bid price for "MMM 5/5 2017 $200 Call" when I tried it,
but not Google.

On Thu, May 4, 2017 at 8:56 AM, trendsekr@
​...wrote:

> Stock functions are fine, but all options functions return errors of
> nothing for both yahoo and google. Did something happen?
>

Thu May 4, 2017 11:08 am (PDT) . Posted by:

"koby vlotchek" vlotchek@gmail.com

Hi Randy,

I'm trying to download from Yahoo and Google, financial reports. Balance
sheets, Income, and Cash flow.
But it doesn't work.

I manage to pull out the Information from MarketWatch, but I'm missing
important information like Non-Gaap Net Income

-52,667 -29,438 -4,816
What should I do?

Thanks
Koby

2017-04-21 11:55 GMT+03:00 Randy Harmelink rharmelink@gmail.com [smf_addin]
<smf_addin@yahoogroups.com>:

>
>
> Take a look at some of the templates on the add-in web site. There are
> some examples. In particular, check out AdvFn (in
> http://ogres-crypt.com/SMF/Templates) and GuruFocus (in
> http://ogres-crypt.com/SMF/Works-In-Progress).
>
> By far, the quickest is just to use one or more of the MorningStar CSV
> files that are available:
>
> =smfGetCSVFile("http://financials.morningstar.com/
> ajax/exportKR2CSV.html?t=MMM")
>
> =smfGetCSVFile("http://financials.morningstar.com/
> ajax/ReportProcess4CSV.html?t=MMM&reportType=is&period=12&
> dataType=A&order=asc&columnYear=10&rounding=3&denominatorView=raw")
>
> See the "Tips and FAQs" web page to see how the parameters can be varied
> on these...
>
> On Fri, Apr 21, 2017 at 1:16 AM, vlotchek@
> ​...wrote:
>
>> I would like to build data sheets, pulling out from the web balance
>> sheets, income statements, and cash flow.
>>
>> I looked into youtube, but my excel wants to pull the data for some
>> reason.
>>
>> do you know where can I find a good guide who can help me build data
>> sheet when I put a ticker name and push the button it will download all the
>> information from the web automatically?
>>
>>
>
>

Thu May 4, 2017 11:40 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The Google templates seem to work for me, using ticker MMM:

http://ogres-crypt.com/SMF/Templates/#Google

Yahoo is currently AWOL because of their switch-over to using JSON calls
and building the web page dynamically. The data can be retrieved, but it
requires knowledge of their modules and field names. For example, to get
total revenues from the annual income statement:

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

=smfGetYahooJSONField("MMM","incomeStatementHistory&quot;,"quoteSummary.result.0.incomeStatementHistory.incomeStatementHistory.1.totalRevenue.raw")

=smfGetYahooJSONField("MMM","incomeStatementHistory&quot;,"quoteSummary.result.0.incomeStatementHistory.incomeStatementHistory.2.totalRevenue.raw")

On Thu, May 4, 2017 at 11:08 AM, koby vlotchek vlotchek@
​...wrote:

>
> I'm trying to download from Yahoo and Google, financial reports. Balance
> sheets, Income, and Cash flow.
> But it doesn't work.
>
> I manage to pull out the Information from MarketWatch, but I'm missing
> important information like Non-Gaap Net Income
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> -52,667
> -29,438
> -4,816
> What should I do?
>
>
>

Thu May 4, 2017 12:19 pm (PDT) . Posted by:

DefelRadar

Randy I must say you have been updating your butt off!! It seems Yahoo and others are changing things just to spite you! Is Zack's in this group as well?


I am trying to use =RCHGetElementNumber($A$3,1287) among others in that group and they come back as Error for me. If I look at smf-elements-8.txt


1287;ZacksEA;Quarterly Earnings -- Estimated EPS -- 1;=SUBSTITUTE(smfWord(smfWord(smfStrExtr(RCHGetWebData("https://www.zacks.com/stock/research/~~~~/earnings-announcements","var obj = {"),": ",":"),3,"["),3,","),"""","")



where the web address is in there appears to be correct but what the other items/formulas do I have no idea


Is there some issue with Zacks? I can bring in ADVfn items just fine as well as other Zack's items from smf-elements-6.txt such as =RCHGetElementNumber(A3,849) but the Zack's items from smf-elements-8.txt reprot back Error.


Thanks!


Aaron

Thu May 4, 2017 12:48 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Those elements were just updated a few days ago:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/31949

On Thu, May 4, 2017 at 12:18 PM, defelradar@
​...wrote:

> Randy I must say you have been updating your butt off!! It seems Yahoo
> and others are changing things just to spite you! Is Zack's in this group
> as well?
>
> I am trying to use =RCHGetElementNumber($A$3,1287) among others in that
> group and they come back as Error for me. If I look at smf-elements-8.txt
>
> 1287;ZacksEA;Quarterly Earnings -- Estimated EPS --
> 1;=SUBSTITUTE(smfWord(smfWord(smfStrExtr(RCHGetWebData("http
> s://www.zacks.com/stock/research/~~~~/earnings-announcements","var obj =
> {"),": ",":"),3,"["),3,","),"""","")
>
> where the web address is in there appears to be correct but what the other
> items/formulas do I have no idea
>
> Is there some issue with Zacks? I can bring in ADVfn items just fine as
> well as other Zack's items from smf-elements-6.txt such
> as =RCHGetElementNumber(A3,849) but the Zack's items from
> smf-elements-8.txt reprot back Error.
>
>

Thu May 4, 2017 1:05 pm (PDT) . Posted by:

indinvestor111

Hi,


It appears several items on the KS page are returning "N/A" for all tickers. This is not a fault of the add-in, as the webpage itself isn't generating values for several of the listed items - EV, EBITDA, float, revenue, etc.


Not a good sign!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 19.09

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)