Can this be done

laptop1

Experienced member
Messages
1,105
Likes
131
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.
 
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.
 
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
 
laptop1 said:
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.
 
laptop1 said:
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.
 
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
 
laptop1 said:
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
 
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.
 
I do it for futures using Reuters composites and CQG (separately). Don't know about stocks though.,
 
erierambler said:
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
 
laptop1 said:
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
 
erierambler said:
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
 
laptop1 said:
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.
 
Top