Can this be done

[laptop1]

I would like know if there is a software out there or some charting firm, that can average price for me. I am looking to monitor 10 stocks and want to take the average price on the 10 stocks of my choice on an intraday basis. Simialr to how the Dow 30 works......but I want to place my own stocks to get the average.

Thanks.

 

[rharmelink]

If nothing else, you could do it yourself in EXCEL. It shouldn't be that hard. You just need a source to download the interday data from. After that, it's just a matter of setting up a few queries, one for each stock, then calculating the index.

I've done something similar myself, using daily data, in order to see how a portfolio of stocks would have performed.

 

[laptop1]

Hi rharmelink

The only trouble is, I want it live streaming, based on a 1min chart for trading intraday.I am sure there must me a software or charting package that could do this.

Cheers

 

[LION63]

I would like know if there is a software out there or some charting firm, that can average price for me. I am looking to monitor 10 stocks and want to take the average price on the 10 stocks of my choice on an intraday basis. Simialr to how the Dow 30 works......but I want to place my own stocks to get the average.

Thanks.

What exactly do you mean by this question? The DOW is an index that is calculated on a rebased basis and that is why a $1 movement in any of the constituents is the equivalent of 7 points. The FTSE 100 on the other hand is a weighted index.

 

[dcraig1]

I would like know if there is a software out there or some charting firm, that can average price for me. I am looking to monitor 10 stocks and want to take the average price on the 10 stocks of my choice on an intraday basis. Simialr to how the Dow 30 works......but I want to place my own stocks to get the average.

Thanks.

Basically, you want to create your own index. I think I read somewhere that WealthLab can do this. There will certainly be others.

 

[Trader333]

Excel can do this with streaming intra-day data using DDE because I have done it and it is quite easy to do. You just need to make sure you have a datafeed that supports DDE which IQ-Feed does.


Paul

 

[erierambler]

I would like know if there is a software out there or some charting firm, that can average price for me. I am looking to monitor 10 stocks and want to take the average price on the 10 stocks of my choice on an intraday basis. Simialr to how the Dow 30 works......but I want to place my own stocks to get the average.

Thanks.

Esignal can do this with their spread feature. It's simple. Just take the formula:
1 + 2 + 3, etc / 10 and it calculates everything for you. Intraday goes back 120 days, daily more.
I'm sure other software offers similar ways to do this.

erie

 

[henry766]

Not as common as one might think , last i heared tradestation doesn't offer composites and metastocks are limited to composites of 2 stocks close price only , I'd be interested to know if there is someone else who offers this.

 

[theEdge]

I do it for futures using Reuters composites and CQG (separately). Don't know about stocks though.,

 

[apfx]

Amibroker

 

[laptop1]

Esignal can do this with their spread feature. It's simple. Just take the formula:
1 + 2 + 3, etc / 10 and it calculates everything for you. Intraday goes back 120 days, daily more.
I'm sure other software offers similar ways to do this.

erie

Thanks guys for all you help/

erieramble

Is it real as easy as you say erie, im terable with tech lol.... I have Esignal just had a go,1 + 2 + 3, etc with a few stocks, but it come back with no data........I will have a look tomorrow if I can sort it out.



thanks again

 

[erierambler]

Thanks guys for all you help/

erieramble

Is it real as easy as you say erie, im terable with tech lol.... I have Esignal just had a go,1 + 2 + 3, etc with a few stocks, but it come back with no data........I will have a look tomorrow if I can sort it out.



thanks again

Yes it is that easy, only the 1 + 2 + etc was an example. To demonstrate exactly, one would take the stocks CAT + C + IBM + PFE + GM + GE / 10
One has to leave a barspace between the last letter of the stock and the plus sign. Likewise a barspace between the plus sign and the first letter of the next stock component. One has to also give the spread a name so that it remembers your variation. ( such as Trial 1, Trial 2 , etc.)
erie

 

[laptop1]

Yes it is that easy, only the 1 + 2 + etc was an example. To demonstrate exactly, one would take the stocks CAT + C + IBM + PFE + GM + GE / 10
One has to leave a barspace between the last letter of the stock and the plus sign. Likewise a barspace between the plus sign and the first letter of the next stock component. One has to also give the spread a name so that it remembers your variation. ( such as Trial 1, Trial 2 , etc.)
erie

Hi erie

Much appreciated, I will give it a go tomorrow.

cheers

 

[erierambler]

Hi erie

Much appreciated, I will give it a go tomorrow.

cheers

Your welcome, and since I slept on this I should mention that proper use of the formula would be to surround the added stock symbols with single quotes ( then divide by 10 ), such as:

( GM + GE + IBM + PFE ) / 10

Should you have any problems , the Esignal bulletin boards are very helpfull, just search the boards for spreads...........

erie

FWIW , for myself , I don't bother with the dividing , just add the symbols up. To each his own though.