Re: How to import account balance to an excel sheet

Quote from: HCP on April 18, 2018, 03:06:59 AM

You should look into "Power Query" (aka "Get & Transform" in Excel 2016): https://support.office.com/en-us/article/introduction-to-microsoft-power-query-for-excel-6e92e2f4-2079-4e1f-bad5-89f6269cd605

It allows you to get data from a number of sources including Web API's and pass in authentication information etc... You can extract as much or as little info from the returned data and do all sorts of transformations/extractions etc...

Im doing manually an earning tracker where i import my balance each 12 hours, would like to import directly data from my pool api
Im using open office calc
Hopefully my miner records a log file txt file so i just look into it and copy the balances reported. Then i can do graphs and statistics

Can I get this type of automatization on open office? Sounds interesting.

Anyone tried to import and keep updating BTC price from Localbitcoins? I fond the function to import data, but it import all whole list of sellers. Like a copy paste directly from page, I just only want to Get the First Sale Price.
About the Api on LBC, i dont get it how to use.