- Platforms
- TradeStation
- Linking bank account is required.
- Sierra Chart – High Performance Trading Platform
- MetaTrader4
- the most popular Forex trading platform
- MetaTrader5
- A powerful platform for Forex and Exchange markets
- TradeStation
Export Stocks data to Excel
- Open demo account at hotforex.com
- Download hotforex’s Meta Trader 5 and install.
- Login to Meta Trader
- Add the required symbol
- How to export data from Metatrader 5
- Export to HTML
- Copy and paste HTML content to Excel.
- Youtube Videos
- Meta Trader
- Meta Trader programming for beginners (Videos)
- How to export data from Metatrader 5
- Note:
- You can export to CSV or HTML.
- To reflect the data in Excel, do the following steps:
- Export to HTML
- Open in Browser
- Copy and paste all to excel.
- Note:
- Where to open account MT5 Demo account
Getting balance from Binance
- Binance
- Create account
- Get API keys.
- Install mini conda
- Create environment
- Install there
- aiohttp
- ccxt – crypto
- Suppose to have visual c++ build tools
- cl.exe-find it and add it to path.
- pandas
- numpy
- requests
- Run the following code:
import ccxt# Initialize the exchange
exchange = ccxt.binance({
‘apiKey’: ‘5kRM6Qm80hlWGxAEwmBwdSrB0XkPLkd79PWdXyWRRf1DhbebSK1jsMGBVdaB7oVs’,
‘secret’: ‘hVpFqyka2ZAjcERaRheWjIs18hbOQI6tFTxTw8hLY1OSRUpL2yzSRawov5SCfAA0’,
‘enableRateLimit’: True,
})
# Fetch the balance
balance = exchange.fetch_balance()
# Extract and display non-zero balances
non_zero_balances = {symbol: amount for symbol, amount in balance[‘total’].items() if amount > 0}
# Display non-zero balances in a table format
print(“Spot Account – Non-Zero Balances:”)print(“{:<10} {:<20}”.format(“Asset”, “Balance”))
for symbol, amount in non_zero_balances.items():
print(“{:<10} {:<20}”.format(symbol, amount))