Excel 1 second data feed

Well, I am not having any trouble building the custom indicator, I've been able to set up the alarm, and have excel set up to place trades automatically when certain conditions are met.

I have not been able to figure out how to get the data into excel without using Qlink which only offers the options of 1 minute data.

What kind of code would I have to write to call for the data in x number of seconds instead of every minute as I do now???

Quote from EdgeHunter:

eSignals DDE is fine up to about 100 symbols or so... and in any version of Excel you can then build any Custom Indicator and then test its formula value every X number of seconds you want and set off an alarm if it hits your threshold...

your alarm can be any sound (.wav ) file you choose...

Buy XYZ at market... or Sell ABC at the Bid... or pair something... anything is possible if you have worked out your edge...
More...
 
Quote from bellman:

Well, I am not having any trouble building the custom indicator, I've been able to set up the alarm, and have excel set up to place trades automatically when certain conditions are met.

I have not been able to figure out how to get the data into excel without using Qlink which only offers the options of 1 minute data.

What kind of code would I have to write to call for the data in x number of seconds instead of every minute as I do now???
More...

i think you need to ask that question on the eSignal forum for Qlink programming...
 
I did. Oh well, I'll get it done eventually.

Quote from EdgeHunter:

i think you need to ask that question on the eSignal forum for Qlink programming...
More...
 
Quote from bellman:

Well, I am not having any trouble building the custom indicator, I've been able to set up the alarm, and have excel set up to place trades automatically when certain conditions are met.

I have not been able to figure out how to get the data into excel without using Qlink which only offers the options of 1 minute data.

What kind of code would I have to write to call for the data in x number of seconds instead of every minute as I do now???
More...

Should be in milliseconds...just change that value. At least that is how it is in java, should transfer over to vba.
 
Qlink does feed tick data which updates on the order of milliseconds... There isn't an easy way to update all of the trades every 1 second or every 5 seconds.

Processing and memory dictates that I update every few seconds when analyzing hundreds of stocks.

Quote from jmn319:

Should be in milliseconds...just change that value. At least that is how it is in java, should transfer over to vba.
More...
 
As a (soon-to-be) former bank-trader all my prop-models is built in excel using the Bloomberg API.

I'm setting up our family office and would like to continue using these prop-models but I would prefer a cheaper alternative to Bloomberg.

Any suggestions? I would need the application to source 15-min, 2-h and daily fx data into excel.

Appreciate your inputs.
 
You must log in or register to reply here.
Back
Top