does this site show the whole life of a sets CAGR and monthly listing sold to date? It seems as it only shows about 1 year back.

The data goes back two+ years.  There is no data previously because the site was not developed yet.  The most important data is from MSRP, which we do have for every set.

how do we predict the CAGR on a set thats new to invest in say for 1-2 years down the road? im a little confused by this. lets say for 9474 its got a CAGR of -21 or 6869 with a -48.99. does that mean these set will not perform well or do we have to wait til EOL? 

Have a read of this:  http://community.brickpicker.com/blog/4/entry-15-cagr-compound-annual-growth-rate-and-lego/  it explains what CAGR is and how to calculate it.

 

The newer sets often have a negative CAGR because the CAGR is a measure of change between the recommended retail price and the current market price (which is based on Ebay sales).  Sets that are discounted at retail stores and then sold below retail on Ebay end up with a negative CAGR.  Generally the CAGR will improve once the set goes EOL.

In addition to Ed's article if you want to do it the other way around and estimate future values based on current CAGR, I wrote an article on the subject:

http://community.brickpicker.com/blog/20/entry-202-a-simple-method-to-calculate-set-value-using-its-cagr/

Have a read of this:  http://community.brickpicker.com/blog/4/entry-15-cagr-compound-annual-growth-rate-and-lego/  it explains what CAGR is and how to calculate it.

 

The newer sets often have a negative CAGR because the CAGR is a measure of change between the recommended retail price and the current market price (which is based on Ebay sales).  Sets that are discounted at retail stores and then sold below retail on Ebay end up with a negative CAGR.  Generally the CAGR will improve once the set goes EOL.

Grolim this is what i needed to hear. thanks and I did read both the articles you and brian pointed out many times =)