Security date range

Excel Help for Security date range 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 TopicLogin
Security date range
Rate this:
(3/5 from 1 vote)
ShockedThe 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
[View the Full Thread for the "Enquiry on stocks added in after" Topic]

Find relevant Excel templates and add-ins for Security date range in the

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

       
  © 2013 Business Spreadsheets. All Rights Reserved. Legal |