Title: Adding Bitcoinaverage API to openoffice or libreoffice calc Post by: designbuyers on April 16, 2015, 10:04:30 PM Are you successfully added
Code: https://api.bitcoinaverage.com/ticker/global/USD/last To openoffice or libreoffice calc ( Excel ) as I can't add it, please help if you able to add it please share how you did. simply I try with : Quote Menu/Insert/Link to external data. but after it show me i check it and OK dose not appear at all.Please, share the file if you able to do this, and I do not know how to edit the seconds when I am adding a link. Title: Re: Adding Bitcoinaverage API to openoffice or libreoffice calc Post by: shorena on April 16, 2015, 10:28:59 PM OpenOffice:
Insert -> Sheet from file -> enter URL as filename -> click open It will show the text import screen, click ok and check the link checkbox. It will ask to update them when you open the file. -> https://www.fuzzwork.co.uk/2013/06/22/importing-price-data-into-spreadsheets/ Title: Re: Adding Bitcoinaverage API to openoffice or libreoffice calc Post by: designbuyers on April 16, 2015, 10:59:00 PM OpenOffice: Insert -> Sheet from file -> enter URL as filename -> click open It will show the text import screen, click ok and check the link checkbox. It will ask to update them when you open the file. -> https://www.fuzzwork.co.uk/2013/06/22/importing-price-data-into-spreadsheets/ Yes, this way is work, but it dose not update automatic, i have to update it manually. |