Tired of using generic crypto portfolio apps that charge you $15/month for a "premium" layout? If you want absolute control over your data, it's time to build your own centralized management system.
Today, we are combining the layout power of Notion with the data power of the Binance API. We are going to write a Python script that automatically fetches your real-time balances and prepares them to be synced directly into a custom Notion database.
No more manual data entry. Total automation.
Step 1: The Setup
You will need two things:
1. Your Binance API keys (Read-only permissions!).
2. A Notion account with a blank Database created.
Note: For the full integration, you would also create a Notion Integration API key, but today we are building the Binance data extraction engine.
Step 2: Extracting Clean Portfolio Data
When you pull your balance from Binance, it gives you a massive list of every coin on the exchange, including tiny dust amounts. We need to write a script that filters this data so we only send our actual holdings to Notion.
Make sure you have the ccxt library installed (pip install ccxt).
import ccxt
# 1. Connect to your Binance account
# SECURITY REMINDER: Never share these keys.
binance = ccxt.binance({
'apiKey': 'YOUR_API_KEY_HERE',
'secret': 'YOUR_API_SECRET_HERE',
'enableRateLimit': True,
})
try:
# 2. Fetch the raw balance data
raw_balance = binance.fetch_balance()
# 3. Create a clean dictionary for our Notion database
clean_portfolio = {}
# 4. Filter out empty balances and "dust"
for coin, amount in raw_balance['total'].items():
if amount > 0.001: # Adjust this threshold to hide dust
# Here we fetch the current USDT price for the coin
try:
ticker = binance.fetch_ticker(f"{coin}/USDT")
current_price = ticker['last']
usd_value = amount * current_price
# Only save coins worth more than $1 to our dashboard
if usd_value > 1.0:
clean_portfolio[coin] = {
'amount': round(amount, 4),
'usd_value': round(usd_value, 2)
}
except:
pass # Skip coins that don't have a direct USDT pair
print("✅ Data extracted and cleaned. Ready for Notion Sync:")
for coin, data in clean_portfolio.items():
print(f"{coin}: {data['amount']} coins | Value: ${data['usd_value']}")
except Exception as e:
print(f"Error: {e}")
Step 3: Why This System Wins
Once this data is extracted, the next step is using the requests library to POST this directly to your Notion Database URL.
Why build this?
• Privacy: Your portfolio data stays between you, Binance, and your private Notion workspace. No third-party tracking apps.
• Customization: In Notion, you can build custom formulas around this data—calculate taxes, set visual goals, or track your portfolio against your real-life expenses.
Do you want Part 2, where we write the exact API code to push this data into the Notion tables? Drop a "+" in the comments if I should drop the rest of the code! 👇
#Notion #BinanceAPI #PortfolioTracker #PythonTrading #TechInCrypto