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

Senin, 16 Maret 2020

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>