Bitcoin Forum

Economy => Service Discussion => Topic started by: jackg on April 08, 2019, 06:21:38 PM



Title: Need help converting bitcoin to my currency for data info
Post by: jackg on April 08, 2019, 06:21:38 PM
I want to file my tax return however the electrum servers are currently slammed so I'm not going to have any luck there.

Is there anywhere I can input my address into where it'll convert the btc values to British pound sterling at that specific point in time. I don't need it to be too accurate but the more accurate the better.


Title: Re: Need help converting bitcoin to my currency for data info
Post by: AdolfinWolf on April 08, 2019, 07:28:29 PM
Hmm. I know https://blockchair.com offers the USD value of each input, but i don't think you can change it to Pounds.

Blockchair.com shows historic amounts as well, so that's pretty nice when doing taxes.


Title: Re: Need help converting bitcoin to my currency for data info
Post by: jackg on April 08, 2019, 07:52:18 PM
@etf, could I get that to work in a spreadsheet?

And yeah @adolfin blockchain.com used to support a lot of currencies but doesn't anymore... Currencies fluctuated too much last year...


Title: Re: Need help converting bitcoin to my currency for data info
Post by: Joel_Jantsen on April 08, 2019, 10:25:01 PM
@etf, could I get that to work in a spreadsheet?
You certainly can! However, there is no straight forward way of doing it. That API returns a JSON string which can be converted to an excel using the documentation here https://support.office.com/en-ie/article/connect-to-a-json-file-f65207ab-d957-4bf0-bec3-a08bb53cd4c0 You're looking at converting a JSON string to the destination readable format. You can programmatically, do it with a few lines of code. I'm not sure how your excel stuff would work to give a specific suggestion.


Title: Re: Need help converting bitcoin to my currency for data info
Post by: jackg on April 19, 2019, 07:08:57 PM
I was using investing.com to pull these statistics all in one go as a download but it doesn't seem to have worked (according to them the bitcoin price fell to £1929 so I'm going to have to download from ex but it looks like it's much nicer than trying to do it with api calls).