250Views7Replies

Author Options:

excel external data, new data - new line? Answered

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.

7 Replies

user
artworkerBest Answer (author)2013-09-17

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.

Select as Best AnswerUndo Best Answer

user
furby (author)artworker2013-09-18

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

Select as Best AnswerUndo Best Answer

user
artworker (author)furby2013-09-18

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.

Select as Best AnswerUndo Best Answer

user
furby (author)artworker2013-09-17

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

Select as Best AnswerUndo Best Answer

user
furby (author)2013-09-18

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.

Select as Best AnswerUndo Best Answer

user
artworker (author)furby2013-09-18

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

Select as Best AnswerUndo Best Answer