Constructing Excel Formulas

All reports are based on Excel functions, the sidebar is a facilitator for creating these functions, but it is also possible to generate them from scratch and select an existing 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 called.
2. Arguments: There are three arguments:
   • Selection: The filter that is going to be applied to the functions.
   • View: The list of fields that are going to be displayed.
   • Options: Options like "headless" (true/false), meaning if it is going to display the header in the answer or not.

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")