I have an assortment of cryptocurrency transactions over time. Various currency pairs at various prices. I need to figure out what the price of those currencies was, in Bitcoin, at the time that I purchased them.
The manual solution is to look up a historical price chart of each pair (ETH/BTC, LTC/BTC, XRP/BTC, etc.) at the moment of purchase and record that. But needless to say, this is an extremely time consuming and tedious process.
I have the date & time of each purchase, along with the currency purchased and the amount, in a spreadsheet already. I would like to be able to fetch the final data I need from an API of some sort directly in my sheet.
I've gotten something similar using
but it only returns the value of BTC in USD. I need to get the value of other currencies in BTC.
I have made some dummy data available here.