Need help converting bitcoin to my currency for data info

[jackg]

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.

[AdolfinWolf]

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.

[jackg]

@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...

[Joel_Jantsen]

@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.

[jackg]

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).