[Bug] Unable to pull multiple earnings reports using for loop

[kchander92]

I'm trying to write a for loop to pull cash statements for all the tickers in the NYSE. The for loop below contains a try-except block for when quarterly cash statements for a given ticker cannot be returned from Polygon from the last ten years:

cash_statements = {}

for ticker in nyse.symbol:
    try:
        cash_statements[ticker] = obb.equity.fundamental.cash(ticker, provider="polygon", limit=40, period='quarter').to_df()
    except:
        print('{} not available'.format(ticker))

A sample of the output is shown below, with the following tickers not having cash statements available as the for loop is executing:

Note that "JPM not available" is underlined. The quarterly cash statements from the last 10 years couldn't be pulled using the for loop. However, when I call the code below to pull JPM's cash statements, I do get an output:
obb.equity.fundamental.cash('JPM', provider="polygon", limit=40, period='quarter').to_df()

(The dataframe has been truncated for the sake of brevity.)

Do you know what could be causing this inconsistency, for the stand-alone cash statement query to work for JPM but not when it's run in a for loop? Is there a better way you would recommend pulling the cash statements for multiple tickers? Thanks.

• OS: Windows 11
• Python version 3.11.8

[IgorWounds]

Hello,

Can you check your Polygon API key privileges and make sure that you're not being rate-limited?

I can't reproduce this on my end completely as I'm not sure what nyse.symbol looks like. Here is a dummy version that works for me:

cash_statements = {}
symbols = ["JPM", "XOM", "MA"]

for ticker in symbols:
    try:
        cash_statements[ticker] = obb.equity.fundamental.cash(ticker, provider="polygon", limit=40, period='quarter').to_df()
    except Exception as e:
        print(e)

[kchander92]

It looks like the free plan for Polygon as the source allows 5 API calls per minute, so there does appear to be rate limiting going on.

[IgorWounds]

Can you show me the full exception that is being thrown, please?

[deeleeramone]

FYI, Polygon uses a period for share classes and not a "-". BRK-A = BRK.A