Bitcoin price data base
Budget: €250 – €750 EUR
Hello,
I want to develop a small project, something very simple and that is to connect 30 exchanges (using the coingecko.com API) to get every second the buy price and sell price of bitcoin, save those queries in a database and then be able to query the database for the following metrics and filters:
1- Being able to filter queries by date range.
2- To be able to filter the queries by % profit. (Price difference between the selling price and the buying price, Arbitrage).
The result of these two filters should show:
- Number of operations with the selected profit (filter 2).
- Indicate the number of times an exchange has been used to buy and to sell.
- Profit in % higher
The profit is calculated like this PriceSell/PriceBuy-100%.
Example:
PriceSellBTC: $55600.
PricePurchaseBT: 55300$.
Calculation: 55600/55300=100,54%.
For the API I suggest using: https://www.coingecko.com/es/api which already has 30 integrated exchanges.
The idea of all this is to know the price difference (Arbitrage) between the 30 exchanges and in each query select the exchange with the best price to sell (highest btc price) and the exchange with the best price to buy (lowest btc price). So the idea is to be able to select by a date range and know the metrics.
I don't need an exchange site, ...or exchange, or do anything by blockchain... I just need to get the Bitcoin price of the 30 exchanges and then create a script to select the best price to sell and the best price to buy. After selecting those prices, calculate the profit (the price difference between the two) and store that information in a database.
Attached is a diagram with the flow and the idea.
I look forward to your response.
I want to develop a small project, something very simple and that is to connect 30 exchanges (using the coingecko.com API) to get every second the buy price and sell price of bitcoin, save those queries in a database and then be able to query the database for the following metrics and filters:
1- Being able to filter queries by date range.
2- To be able to filter the queries by % profit. (Price difference between the selling price and the buying price, Arbitrage).
The result of these two filters should show:
- Number of operations with the selected profit (filter 2).
- Indicate the number of times an exchange has been used to buy and to sell.
- Profit in % higher
The profit is calculated like this PriceSell/PriceBuy-100%.
Example:
PriceSellBTC: $55600.
PricePurchaseBT: 55300$.
Calculation: 55600/55300=100,54%.
For the API I suggest using: https://www.coingecko.com/es/api which already has 30 integrated exchanges.
The idea of all this is to know the price difference (Arbitrage) between the 30 exchanges and in each query select the exchange with the best price to sell (highest btc price) and the exchange with the best price to buy (lowest btc price). So the idea is to be able to select by a date range and know the metrics.
I don't need an exchange site, ...or exchange, or do anything by blockchain... I just need to get the Bitcoin price of the 30 exchanges and then create a script to select the best price to sell and the best price to buy. After selecting those prices, calculate the profit (the price difference between the two) and store that information in a database.
Attached is a diagram with the flow and the idea.
I look forward to your response.