node-yahoo-finance2
node-yahoo-finance2 copied to clipboard
gadicc
No more financial statements data
Edit/Update: Working
Yahoo moved this data from quoteSummary to fundamentalsTimeSeries. See https://github.com/gadicc/node-yahoo-finance2/issues/733#issuecomment-1986835196.
Bug Report
Describe the bug
It stopped providing data on financial statements on all tickers.
Minimal Reproduction
const response = await yahooFinance.quoteSummary("AAPL", { modules: ["cashflowStatementHistory"] }) console.log(response.cashflowStatementHistory)
now returns only this: { cashflowStatements: [ { maxAge: 1, endDate: 2022-12-31T00:00:00.000Z, netIncome: 55740000000 },
Environment
Browser or Node: Node v18.9.0
Npm version: 9.6.0
Library version (): 2.9.0
Additional Context
Also returns error: "FailedYahooValidationError: Failed Yahoo Schema validation"
This may happen intermittently and you should catch errors appropriately. However: 1) if this recently started happening on every request for a symbol that used to work, Yahoo may have changed their API. 2) If this happens on every request for a symbol you've never used before, but not for other symbols, you've found an edge-case (OR, we may just be protecting you from "bad" data sometimes stored for e.g. misspelt symbols on Yahoo's side). Please see if anyone has reported this previously:
https://github.com/gadicc/node-yahoo-finance2/issues?q=is%3Aissue+Failed%20validation%3A%20%23%2Fdefinitions%2FQuoteSummaryResult
or open a new issue (and mention the symbol): yahoo-finance2 v2.9.0
https://github.com/gadicc/node-yahoo-finance2/issues/new?labels=bug%2C+validation&template=validation.md&title=Failed%20validation%3A%20%23%2Fdefinitions%2FQuoteSummaryResult
For information on how to turn off the above logging or skip these errors, see https://github.com/gadicc/node-yahoo-finance2/tree/devel/docs/validation.md.
At the end of the doc, there's also a section on how to Help Fix Validation Errors in case you'd like to contribute to the project. Most of the time, these fixes are very quick and easy; it's just hard for our small core team to keep up, so help is always appreciated!
Hi @vmetnev, thanks for the report.
I'm confirming the issue. The Yahoo Finance website still has all the correct info. I can send an identical query to what their site uses and still don't get all the info. My suspicion is that it has to do with the headers sent, but unfortunately I have no idea when I'll have a chance to look into this. So marking as 'help wanted' for now and sorry I don't have better news.
To be clear, it's not actually a fault with the library per se, Yahoo have changed something on their end and we'll have to figure out exactly what.
On further review (and again, if anyone else wants to take a look at this too, please do!), the information being displayed on e.g.:
https://uk.finance.yahoo.com/quote/AAPL/financials
is no longer coming exclusively from quoteSummary at:
https://query1.finance.yahoo.com/v10/finance/quoteSummary/AAPL?&crumb=XXX&modules=incomeStatementHistory%2CcashflowStatementHistory%2...
which now has a lot of blank data and empty fields:
// Formatted by yf2 to make it easier to read, original has e.g.
// "costOfRevenue": { "raw": 0, "fmt": null, "longFmt": "0" } etc
{
incomeStatementHistory: {
incomeStatementHistory: [
{
maxAge: 1,
endDate: 2023-09-30T00:00:00.000Z,
totalRevenue: 383285000000,
costOfRevenue: 0,
grossProfit: 0,
researchDevelopment: null,
sellingGeneralAdministrative: null,
nonRecurring: null,
otherOperatingExpenses: null,
totalOperatingExpenses: 0,
operatingIncome: null,
totalOtherIncomeExpenseNet: null,
ebit: 0,
interestExpense: null,
incomeBeforeTax: null,
incomeTaxExpense: 0,
minorityInterest: null,
netIncomeFromContinuingOps: null,
discontinuedOperations: null,
extraordinaryItems: null,
effectOfAccountingCharges: null,
otherItems: null,
netIncome: 96995000000,
netIncomeApplicableToCommonShares: null
},
// ...
}
}
but rather, the page is getting the info from timeseries:
https://query2.finance.yahoo.com/ws/fundamentals-timeseries/v1/finance/timeseries/AAPL?lang=en-GB®ion=GB&symbol=AAPL&padTimeSeries=true&type=annualEbitda%2CtrailingEbitda%2CannualDilutedAverageShares%2CtrailingDilutedAverageShares%2CannualBasicAverageShares%2CtrailingBasicAverageShares%2CannualDilutedEPS%2CtrailingDilutedEPS%2CannualBasicEPS%2CtrailingBasicEPS%2CannualNetIncomeCommonStockholders%2CtrailingNetIncomeCommonStockholders%2CannualNetIncome%2CtrailingNetIncome%2CannualNetIncomeContinuousOperations%2CtrailingNetIncomeContinuousOperations%2CannualTaxProvision%2CtrailingTaxProvision%2CannualPretaxIncome%2CtrailingPretaxIncome%2CannualOtherIncomeExpense%2CtrailingOtherIncomeExpense%2CannualInterestExpense%2CtrailingInterestExpense%2CannualOperatingIncome%2CtrailingOperatingIncome%2CannualOperatingExpense%2CtrailingOperatingExpense%2CannualSellingGeneralAndAdministration%2CtrailingSellingGeneralAndAdministration%2CannualResearchAndDevelopment%2CtrailingResearchAndDevelopment%2CannualGrossProfit%2CtrailingGrossProfit%2CannualCostOfRevenue%2CtrailingCostOfRevenue%2CannualTotalRevenue%2CtrailingTotalRevenue&merge=false&period1=493590046&period2=1709803615&corsDomain=uk.finance.yahoo.com
which returns a result like:
{
"timeseries": {
"result": [
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualNetIncomeContinuousOperations"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualNetIncomeContinuousOperations": [
{
"dataId": 20094,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 5.7411E10,
"fmt": "57.41B"
}
},
{
"dataId": 20094,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 9.468E10,
"fmt": "94.68B"
}
},
{
"dataId": 20094,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 9.9803E10,
"fmt": "99.80B"
}
},
{
"dataId": 20094,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 9.6995E10,
"fmt": "97.00B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualTotalRevenue"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualTotalRevenue": [
{
"dataId": 20100,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.74515E11,
"fmt": "274.51B"
}
},
{
"dataId": 20100,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 3.65817E11,
"fmt": "365.82B"
}
},
{
"dataId": 20100,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 3.94328E11,
"fmt": "394.33B"
}
},
{
"dataId": 20100,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 3.83285E11,
"fmt": "383.29B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingBasicAverageShares"
]
},
"timestamp": [
1696032000,
1703980800
],
"trailingBasicAverageShares": [
{
"dataId": 29010,
"asOfDate": "2023-09-30",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.5744231E10,
"fmt": "15.74B"
}
},
{
"dataId": 29010,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.5648491E10,
"fmt": "15.65B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingNetIncomeCommonStockholders"
]
},
"timestamp": [
1703980800
],
"trailingNetIncomeCommonStockholders": [
{
"dataId": 20093,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.00913E11,
"fmt": "100.91B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingResearchAndDevelopment"
]
},
"timestamp": [
1703980800
],
"trailingResearchAndDevelopment": [
{
"dataId": 20151,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.9902E10,
"fmt": "29.90B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualResearchAndDevelopment"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualResearchAndDevelopment": [
{
"dataId": 20151,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.8752E10,
"fmt": "18.75B"
}
},
{
"dataId": 20151,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.1914E10,
"fmt": "21.91B"
}
},
{
"dataId": 20151,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.6251E10,
"fmt": "26.25B"
}
},
{
"dataId": 20151,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.9915E10,
"fmt": "29.91B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualCostOfRevenue"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualCostOfRevenue": [
{
"dataId": 20013,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.69559E11,
"fmt": "169.56B"
}
},
{
"dataId": 20013,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.12981E11,
"fmt": "212.98B"
}
},
{
"dataId": 20013,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.23546E11,
"fmt": "223.55B"
}
},
{
"dataId": 20013,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.14137E11,
"fmt": "214.14B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingOperatingIncome"
]
},
"timestamp": [
1703980800
],
"trailingOperatingIncome": [
{
"dataId": 20109,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.18658E11,
"fmt": "118.66B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingOtherIncomeExpense"
]
},
"timestamp": [
1703980800
],
"trailingOtherIncomeExpense": [
{
"dataId": 20117,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": -3.9E7,
"fmt": "-39.00M"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingCostOfRevenue"
]
},
"timestamp": [
1703980800
],
"trailingCostOfRevenue": [
{
"dataId": 20013,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.12035E11,
"fmt": "212.03B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualBasicAverageShares"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualBasicAverageShares": [
{
"dataId": 29010,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.7352119E10,
"fmt": "17.35B"
}
},
{
"dataId": 29010,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.6701272E10,
"fmt": "16.70B"
}
},
{
"dataId": 29010,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.6215963E10,
"fmt": "16.22B"
}
},
{
"dataId": 29010,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.5744231E10,
"fmt": "15.74B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingTotalRevenue"
]
},
"timestamp": [
1703980800
],
"trailingTotalRevenue": [
{
"dataId": 20100,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 3.85706E11,
"fmt": "385.71B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualNetIncomeCommonStockholders"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualNetIncomeCommonStockholders": [
{
"dataId": 20093,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 5.7411E10,
"fmt": "57.41B"
}
},
{
"dataId": 20093,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 9.468E10,
"fmt": "94.68B"
}
},
{
"dataId": 20093,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 9.9803E10,
"fmt": "99.80B"
}
},
{
"dataId": 20093,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 9.6995E10,
"fmt": "97.00B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualPretaxIncome"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualPretaxIncome": [
{
"dataId": 20136,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 6.7091E10,
"fmt": "67.09B"
}
},
{
"dataId": 20136,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.09207E11,
"fmt": "109.21B"
}
},
{
"dataId": 20136,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.19103E11,
"fmt": "119.10B"
}
},
{
"dataId": 20136,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.13736E11,
"fmt": "113.74B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualInterestExpense"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualInterestExpense": [
{
"dataId": 20057,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.873E9,
"fmt": "2.87B"
}
},
{
"dataId": 20057,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.645E9,
"fmt": "2.65B"
}
},
{
"dataId": 20057,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.931E9,
"fmt": "2.93B"
}
},
{
"dataId": 20057,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 3.933E9,
"fmt": "3.93B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingDilutedAverageShares"
]
},
"timestamp": [
1696032000,
1703980800
],
"trailingDilutedAverageShares": [
{
"dataId": 29011,
"asOfDate": "2023-09-30",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.5812547E10,
"fmt": "15.81B"
}
},
{
"dataId": 29011,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.571777775E10,
"fmt": "15.72B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualDilutedAverageShares"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualDilutedAverageShares": [
{
"dataId": 29011,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.7528214E10,
"fmt": "17.53B"
}
},
{
"dataId": 29011,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.6864919E10,
"fmt": "16.86B"
}
},
{
"dataId": 29011,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.6325819E10,
"fmt": "16.33B"
}
},
{
"dataId": 29011,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.5812547E10,
"fmt": "15.81B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualTaxProvision"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualTaxProvision": [
{
"dataId": 20145,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 9.68E9,
"fmt": "9.68B"
}
},
{
"dataId": 20145,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.4527E10,
"fmt": "14.53B"
}
},
{
"dataId": 20145,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.93E10,
"fmt": "19.30B"
}
},
{
"dataId": 20145,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.6741E10,
"fmt": "16.74B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingNetIncome"
]
},
"timestamp": [
1703980800
],
"trailingNetIncome": [
{
"dataId": 20091,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.00913E11,
"fmt": "100.91B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingPretaxIncome"
]
},
"timestamp": [
1703980800
],
"trailingPretaxIncome": [
{
"dataId": 20136,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.18436E11,
"fmt": "118.44B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualNetIncome"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualNetIncome": [
{
"dataId": 20091,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 5.7411E10,
"fmt": "57.41B"
}
},
{
"dataId": 20091,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 9.468E10,
"fmt": "94.68B"
}
},
{
"dataId": 20091,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 9.9803E10,
"fmt": "99.80B"
}
},
{
"dataId": 20091,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 9.6995E10,
"fmt": "97.00B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualGrossProfit"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualGrossProfit": [
{
"dataId": 20046,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.04956E11,
"fmt": "104.96B"
}
},
{
"dataId": 20046,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.52836E11,
"fmt": "152.84B"
}
},
{
"dataId": 20046,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.70782E11,
"fmt": "170.78B"
}
},
{
"dataId": 20046,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.69148E11,
"fmt": "169.15B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualBasicEPS"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualBasicEPS": [
{
"dataId": 29004,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 3.31,
"fmt": "3.31"
}
},
{
"dataId": 29004,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 5.67,
"fmt": "5.67"
}
},
{
"dataId": 29004,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 6.15,
"fmt": "6.15"
}
},
{
"dataId": 29004,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 6.16,
"fmt": "6.16"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingDilutedEPS"
]
},
"timestamp": [
1696032000,
1703980800
],
"trailingDilutedEPS": [
{
"dataId": 29009,
"asOfDate": "2023-09-30",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 6.13,
"fmt": "6.13"
}
},
{
"dataId": 29009,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 6.43,
"fmt": "6.43"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualSellingGeneralAndAdministration"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualSellingGeneralAndAdministration": [
{
"dataId": 20159,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.9916E10,
"fmt": "19.92B"
}
},
{
"dataId": 20159,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.1973E10,
"fmt": "21.97B"
}
},
{
"dataId": 20159,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.5094E10,
"fmt": "25.09B"
}
},
{
"dataId": 20159,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.4932E10,
"fmt": "24.93B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingTaxProvision"
]
},
"timestamp": [
1703980800
],
"trailingTaxProvision": [
{
"dataId": 20145,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.7523E10,
"fmt": "17.52B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualOtherIncomeExpense"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualOtherIncomeExpense": [
{
"dataId": 20117,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": -8.7E7,
"fmt": "-87.00M"
}
},
{
"dataId": 20117,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 6.0E7,
"fmt": "60.00M"
}
},
{
"dataId": 20117,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": -2.28E8,
"fmt": "-228.00M"
}
},
{
"dataId": 20117,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": -3.82E8,
"fmt": "-382.00M"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingGrossProfit"
]
},
"timestamp": [
1703980800
],
"trailingGrossProfit": [
{
"dataId": 20046,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.73671E11,
"fmt": "173.67B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualOperatingIncome"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualOperatingIncome": [
{
"dataId": 20109,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 6.6288E10,
"fmt": "66.29B"
}
},
{
"dataId": 20109,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.08949E11,
"fmt": "108.95B"
}
},
{
"dataId": 20109,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.19437E11,
"fmt": "119.44B"
}
},
{
"dataId": 20109,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.14301E11,
"fmt": "114.30B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingOperatingExpense"
]
},
"timestamp": [
1703980800
],
"trailingOperatingExpense": [
{
"dataId": 20108,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 5.5013E10,
"fmt": "55.01B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingNetIncomeContinuousOperations"
]
},
"timestamp": [
1703980800
],
"trailingNetIncomeContinuousOperations": [
{
"dataId": 20094,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 1.00913E11,
"fmt": "100.91B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualOperatingExpense"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualOperatingExpense": [
{
"dataId": 20108,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 3.8668E10,
"fmt": "38.67B"
}
},
{
"dataId": 20108,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 4.3887E10,
"fmt": "43.89B"
}
},
{
"dataId": 20108,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 5.1345E10,
"fmt": "51.34B"
}
},
{
"dataId": 20108,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 5.4847E10,
"fmt": "54.85B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingSellingGeneralAndAdministration"
]
},
"timestamp": [
1703980800
],
"trailingSellingGeneralAndAdministration": [
{
"dataId": 20159,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 2.5111E10,
"fmt": "25.11B"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingBasicEPS"
]
},
"timestamp": [
1696032000,
1703980800
],
"trailingBasicEPS": [
{
"dataId": 29004,
"asOfDate": "2023-09-30",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 6.16,
"fmt": "6.16"
}
},
{
"dataId": 29004,
"asOfDate": "2023-12-31",
"periodType": "TTM",
"currencyCode": "USD",
"reportedValue": {
"raw": 6.46,
"fmt": "6.46"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"annualDilutedEPS"
]
},
"timestamp": [
1601424000,
1632960000,
1664496000,
1696032000
],
"annualDilutedEPS": [
{
"dataId": 29009,
"asOfDate": "2020-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 3.28,
"fmt": "3.28"
}
},
{
"dataId": 29009,
"asOfDate": "2021-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 5.61,
"fmt": "5.61"
}
},
{
"dataId": 29009,
"asOfDate": "2022-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 6.11,
"fmt": "6.11"
}
},
{
"dataId": 29009,
"asOfDate": "2023-09-30",
"periodType": "12M",
"currencyCode": "USD",
"reportedValue": {
"raw": 6.13,
"fmt": "6.13"
}
}
]
},
{
"meta": {
"symbol": [
"AAPL"
],
"type": [
"trailingInterestExpense"
]
}
}
],
"error": null
}
}
So I think the right way to go about this is to create a new module to consume timeseries.
Massive thanks to @Shadaeiou for his quick and amazing work implementing fundamentalsTimeseries in #745, #748.
I guess we'll still need to update the quoteSummary financial statements docs to make this clearer, but in the meantime, please see the timeseries docs to once again be able to access financials information! :rocket: