[BUG] =BINANCE("orders/table") keeps fetching forever and shows nothing

[ivanguinea]

Describe the bug
We have the following formula: =BINANCER("orders/table"; Dashboard!B8:C)
which gets this list of coins:

ADA
ATOM
AVAX
BNB
BTC
BUSD
DIA
DOT
ETH
FTM
LUNA

but unfortunatelly the tab keeps loading forever whit this message "Do NOT add/remove/alter this table data by hand! --- Polling"

The private api key is set because i can see the open order table, however i cannot see the order table general tab.

[ShoaibZahoor]

Hi , i am having the same issue. @ ivanguines did you manage to figure out or there any workaround for this.
@diegomanuel , Any luck on this

[ivanguinea]

Nope, nothing here.

[joeric1028]

Same issue here. Unfortunately, I saw the execution logs that the range mentioned above has the indefinite rows to check but only 11 tickers are found. It means that all empty string will be checked all throughout the range. It causes the execution not to finish the task.

The better workaround for us end users will limit the range to the last available tickers you provided.

From this,
=BINANCER("orders/table"; Dashboard!B8:C)

To this,
=BINANCER("orders/table"; Dashboard!B8:B19)

[ivanguinea]

Hi @joeric1028 thanks for the update, but it changes nothing...

[joeric1028]

Can you provide the location of your ticker list in the sheet?

[ivanguinea]

Sure. Ticker list and formulas used can be downloaded here:

https://mentalrepublic.com/presentaciones/1.png
https://mentalrepublic.com/presentaciones/2.png

[Alexander-Shukaev]

Same issue.

[costezki]

@diegomanuel, any updates on this?
Just in case it helps, here are some snapshots.

[minkaka]

I have the same problem, has anyone found a way.

[tot-truong]

When I created a new sheet it didn't work neither. The orders woudl'nt get fetched but when I created a copy of the demo sheet it worked fine.

https://docs.google.com/spreadsheets/d/1AcOcPFsncrDB_ve3wWMHwfiFql6A4hmG1sFc01LLTDg/edit#gid=1620505585