Constructing Excel formulas

All reports are based on Excel functions. The sidebar helps you create them, but you can also build formulas manually and attach them to any Excel cell.

Each formula is constructed as follows:

1. Type (e.g., =LF.binance.getTicker24h) where binance is the provider and getTicker24h is the function.
2. Arguments: There are three arguments:
   • Selection: The filter to apply to the function.
   • View: The list of fields that will be displayed.
   • Options: Options like "headless" (true/false), meaning whether to display the header in the response.

Examples of function usage:

• My balances:

  =LF.all.myBalances("onlyPositive:true","bank_id,asset,free,used,total")
  

• My product margins:

  =LF.binance.myAccountSnapshotMargin("","asset,free,interest")
  

• My product futures:

  =LF.binance.myAccountSnapshotFutures("","asset,entryPrice,positionAmt")
  

• My assets bought with fiat (page 1, 10/page):

  =LF.binance.myFiatPayments("transactionType:0|rows:10|page:1","createTime,sourceAmount,fiatCurrency,price,obtainAmount,cryptoCurrency,totalFee")
  

• My asset sold to fiat (page 1, 10/page):

  =LF.binance.myFiatPayments("transactionType:1|rows:10|page:1","createTime,sourceAmount,fiatCurrency,price,obtainAmount,cryptoCurrency,totalFee")
  

• My product dividends:

  =LF.binance.myAssetDividendRecord("","divTime,asset,amount")