265Views7Replies

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.

Discussions

0
None
artworker

Best Answer 5 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.

0
None
furbyartworker

Answer 5 years ago

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

0
None
artworkerfurby

Answer 5 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.

0
None
furbyartworker

Answer 5 years ago

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

0
None
furby

5 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.

0
None
artworkerfurby

Answer 5 years ago

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