Re: [smf_addin] Financials not matching web

Yes, I actually use JSON files in my VB program.  Still test on an exile sheet the checks both JSON and the Elements which do not always agree.  JSON almost always agrees with the website except in this case.

On Mar 16, 2020, at 5:22 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

You need to pull data from the JSON files now. For example, using the list of "modules" and "field names" found in the "Elements" folder on the website for stocks:

=smfGetYahooJSONField("HLT","cashflowStatementHistory","quoteSummary.result.0.cashflowStatementHistory.cashflowStatements.0.netIncome.raw")

Module	Usable field name
cashflowStatementHistory	quoteSummary.result.0.cashflowStatementHistory.cashflowStatements.0.netIncome.raw
cashflowStatementHistory	quoteSummary.result.0.cashflowStatementHistory.cashflowStatements.1.netIncome.raw
cashflowStatementHistory	quoteSummary.result.0.cashflowStatementHistory.cashflowStatements.2.netIncome.raw
cashflowStatementHistoryQuarterly	quoteSummary.result.0.cashflowStatementHistoryQuarterly.cashflowStatements.0.netIncome.raw
cashflowStatementHistoryQuarterly	quoteSummary.result.0.cashflowStatementHistoryQuarterly.cashflowStatements.1.netIncome.raw
cashflowStatementHistoryQuarterly	quoteSummary.result.0.cashflowStatementHistoryQuarterly.cashflowStatements.2.netIncome.raw
cashflowStatementHistoryQuarterly	quoteSummary.result.0.cashflowStatementHistoryQuarterly.cashflowStatements.3.netIncome.raw

On Mon, Mar 16, 2020 at 2:14 PM Rene gamil rr76012@... wrote:

 

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..

 

<PastedGraphic-1.png><PastedGraphic-2.png>