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.
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@Gusristic @NeutrinoPanda