Need help converting bitcoin to my currency for data info

ABCbits

legendary

Activity: 2870

Merit: 7490

Crypto Swap Exchange

Quote from: jackg on April 08, 2019, 02:52:18 PM

@etf, could I get that to work in a spreadsheet?

Depending on spreadsheet software you use. On Microsoft Excel it's possible but complicated since you need to send and receive GET request.

But if you use LibreOffice Calc, it should be easier since it uses Python for it's micro. Check https://ask.libreoffice.org/en/question/68881/import-from-rest-api-to-calc

jackg

copper member

Activity: 2856

Merit: 3071

https://bit.ly/387FXHi lightning theory

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

Joel_Jantsen

legendary

Activity: 1988

Merit: 1317

Get your game girl

Quote from: jackg on April 08, 2019, 02:52:18 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.

jackg

copper member

Activity: 2856

Merit: 3071

https://bit.ly/387FXHi lightning theory

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

AdolfinWolf

legendary

Activity: 1946

Merit: 1427

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

copper member

Activity: 2856

Merit: 3071

https://bit.ly/387FXHi lightning theory

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.

Topic: Need help converting bitcoin to my currency for data info (Read 171 times)