Home > Forum Home > Excel Portfolio Optimization Template > Name conflict error Share

Name conflict error

Excel Help for Name Conflict Error in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Name Conflict Error

Rate this:
(4/5 from 3 votes)
Confused I have gotten this error:

" The name, vge5, either conflicts with a valid range reference or is invalid for Excel.  The name has been replaced with _vge5.
You may still need to manually update any references to this name used in VBA code or as tet arguments in fuctions.  You must close and repoen the workbook before these changes take effect."

Is there anything further I need to do other than re-opening it? 

thanks,

Michael
 Posted by on
 
Replies - Displaying 1 to 3 of 3Order Replies By: Most Recent | Chronological | Highest Rated
Oops
Rate this:
(3/5 from 2 votes)
You can try an re-open to re-run the optimization.  

If you do get a run-time error, please reply to the email on this post notification so that we can investigate.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Yes, I still get the same error.   I am running Excel 2013 in compatilibity Mode, I am also using Windows 10,  not sure these facts make a difference or not.  

I have two more additional questions regarding the program:
1. The total Return Comparision chart is very jagged when using a daily return data set, is this because the chart is plotted using monthly-calculated points? If so, is there a way to make it more smooth?
2. Output data is in the same time period as the input data set, as in, Avg Period Return for a daily data set is for one day, so to get an annual return, I will have to multiply it by 255?. What about the ratios and probabilities.  I assume the sharpe ratio stays the same, but what about "Probability of achieving ##% targert return", is this the probability in any given one-day for a daily data-set?

thanks, let me know if there is a document that I should be reading to answer these questions regarding funactionality.

Michael 
 Posted by on
Oops We can confirm that the name is not referenced in the VBA and so the results will not be affected. We have tested with Excel 2013 and Windows 10 and if the optimization runs without issue then the results are valid.

  1. The total return chart is created from the same dates used in the Input tab. Small periodicity such as days will make it more volatile and conversely higher periodicity such as months will smooth out volatility.
  2. All results are based on the input periodicity and so for daily data we need to multiple the return by trading days in the but for risk (standard deviation) the square root of annual trading days.
There is detailed documentation on these aspects in the user guides.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Name conflict error in the