I am not a programmer, but I think the API is the only solution to my problem. Any hints, clues (or even offer to construct for $$$) would be appreciated.
I currently use an Excel macro to read rows of data from a text file into a spreadsheet. The macro parses the data by price, that is, it creates a volume profile. I do this at days end, manually.
I would like to create a program that would take T&S data from the Esignal API and feed it into my spreadsheet. Unfortunately, I track the ES, so by the end of the day, there are too many trades to fit into a single sheet. My guess is I need to write the data to a file which then can be read by the macro (not elegant and read/write conflicts) or figure out a way to pipe the data into the spreadsheet in some way I can't conceive of.
Any thoughts or ideas? I'm open to any suggestions.
I currently use an Excel macro to read rows of data from a text file into a spreadsheet. The macro parses the data by price, that is, it creates a volume profile. I do this at days end, manually.
I would like to create a program that would take T&S data from the Esignal API and feed it into my spreadsheet. Unfortunately, I track the ES, so by the end of the day, there are too many trades to fit into a single sheet. My guess is I need to write the data to a file which then can be read by the macro (not elegant and read/write conflicts) or figure out a way to pipe the data into the spreadsheet in some way I can't conceive of.
Any thoughts or ideas? I'm open to any suggestions.
Comment