Home > Forum Home > Excel Portfolio Optimization Template > Run time error 9 - out of range Share

Run time error 9 - out of range

Excel Help for Run Time Error 9 - Out Of Range in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Run Time Error 9 - Out Of Range

Rate this:
(4/5 from 2 votes)
Angry I have a trial version of porfolio optimization. I getting a run time error 9- Out of range, when I run rolling backtest. I am using excel 2013. Can you help me with this issue?
 Posted by on
 
Replies - Displaying 1 to 4 of 4Order Replies By: Most Recent | Chronological | Highest Rated
Oops
Rate this:
(4/5 from 2 votes)
The error is likley to be due to the settings for the period interval and time observation data. If you attach you template to a reply of this post email notification, we can look into the issue.
 Excel Business Forums Administrator
 Posted by on
Happy
Rate this:
(2/5 from 2 votes)
This is my template. For rolling backtest i use the following parametres:Back period for each optimization:52 (52 weeks - 1 year)   Period gap between each optimization: 4 (4 weeks-1 Month) Thank you very much for your help  I don't know how can I attach a template. Could you tell me how can I do?  
 Posted by on
Shocked On investigation, we found an issue with the rolling backtesting feature in Excel 2013.  It has now been fixed and compatible with all other versions of Excel in the download version. 
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(4/5 from 2 votes)
Occasionally, when you try to run a macro, an error message will appear, such as the "Run-Time Error '9': Subscript Out of Range" error shown below. On this error message, there are 3 buttons available -- End, Debug and Help. To stop the macro, click the End button. To get information about the error, click Help.

Greetings,
Peter
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Run time error 9 - out of range in the