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:

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

- My Product margins:

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

- My Product futures:

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

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

  ```excel
  =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):

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

- My product dividends:

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

Explanation on how to construct Excel formulas for Binance API functions

Constructing Excel Formulas

Welcome to the LinkyFlow installation documentation, your gateway to streamlined crypto management directly from Excel. LinkyFlow is a powerful tool designed to seamlessly integrate Binance transactions with the familiar interface of Excel, providing a personalized and efficient crypto management experience.

How to download and set-up LinkyFlow add-in

Installation

First things first, let's get LinkyFlow on board your Excel environment. Follow these steps:

#### **For Excel 2016, 2019, 2021, and Microsoft 365:**

1. Open Excel and navigate to the 'Insert' tab.
2. Click on 'Get Add-ins' or select 'Home' > 'Add-ins' > 'More Add-ins.'
3. In the Office Add-ins box, go to 'Store,' and use the search box to find LinkyFlow.
4. Click on the LinkyFlow add-in to read more about it.
5. Click 'Add' to install the add-in.
6. If prompted, sign in with your Microsoft account and follow the instructions to complete the installation.

#### **For Excel 2013:**

1. Open Excel and go to the 'Insert' tab.
2. Click on 'Apps for Office' or 'My Apps.'
3. In the 'Apps for Office' box, search for LinkyFlow.
4. Click on the LinkyFlow add-in and follow the prompts to install it.

Once installed, you'll find LinkyFlow in your add-ins list.

Download the add-in from excel to use it.

Download the LinkyFlow Add-in

## Create a Binance key

To create the key, a Binance article describes how to do it: [](https://www.binance.com/fr/support/faq/comment-cr%C3%A9er-des-cl%C3%A9s-api-sur-binance-360002502072)[https://www.binance.com/fr/support/faq/comment-créer-des-clés-api-sur-binance-360002502072](https://www.binance.com/fr/support/faq/comment-cr%C3%A9er-des-cl%C3%A9s-api-sur-binance-360002502072)

In summary, you need to log in to your account <https://www.binance.com/fr/my/settings/api-management>, then navigate to "Api Management".

![Binance menu with gestion api](https://res.cloudinary.com/dy07rxvhu/image/upload/v1687093007/public/blog/Comment%20afficher%20ses%20wallets%20transactions%20Binance%20directement%20depuis%20Excel/Untitled_3_hdv7dp.png)

Then "Create API" in the upper right corner.

![Bouton pour créer une api](https://res.cloudinary.com/dy07rxvhu/image/upload/v1687093017/public/blog/Comment%20afficher%20ses%20wallets%20transactions%20Binance%20directement%20depuis%20Excel/Untitled_4_ntgqzo.png)

We have 2 choices: system-generated or self-generated, the simplest is to take the system-generated one.

![2 choix : généré par systeme ou auto généré](https://res.cloudinary.com/dy07rxvhu/image/upload/v1687093021/public/blog/Comment%20afficher%20ses%20wallets%20transactions%20Binance%20directement%20depuis%20Excel/Untitled_5_evqd00.png)

We fill in the name and validate. Simple, isn't it?

The key is now created, with API Key and Secret Key. 2 important points:

* The secret key is your password, keep it aside and never share it with anyone
* Keep the API restrictions to "Allow Read". This limits access to read-only and **does not authorize operations on the account.** So no risk of unexpected transfers.

![Résultat de la génération de clé](https://res.cloudinary.com/dy07rxvhu/image/upload/v1687093028/public/blog/Comment%20afficher%20ses%20wallets%20transactions%20Binance%20directement%20depuis%20Excel/Untitled_6_v99btv.png)

Add the Binance key to access your wallets.

Set up your Binance api/secret key

S﻿o, you now have an api key that we can use, but let's dive a bit more on the differents possibilities

![List of api keys to check](https://res.cloudinary.com/dy07rxvhu/image/upload/v1706684763/public/docs/API_permissions_m4zp9t.png)



**API Restrictions:**

* ***Enable Reading:*** Allows the API key to access and read information from the associated account.
* *Enable Spot & Margin Trading:* Grants permission for spot and margin trading using the API key.
* *Enable Margin Loan, Repay & Transfer:* Permits the API key to initiate margin loans, repay them, and transfer funds related to margin trading.
* *Enable Futures:* Authorizes the API key to engage in futures trading.
* *Enable Internal Transfer:* Allows the API key to perform internal transfers within the associated account.
* *Permits Universal Transfer:* Provides the capability for universal transfers, likely across different types of assets or accounts.
* *Enable Withdrawals:* Grants the API key the ability to initiate withdrawals from the associated account.
* *Enable Symbol Whitelist:* Permits the API key to manage a whitelist of symbols, likely for specific trading pairs or assets.

**IP Access Restrictions:**

* *Unrestricted (Less Secure):* This setting allows the API key to be accessed from any IP address. It is considered less secure as it opens the possibility of unauthorized access.
* *Restrict access to trusted IPs only (Recommended):* The recommended setting restricts API key access to trusted IP addresses only, enhancing security by limiting access to specified, trusted locations.



F﻿or LinkyFlow, you need 

* **Enable Reading** to be able to access your own wallet 
* **Enable Spot & Margin Trading** to be able to create order from Excel

I﻿P Access restrictions won't work, because to be able to access Binance, LinkyFlow is going through an AWS server (located to Francfort). If you need a fixed IP, you can directly contact us.

I﻿t's totally OK to start with a Read Only api key, you will be able in the futur to create a new api key with Read & Write permission, then remove your read only api key and add your read & write key.

Focus on understanding the API permissions and what they mean

API permissions on Binance

With your credentials in place, it's time to build your personalized Excel page:

1. In Excel, go to the 'LinkyFlow' tab and select 'Page.'
2. Use the intuitive Page Builder interface to create tabs, drag-and-drop tables, and design your page layout.
3. Customize the view to display the specific Binance transactions and wallet information you want.
4. Save your page configuration for future use.

Set up a predefined page with standard reports for you, personnalize it afterward.

Build your page with the Page builder

**Introduction:** This Page integrates with Binance, providing real-time market data and trading functionality directly within Excel. Users can access various reports and execute trades effortlessly.

**Preview:**
![Page symbol ADAEUR](https://res.cloudinary.com/dy07rxvhu/image/upload/v1707802422/public/pages/home/Page_ADAEUR_qeasjf.png)
**Key Value Points:**

* Connects Excel to Binance.
* Provides real-time market data.
* Facilitates trading actions within Excel.
* Offers customizable reports and inputs.
* Simplifies trading analysis and execution.

**Binance Reports:**

* **Stock OHLC Data** (getUiklines): Fetches OHLC (Open, High, Low, Close) data from Binance for analysis.
* **Market Depth** (*getDepth*): Displays depth of market information, aiding in understanding market liquidity.
* **Ticker Statistics** (*getTicker24h*): Provides 24-hour ticker statistics for selected symbols.
* **Recent Trades** (*getTrades*): Shows recent trades executed on Binance.
* **Account Balances** (*myBalances*): Retrieves personal account balances from Binance.
* **Average Price** (*getAvgPrice*): Fetches the average price of a symbol over time.
* **Historical Trades** (*getTrades*): Retrieves historical trade data from Binance.

**User reports:**

* **Open Orders** (*myOpenOrders*): Displays personal open orders on Binance.
* **Trade History** (*myTrades*): Shows personal trade history, including executed trades.
* **Account Balances** (*myBalances*): Displays personal account balances on Binance.

**Inputs:**

* Allows users to input data such as buy/sell price and quantity directly into Excel.

**Actions:**

* Facilitates buy and sell actions directly from Excel, based on user-inputted parameters.

Select a symbol to track it, buy or sell against symbol with base and quote assets

Track 1 symbol

**\
Introduction:** This page provides a comprehensive view of one's portfolios, locked or flexible positions, and balances at a given time, all in their defined currency set in the settings section.

**Preview:**

![Snapshot of my positions in Binance](https://res.cloudinary.com/dy07rxvhu/image/upload/v1708087777/public/docs/page_snapshot_b1zbkn.png)

**Key Points:**

* Allows visualization of balances and positions in the user's currency.
* Provides an overview of available assets and their distribution.
* Facilitates understanding of locked and flexible positions.
* Offers dual visualization: via graph for quick distribution analysis, and via table for in-depth analysis.

**Binance Reports:**

* **Account Snapshot** (myAccountSnapshotSpot): Provides an overview of available assets in the user's currency.
* **Spot Balances** (myBalances): Presents current balances of different assets in the user's currency.
* **Locked Positions** (myLockedPositions): Gives an overview of locked positions in the user's currency.
* **Flexible Positions** (myFlexiblePosition): Displays flexible positions in the user's currency.

**Notes:**

* The "onlyPositive" and "onlyLast" filters are applied to focus primarily on current data.

Explore a comprehensive Excel dashboard for your Binance portfolios, providing real-time insights into your balances, positions, and asset distribution. Analyze locked and flexible positions easily with dual visualization options. Dive into Binance reports including Account Snapshot, Spot Balances, Locked Positions, and Flexible Positions. Discover the power of Excel for managing your Binance investments efficiently.

My crypto assets

**Introduction:** Explore your dividend earnings with this comprehensive dashboard, providing insights into dividend distributions by asset and product in your chosen currency.

**Preview:**

![Excel reports to visualize your dividends](https://res.cloudinary.com/dy07rxvhu/image/upload/v1708088806/public/docs/page_dividend_hlenpp.png)

**Key Points:**

* Gain insights into dividend earnings by asset and product.
* Visualize dividend distributions over time.
* Analyze dividend performance and trends.
* Access detailed reports for informed decision-making.

**Reports:**

* **Dividend by Asset:** Visualizes dividend earnings by asset in your chosen currency.
* **Dividend per Product:** Illustrates dividend distributions per product in your chosen currency.

**Data Source:**

* Utilizes Binance data to fetch dividend records.
* Filters applied for the last 180 days with a limit of 500 records.

**Note:**

* Stay informed about your dividend earnings to make informed investment decisions.

 Explore dividend earnings with this comprehensive Excel dashboard powered by Binance data. Gain insights into dividend distributions by asset and product in your selected currency. Visualize trends over time and analyze performance with detailed reports. Stay informed and make informed investment decisions with ease using this powerful dividend dashboard.

My dividends

**Introduction:** This page provides a unified dashboard to track multiple symbols and execute buy/sell orders directly from Excel. It integrates seamlessly with Binance, offering real-time data and trading functionalities.

**Preview:**

![Page multi symbols ADA, BTC, ETH, LUNA, MEME](https://res.cloudinary.com/dy07rxvhu/image/upload/v1719150006/public/docs/Capture_d_%C3%A9cran_2024-06-23_153848_j0vib5.png)

**Key Features:**
* Connects Excel to Binance.
* Provides real-time market data.
* Facilitates trading actions within Excel.
* Offers customizable reports and inputs.
* Simplifies trading analysis and execution.

**Binance Reports:**

* **Real-time Ticker Data** (*getTicker24h*): Fetches 24-hour ticker statistics for multiple symbols.
* **Buy Orders** (*LF.action.buy*): Facilitates placing buy orders for selected symbols.
* **Sell Orders** (*LF.action.sell*): Facilitates placing sell orders for selected symbols.
* **Account Balances** (*myBalances*): Displays positive balances from the user's Binance account.

**Inputs:**

* **Symbol List:** Auto-fills symbol data for quick analysis and trading.
* **Buy/Sell Price and Quantity:** Customizable inputs for trade execution.

**Actions:**

* **Exchange Info:** Displays the exchange alias for clarity.
* **Real-time Data Fetching:** Automatically updates ticker data for selected symbols.
* **Order Execution:** Facilitates placing buy and sell orders based on user inputs.
* **Balance Overview:** Provides a quick view of the user's positive balances.

**Notes:**

* Ensure the correct exchange alias is set for accurate data fetching.
* Use the auto-fill feature to quickly update and manage multiple symbols.

A comprehensive Excel page to track multiple symbols and execute buy/sell orders. Integrate with Binance for real-time data and trade execution.

Buy/sell multiple symbols

**Introduction:** This page provides a comprehensive dashboard to track and compare bid and ask prices for a single symbol across multiple providers directly from Excel. It integrates seamlessly with Binance and other providers, offering real-time data and comparisons.

**Preview:**

![Track Symbol Across Multiple Providers](https://res.cloudinary.com/dy07rxvhu/image/upload/v1719150917/public/docs/btcusdt_per_provider_po7dbb.png)

**Key Features:**

* Connects Excel to Binance and other providers.
* Provides real-time market data.
* Facilitates comparison of bid and ask prices across multiple providers.
* Offers customizable inputs and actions for data fetching.
* Simplifies market analysis and decision-making.

**Binance and Other Providers Reports:**

* **Real-time Order Book Data** (*getOrderBook*): Fetches order book data for selected symbol from multiple providers.
* **Price Comparison**: Calculates and compares the bid and ask prices across different providers.

**Inputs:**

* **Symbol Input:** Allows input of the symbol to track.
* **Provider List:** Auto-fills provider data for quick analysis and comparison.

**Actions:**

* **Fetch Order Book:** Retrieves order book data for the specified symbol and providers.
* **Compare Prices:** Automatically calculates the differences in bid and ask prices among providers.
* **Display Data:** Shows the minimum and maximum bid and ask prices for easy comparison.

**Notes:**

* Ensure the correct symbol is entered for accurate data fetching.
* Use the auto-fill feature to quickly update and compare multiple providers.

An Excel page to compare bid and ask prices of a single symbol across multiple providers. Integrate with Binance and other providers for real-time data comparison.

Symbol Multi-Provider

Functions

Dashboard

Sources

Import/connect data

Transactions

Wallets/Banks

Your wallets & banks

Return to homepage

Current lowest price at which a seller is willing to sell an asset

Total volume available at the lowest ask price

Bank Alias

Current highest price that a buyer is willing to pay for an asset

Total volume available at the highest bid price

Indicates whether the asset can be redeemed

The difference between the current price and the previous close price

Cumulative real-time rewards in my currency

The weighted average price of an asset across multiple major spot market exchanges, serving as a stable reference point for derivatives trading.

The percentage change between the current price and the previous close price

The closing price of the previous trading day

Indicates whether the trade was a taker (market order) or maker (limit order)

The annual percentage rate for a specific tier

The time interval for the data (e.g., 1m, 1h, 1d)

Order or trade type (e.g., limit, market)

Volume Weighted Average Price of an asset over a specified period

The percentage rate for airdrop rewards distributed yesterday

Retrieve open, high, low, close, and volume data

OHLCV Data

Order Book

Retrieve the 24-hour price ticker for a symbol

Ticker 24h

Trades

Retrieve a snapshot of my futures account

My Futures Account Snapshot

My Margin Account Snapshot

My Spot Account Snapshot

Retrieve my account asset dividend record

My Asset Dividend Record

Retrieve asset dividend records of my account

Asset Dividends

My Balances

My Deposit History

My Fiat Payments

My Fiat Transactions

My Flexible Position

My Flexible Positions

My Locked Positions

My Orders

Query sub-account transfer history (for main account)