Enquiry on stocks added in after

Excel Help for Enquiry on stocks added in after in Excel Portfolio Optimization Template

Find Excel Solutions


Search the Forums:
Recent Activity:
Delete Cell Items In Spreadsheet
Importing Data From Pdf Files
New Portfolio Optimization Template Version
Financial Market Data Feed
Run Time Error 1004
Data Downloader Crashes Excel




Follow Business Spreadsheets On:
 
Forum TopicReply Login
Enquiry on stocks added in after
Rate this:
(3/5 from 1 vote)
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:
(3/5 from 1 vote)
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

 
Find Excel templates
and add-ins in the
Excel Business Solutions Directory

       
  © 2013 Business Spreadsheets. All Rights Reserved. Legal | About Us