excel external data, new data - new line?

hi,
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.

sort by: active | newest | oldest
artworker3 years ago
This might help!
Link
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.
furby (author)  artworker3 years ago
how would i alter your script to start back at the top after a set number of runs?
artworker furby3 years ago
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.
furby (author)  artworker3 years ago
thanks. it works
now i just have to "explode" it out so i can work with the data
artworker furby3 years ago
Enjoy!
furby (author) 3 years ago
now the fun bit is getting the number values from
{"ticker":{"high":125.39,"low":123.9,"avg":124.645,"vol":399067.58567,"vol_cur":3201.66302,"last":125.32,"buy":125.32,"sell":125,"updated":1379492217,"server_time":1379492218}}

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.
artworker furby3 years ago
Use '=MID(A1,FIND(":",A1)+1,FIND(",",A1)-FIND(":",A1)-1)'