KeyError: 'BTS_BTC' about pgportfolio

[tiassap]

Hello,
I am also facing this error. Seems like the error comes out when using class CoinList(), there is a mismatch between dict key from self._polo.marketVolume() and self._polo.marketTicker()

  File "/home/tias/Data_science/1_project/zhengyaojiang_pgportfolio_dev/pgportfolio/marketdata/coinlist.py", line 36, in __init__
    prices.append(1.0 / float(ticker[k]['last']))
KeyError: 'BTS_BTC'

PGPortfolio/pgportfolio/marketdata/coinlist.py

Line 35 in 48cc5a4

prices.append(1.0 / float(ticker[k]['last']))

[dekrypting-karma]

@tiassap did you solve the error?

[tiassap]

@dekrypting-karma

I could avoid KeyError: 'BTS_BTC' by replacing the for-loop inside CoinList.__init__() (inside coinlist.py) with this

for k in ticker.keys():
            if k.startswith("BTC_") or k.endswith("_BTC"):
                pairs.append(k)
                for c in k.split("_"):
                    if c != 'BTC':
                        if k.endswith('_BTC'):
                            coins.append('reversed_' + c)
                            prices.append(1.0 / float(ticker[k]['last']))
                        else:
                            coins.append(c)
                            prices.append(float(ticker[k]['last']))
                    else:
                        volumes.append(self.__get_total_volume(pair=k, global_end=end,
                                                               days=volume_average_days,
                                                               forward=volume_forward))

But there are still many errors will come out related to sql command line parsing and also error because in HistoryManager.get_global_panel() pandas Panel is used (deprecated since pandas version 0.20.0)

[dekrypting-karma]

@tiassap this helped in removing KeyError: 'BTS_BTC'. But I am also facing multiple errors in HistoryManager.get_global_panel().

Were you able to successfully run this project? If yes can you please share the code?
Any sort of help is appreciated.

[chenjjcccc]

@dekrypting-karma

I could avoid KeyError: 'BTS_BTC' by replacing the for-loop inside CoinList.__init__() (inside coinlist.py) with this

for k in ticker.keys():
            if k.startswith("BTC_") or k.endswith("_BTC"):
                pairs.append(k)
                for c in k.split("_"):
                    if c != 'BTC':
                        if k.endswith('_BTC'):
                            coins.append('reversed_' + c)
                            prices.append(1.0 / float(ticker[k]['last']))
                        else:
                            coins.append(c)
                            prices.append(float(ticker[k]['last']))
                    else:
                        volumes.append(self.__get_total_volume(pair=k, global_end=end,
                                                               days=volume_average_days,
                                                               forward=volume_forward))

But there are still many errors will come out related to sql command line parsing and also error because in HistoryManager.get_global_panel() pandas Panel is used (deprecated since pandas version 0.20.0)

did you solve the error?

[lucacarniato]

you could use xarray.DataArray

https://docs.xarray.dev/en/stable/generated/xarray.DataArray.html

[tiassap]

@dekrypting-karma , @lucacarniato

Sorry I was unable to response for a long time.
I created Docker container to make environment so we can use old pandas version and old tensorflow module here: https://github.com/tiassap/PGPortfolio

Seems like there is still problem with Binance API.. Please try it and help me make the code works again.