Home > Forum Home > Excel Portfolio Optimization Template > Data in Prices Check-Box > Zero values for prices Share

Zero values for prices

Excel Help for Zero Values For Prices in Excel Portfolio Optimization Template


Forum TopicLogin

Zero Values For Prices

Rate this:
(3/5 from 1 vote)
OopsThe program accepts zero or non numerical price data on the condition that there is at least one positive price observation for the asset. Blank and non numerical values (such as null) as transformed to zero. Theoretically, there should not be any non positive or non numerical price observations as the price should be replicated for subsequent observations. 

If the option is selected to process data as returns, then zero value observations are processed accordingly as zero returns for the periods in question.
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Zero values for prices in the