New sim server released

Dear All,

We have released a new sim server that has a new architecture to run sims much faster. This will enable us to do many things in the future, like daily ranking.

It also has a fix in the Rank->Performance tool. The Rank performance was using Friday’s close for the bucket’s performance calculations.This could introduce look-ahead biases. The new version uses Monday’s close. The rank performance runs do vary slightly in my tests, but it depends also on the factor nodes that you use (more short term price action nodes would have more impact)

Let us know of any issues.

Thanks

Marco

This is much appreciated and significant improvement, thanks Marco…great work.

I was pounding my head trying to figure out what error I had made to make one of my favorite weekly ranking systems performance decline from just a few days ago. I’m glad I saw this.

It’s always better to get more accurate data, even if stats are lower. Thnx.

Looks like things are running twice as fast. This are very, very preliminary results:

Average seconds per sim: 10s (~5000 samples)

Previously, average seconds per sim: 22s (~18000 samples)

I feel it will be much more noticeable in outlier sims that used to take minutes to run. THere are are also still a few more tweaks we can do.

Marco:

Why is Monday's close better?  I don't see the logic.  What I do see is significant performance differences in some of my ranking systems (~ 10% annually).

Bill

Thanks marco. I don’t see any significant difference in my sims and nothing that can’t be explained by chance or over-optimization.

Marco:

  What might make sense is to use Monday's open instead of Friday's close. But then we would need actual open prices for the entire data base (the early open prices are fictional). 

  In the absence of actual open prices I think it makes sense to approximate them by the nearest time-price opportunity.  That would be Friday's close.

  Please return the ranking system performance statistics to Friday's close until actual open prices are available, at which point switching to Monday's open makes sense.

 Bill

We are going to add a dorpdown where you can choose the price. We won’t make friday’s open available because we’re also going to improve the open-price estimate prior to 2004 (the year they became available)

The current open price is filled in with (hi+lo)/2, but a better guess would be:

if prev-close between hi & lo
{
  open = prev-close 
}
otherwise (there was a gap)
{
  if (prev-close) > hi  // gap down
  {
    if close > (hi+lo)/2
    {
      // closed closer to hi price
      // most likely a late rally 
      // after gapping down
      open = low
    }
    otherwise
    {
      // gapped down and kept 
      // going lower
      open = hi
    }
  }
  otherwise // gap up
  {
    if close > (hi+lo)/2
    {
      // closed closer to hi price
      // most likely continued to rally 
      // after gapping up
      open = lo
    }
    otherwise
    {
      // lost steam after gapping up
      open = hi
    }
  }
}

Please note that guessing the open price when missing is needed even if we find a way to backfill the Compustat database with open prices from InteractiveData.

Marco:

A dropdown menu with Friday's close would be sufficient for me, until we get a full set of Monday's open's.    Thanks.

Bill