I am trying to sync the Ask/Bid prices of several cryptocurrency prices, along with their trading volumes, from different exchanges in real-time (Or at a maximum of every 2 minutes) into my Airtable via API or any possible alternate method.
I have attached a screenshot of how I would like my table to look like.
There will be a list of ~2000 cryptocurrencies that I need to be constantly updated. If the specific cryptocurrency is not traded on a specific exchange, it should leave the field empty.
I was able to get the job done via DataFetcher, but unfortunately, it is not a cost-efficient approach.
I am open to getting this done via Javascript scripting if possible.
I am looking for something cost-efficient in the long run that will not require hundreds of dollars every month.
If you can get this job done, please let me know.