EXCEL FEED: RE: Re: [smf_addin] Financials not matching web

Senin, 16 Maret 2020

RE: Re: [smf_addin] Financials not matching web

Dear Carl,

Thank You.

What Randy does is so sophisticated and so complicated. That I normally just use what ever was posted on his website.

I just like looking at the spreadsheets that has either 5 or 10 years of dividends and eps in a row.

Basically, I just look to see not the growth, but more emphasis on not going down, in either the eps or dividends.

I just look for kind of steadiness in earnings and dividends.

I used to use Randy's spreadsheet from Morningstar financials spreadsheet that pulled: 5-10 years of eps, dividends, book value per share, sales per share ect…everything down from Morningstar in 1 file.

Carl, so if you would Pls send me whatever you have.

I have not idea what JSON is?

But I am willing to learn or at least try to learn.

Just tell me what to do, I will do it.

Thanks,

Rene

Sent from Mail for Windows 10

From: Carl Mims carlmims@gmail.com [smf_addin]
Sent: Monday, March 16, 2020 3:29 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Financials not matching web

Rene

Did not use a template. Actually pull using the element #s and JSON using a Visual Basic program since it gets put direct into an Access Database.

I have a simple spread sheet that I use to pull single companies for a test. It was probably based on an old file I found posted years ago.

Will be glad to share that if it helps. Want me to share that file with you.

Carl

On Mar 16, 2020, at 2:04 PM, Rene gamil rr76012@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Hello Carl,

Would you please help me.

What file are you using to pull financials from yahoo.

I remember there used to be a template file very popular, but I can not remember the name of the file.

I would like to pull stock company financials to review.

Carl, Thank You.

Rene

Sent from Mail for Windows 10

From: Carl Mims carlmims@gmail.com [smf_addin]
Sent: Monday, March 16, 2020 2:41 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Financials not matching web

Randy

I use SMF to pull financials from Yahoo, been doing this for many years. Great tool. However this month a few companies are way off and do not agree with finance.yahoo.com

For example from finance.yahoo.com
<PastedGraphic-1.png>

Using HLT on SMF Stock Market Functions add-in, Version 2.1.2017.11.30 (C:\SMF Add-In; Windows (32-bit) NT 6.03; 16.0; ; Local; 1)

Function is =RCHGetElementNumber(HLT,956)*1000 The Revenue # is way off. What is show on the website above looks to be correct base on past years.

<PastedGraphic-2.png>

<A80204B967A74D90B11CB85B08B51B91.png>