Home > Forum Home > Excel Portfolio Optimization Template > Is there a minimum number of observations per candidate Share

Is there a minimum number of observations per candidate

Excel Help for Is There A Minimum Number Of Observations Per Candidate in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Is There A Minimum Number Of Observations Per Candidate

Rate this:
(3/5 from 1 vote)
ConfusedJust tried to use the opt. program.  The program came with 36 months pre-loaded into column "C".  When I load returns with fewer than 36 observations (and erase the months that  I do not use) I get a "Error 13".  Must there be a min. of 36 data for each candidate?  If not can anyone help as to why the program will not run?

Thanks
 Posted by on
 
Replies - Displaying 1 to 4 of 4Order Replies By: Most Recent | Chronological | Highest Rated
Oops
Rate this:
(3/5 from 1 vote)
The is no minimum number of observations per product for the portfolio optimization template.

The error could be due to there being:
  • An uneven number of observations per product.
  • blank cells within the obervation data.
  • non-numeric values within the observation data.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Hi,
Thanks for the response.  I opened the program and ran it with the data provided when the spreadsheet arrived.  The program ran correctly. I then erased  only the last line, ran the program again and received the same "Run time error 13" message.

Any help would be appreciated.


 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Please send your template through with the last line of data deleted to contact {at} business-spreadsheets.com and we will investigate this for you.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Thanks for the information even I am getting the same error13.Can anybody help us.Thanks in advance.



[url= http://www.1stclaims.co.UK/]personal injury compensation[/url]
 [url= http://www.1stclaims.co.UK/]personal injury compensation claim[/url]
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Is there a minimum number of observations per candidate in the