Author Options:

excel external data, new data - new line? Answered

i'm getting the ticker feed from (https://btc-e.com/api/2/btc_usd/ticker) and feeding it into an excel 2010 spreadsheet.
what i want to do is append the new data  (on update, 1 min interval) to a new line(row) on each update.



Best Answer 4 years ago

This might help!
No error handling done!
Use the "Start" and "Halt" macros to start and stop recording.
Can see the code also.
File is in xls format. If you want a 2010 format just open and save it as a xlsm (2010 macro format) format.

how would i alter your script to start back at the top after a set number of runs?

Just clean the entries in the "record" sheet. Or may be you can edit the code to reset the variable "rocount" to 1. The rocount stores the row number where the data will be stored next.

thanks. it works
now i just have to "explode" it out so i can work with the data


4 years ago

now the fun bit is getting the number values from

i can split in into it's individual components(ie. " "low":123.9, ") but cant split it further without using another formula in another cell.

Use '=MID(A1,FIND(":",A1)+1,FIND(",",A1)-FIND(":",A1)-1)'