search

diegomanuel / binance-to-google-sheets

Google Spreadsheets add-on to get data directly from Binance API without any intermediaries! :rocket:
GNU General Public License v3.0
423 stars 74 forks source link

[BUG] Not showing assets in "Earn" #79

Open RogerK888 opened 3 years ago

RogerK888 commented 3 years ago

When assets are staked or in "Earn" state, or Binance Vault, the asset is returned in a list with "LD" prefixing the asset ticker. When getting the price of the asset, it does not pull the current total asset value.

I'm guessing it's because it's in another area of the API?

It would be great to be able to display these as well, along as spot, cross margin, etc.

Also on this topic, it would be great if there was a function to display total asset value in BTC.

Thanks for a great bit of code.

Alexander-Shukaev commented 2 years ago

Second request is same as #98.

Alexander-Shukaev commented 2 years ago

It seems like "locked" value is also reported as 0 most of the time, so there is no way to determine true account balance reliably.

Alexander-Shukaev commented 2 years ago

It appears that "locked" actually refers to what is used for open orders rather than value locked in staking. In that case, "locked" value is correct. However, then there are no values reported for (locked) (DeFi) staking and dual investment, so once again, not possible to determine the true value of an account. Looks like Binance API does not support this yet: https://dev.binance.vision/t/earn-locked-staking/1453

darelover commented 2 years ago

Seems like Binace api has now added the support for Staking endpoints as of 28th April 2022: https://binance-docs.github.io/apidocs/spot/en/#staking-endpoints