Creating my own index

Discussion in 'Educational Resources' started by nitro, Dec 30, 2002.

  1. 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.

  2. 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.
  3. nitro



  4. dottom



    QCollector downloads data from 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
  5. Shankar


  6. dottom


  7. 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.
  8. Ninja


  9. HooLee


    Datek has a streamer that allows you creating your own index.
  10. nitro


    Thanks for all the useful replies. I will look into all of them.

    #10     Dec 30, 2002