Author

Topic: import api data in excel (Read 1059 times)

full member
Activity: 124
Merit: 100
April 28, 2013, 10:52:55 AM
#3
If you're working in Excel, my guess is that real time is out of the question, but instant snapshots isn't.

The question then is more about converting JSON to something like tab-delimited so that you can open it in Excel, then likely just run some macros/VBA.

I don't have an answer for you, but that might help someone else give you a better answer.
Exactly, snapshots. Thanks.

Are there any alternatives to excel spreadsheets?

How do you guys tame your risk curves when trading in realtime?
copper member
Activity: 1380
Merit: 504
THINK IT, BUILD IT, PLAY IT! --- XAYA
April 28, 2013, 09:49:15 AM
#2
If you're working in Excel, my guess is that real time is out of the question, but instant snapshots isn't.

The question then is more about converting JSON to something like tab-delimited so that you can open it in Excel, then likely just run some macros/VBA.

I don't have an answer for you, but that might help someone else give you a better answer.
full member
Activity: 124
Merit: 100
April 28, 2013, 07:06:11 AM
#1
I do my realtime trading calcs and risk profiles in spreadsheets.
I guess a vba script of some sort is required to do that.
Who's come across this issue? Any proper examples?
Or a webquery but honestly it looks weird to me..
or even maybe a dde linking, i used to use it
but i guess it's even weirder nowadays..
Jump to: