Need historical intra day charting that dumps to excel

jim c · Nov 15, 2009

Im looking for historical intra day charting that eaisily coverts to excel. I need to be able to create custom indicators on the charts and then take those to excel. The major obstical is that I cant program at all. I need the charting to accept simple "if then" statements with out programming knowledge. In other words if(o>c,o-c,c-o) or something simple like like that.

Metastock does this but the only choice for intra day data is like 1300.00 bucks. Thomson one is what I use at work and it does this very nicely but it will only keep 30 days of 1 minute data. I dont really need tick data at this point. Ive used e-signal in the past but it requires programming. Any help would be appreciated. Jim

MakeMoney · Nov 17, 2009

There are various methods to access the functionality of Excel between platforms like IB's TWS as well as TradeStation's Platofrm. Both of these vendors have created DLL's which provide access to thir data and charting functions.

MakeMoney

eSignal Support · Nov 17, 2009

If programming was the main obstacle in choosing eSignal, you may want to consider looking at one of our EFS Consultants. They can scope the job after you describe what you're looking for and then provide a price quote.

Thanks.

jim c · Nov 17, 2009

Quote from MakeMoney:

There are various methods to access the functionality of Excel between platforms like IB's TWS as well as TradeStation's Platofrm. Both of these vendors have created DLL's which provide access to thir data and charting functions.

MakeMoney

Thx for your response. Tradestation requires programming. I need a front end that allows me to say.....(h-l) and then plot this as an indicator. Without any programming skills. Just to get this simple formula into tradestation or esignal how many lines of code would it take?

Im really wondering. I have no idea. With thomson or metastock its just as simple as.....add new indicator, type in (h-l) and it displays it on the screen.

Thx for the reply esignal rep. It took me two weeeks just to get signed up to your forum. I finally cancelled. Plus i dont want to have to use a programmer for something so simple. thx for all the responses. Jim

zgtrader · Nov 17, 2009

Quote from jim c:

Thx for your response. Tradestation requires programming. I need a front end that allows me to say.....(h-l) and then plot this as an indicator. Without any programming skills. Just to get this simple formula into tradestation or esignal how many lines of code would it take?

In TradeStation you would "insert indicator" to your chart (in this case "1 line custom") and insert the formula: High - Low

Simple.

jim c · Nov 17, 2009

Quote from zgtrader:

In TradeStation you would "insert indicator" to your chart (in this case "1 line custom") and insert the formula: High - Low

Simple.

Wow. Ive heard so much about easy language that i just assumed it would not do this. Just out of curiosity what about something like if(h-o>o-l,o-l,h-o). Is it just that same basic way? I would jump all over it if so. Plus I like the fact that its free with x # of trades. thanks alot! Jim

Edit. and I assume it will will convert the data to excel without too much trouble?

zgtrader · Nov 17, 2009

Quote from jim c:

Wow. Ive heard so much about easy language that i just assumed it would not do this. Just out of curiosity what about something like if(h-o>o-l,o-l,h-o). Is it just that same basic way? I would jump all over it if so. Plus I like the fact that its free with x # of trades. thanks alot! Jim

Edit. and I assume it will will convert the data to excel without too much trouble?

(1) Create a new indicator and enter the following code. (2) Insert the indicator on the chart.

if High - Open > Open - Low then
Plot1( Open - Low )
else
Plot1( High - Open ) ;

As for TS/Excel link, check out this ET thread. I have never personally needed to link TS to excel. http://www.elitetrader.com/vb/showthread.php?threadid=87512

jim c · Nov 17, 2009

Quote from zgtrader:

(1) Create a new indicator and enter the following code. (2) Insert the indicator on the chart.

if High - Open > Open - Low then
Plot1( Open - Low )
else
Plot1( High - Open ) ;

As for TS/Excel link, check out this ET thread. I have never personally needed to link TS to excel. http://www.elitetrader.com/vb/showthread.php?threadid=87512

Thanks alot for your help! I really just need to take OHLC data and any simple indicator I create and put that on an excel spreadsheet. Then that allows me to do my own simple testing. I can say if open is greater than 21 ma and we had three down days buy the fourth day just as an example. I mean i could almost copy and past the data..althought that would be a real pain. Im not really sure if I need it "linked" as i would be only testing historical data not real time. Thnaks again for your help. Jim