Creating my own index

nitro

nitro

I am interested in creating my "own" DOW 30 index with stocks that are different than the ones that are in the DOW now.

Does there exist a website that will allow me to create and keep track of this, in a somewhat realtime fashion (updating the "index" every minute or so is fine?) Also, an arithmetic weighted index to start out is OK, but it would be nice if I can define the different ways to calculate the index.

I know I can do it in WL and TS6, but I do not currently own WL, and it is a pain in the ass to do this in TS6.

nitro
 
It's kind of a pain, but you could always use Excel and something like QCollector to auto update the Excel at whatever time interval you require.
 
Quote from dottom:

It's kind of a pain, but you could always use Excel and something like QCollector to auto update the Excel at whatever time interval you require.
More...
QCollector?

nitro
 
Quote from nitro:


QCollector?
More...
Yeah, http://www.mechtrading.com/.

QCollector downloads data from quote.com or eSignal and stores them in CSV files. It can also update any Excel sheet in real-time.

For example, I have a NN application that currently is only coded in Excel and haven't had time to convert it to a Wealth-Lab COM module yet, so I just run QCollector to update the spreadsheet and grab the value directly from the spreadsheet.

QCollector also supports some other data formats, and is customizable via it's SDK http://www.mechtrading.com/developers/index.htm
 
I did it once by just using an online portfolio. I used the closing price for dec 31 as my purchase price, then split up an imaginary 100k portfolio into the various stocks.

So everyday it would give me the ytd percentage change and the daily change.
 
You must log in or register to reply here.
Back
Top