Idea is to get financial timeseries for multiple crypto currencies and calculate custom index for each symbol.
- BTCUSDT
- ETHUSDT
- BNBUSDT
- ETHBTC
- BNBETH
- BNBBTC
Looking to calculate Relative Strength Index for each pair and then use this formula for currency indexes:
| Currency | Calculation |
|---|---|
| BTC | (BTCUSDT + (100 - ETHBTC) + (100 - BNBBTC)) / 3 |
| ETH | (ETHUSDT + ETHBTC + (100 - BNBETH)) / 3 |
| BNB | (BNBUSDT + BNBETH + BNBBTC) / 3 |
| USDT | ((100 - BTCUSDT) + (100 - ETHUSDT) + (100 - BNBUSDT)) / 3 |
RSI is ranging from 0 to 100 so we are getting standartized indexes.
The same way we can calculate indexes for forex currencies
- Getting historical data from binance api
- Loading raw in bronze storage layer
- Adding schema and loading as silver layer
- Calculating indexes for symbols and load as gold layer
- Calculate correlations
- Visualize data
