Yahoo Finance

부분 유료
분류별 Api Dojo | 업데이트됨 8 hours ago | Finance
인기

9.9 / 10

지연 시간

1,714ms

서비스 수준

100%

Health Check

N/A

모든 토론으로 돌아가기

missing data cash flow, balance sheet and income statement

Rapid account: Charliex
charliex
3 months ago

Hi,

I put this as a comment on an earlier post but was worried you might miss it. I think this is a problem for all stocks but I will demo with Apple (code AAPL) as below.

check data is in yahoo
On the yahoo website - I navigate to https://uk.finance.yahoo.com/quote/AAPL/financials?p=AAPL.
I click on financials there are 3 options ‘income statement’, ‘balance sheet’, ‘cash flow’ and two time options ‘annual’ and ‘quarterly’. I am choosing ‘annual’ for this demo of the issue.
You can see each of the options above gives plenty of data from different sub fields
so choosing some values to check from yahoo (’/’= field delimiter)
income statement/research development/‘29-09-2023’ = 29,915,000
balance sheet/inventory/‘29-09-2023’ = 6,331,000
cash flow/dividends paid/‘29-09-2023’ = -15,082,000
check ‘income statement’ data is in api- dojo ‘yahoo finance’ app
i use 'stock/v2/get-financials ’ end node for aapl
I navigate to [‘incomeStatementHistory’][‘incomeStatementHistory’]
I check the underlying data for each year
the field ‘research development’ has no data
when I first accessed this api it had multiple years then multiple fields of data per year

check balance sheet data is in api- dojo ‘yahoo finance’ app
i use 'stock/v2/get-financials ’ end node for aapl. I also try stock/v2/get-balance-sheet
I navigate to [“balanceSheetHistory”][“balanceSheetStatements”]
I check the underlying data for each year - there are only dates no other fields with financial data. When I first did the field mapping in api-dojo this is where balance sheet data was

check cash flow data is in api- dojo ‘yahoo finance’ app
i use 'stock/v2/get-financials ’ end node for aapl. I also try stock/v2/get-cash-flow
I navigate to [“cashflowStatementHistory”][“cashflowStatements”]
I check the underlying data for each year - there are dates and ‘net income’ the other cash flow statement is missing. When I first did the field mapping in api-dojo this is where cash flow statement data was
I think there is a problem with how rapid api retrieves data from yahoo. I hope this helps clarify and can you look into it please
I also note a similar post from someone else recently

Rapid account: Charliex
charliex Commented 3 months ago

Thanks for your prompt response the screenshot was really useful in showing what you meant. I’ve managed to remap several fields now. Thankyou.

Rapid account: Apidojo
apidojo Commented 3 months ago

Hello,

You are extracting data from the wrong JSON node that why I replied in the post :
“Please paste the response data in a text editor and search for DISPLAYED VALUES not by the field name to get the correct JSON node. There are lots of sections using similar term and fool you.”

Now, check the screenshot at https://prnt.sc/Q-KT7a-Y5Cjb
You should learn to read with CARE first.

Regards.

아래에 의견을 추가하고 토론에 참여하세요.

새 댓글을 게시하려면 로그인 / 가입