**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

Page Symbol to track & post orders on Binance from Excel

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 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.

Excel Dashboard for Binance's wallets: Visualizing Your Assets in Your Currency from Excel

**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.