Skip to content
This repository has been archived by the owner on Feb 2, 2023. It is now read-only.

How can I get this value? #240

Open
Gusristic opened this issue Aug 11, 2022 · 1 comment
Open

How can I get this value? #240

Gusristic opened this issue Aug 11, 2022 · 1 comment

Comments

@Gusristic
Copy link

Captura de pantalla 2022-08-11 203636

I get a 4 x 3 matrix. But I want the 0year netIncome in raw.
=importjson("https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=cashflowStatementHistory";"/quoteSummary/result/cashflowStatementHistory/cashflowStatements/netIncome";"noInherit")

@NeutrinoPanda
Copy link

Wrap this in an index() function. So:
=index(importjson("[https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=cashflowStatementHistory";"/quoteSummary/result/cashflowStatementHistory/cashflowStatements/netIncome";"noInherit](https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=cashflowStatementHistory%22;%22/quoteSummary/result/cashflowStatementHistory/cashflowStatements/netIncome%22;%22noInherit)"),2,1)

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants