Run time error 9 - out of range

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

Run Time Error 9 - Out Of Range

Rate this: (4/5 from 2 votes)

	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 manucub on 11 Oct 2014

Replies - Displaying 1 to 4 of 4

Order Replies By: Most recent | Chronological | Highest Rated

	Run time error 9 - out of range 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 petergroft on 29 Dec 2022

	Excel 2013 issue with rolling backtest feature Rate this: (4/5 from 2 votes) 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 Excel Helper on 12 Oct 2014

	Backtestin periods and interval 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 manucub on 12 Oct 2014

	Backtesting periods and interval 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 Excel Helper on 11 Oct 2014

Displaying page 1 of 1