Home > Forum Home > Excel Portfolio Optimization Template > Enquiry on stocks added in after Share

Enquiry on stocks added in after

Excel Help for Enquiry On Stocks Added In After in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Enquiry On Stocks Added In After

Rate this:
(2/5 from 2 votes)
ConfusedHi there,

I have purchased the product and it is setting up the portfolio.  I am wondering, if I bought different stocks in different dates (Eg: I bought Stock A in Feb 01, 2012, and B in Mar 03, 2012, etc). and is planning to use "historical prices" for my input, what date should I begin with? The earliest date I bought my first stock? or?

Thanks, 
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Shocked
Rate this:
(4/5 from 2 votes)
The optimization is based on the the current postions of the portfolio. The date range should match for all stocks but is independent of when the securities were acquired. The aim of the optimization is to balance the weightings for the current positions based on the relationships between the securities over th past (regardless of when they were acquired).

In choosing the time range for the input, a balance is needed to to sought between recent market dymanics and length of observation period that encompasses the maximum fit of relationships that can be assumed to carry forward.  Typical applications include 1 year daily or 5 year monthly depending on trading frequency within the portfolio.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Enquiry on stocks added in after in the