Run Time Error13:Type Mismatch

Excel Help for Run Time Error13:type Mismatch in Analyzing Corporate Financial Data

Run Time Error13:type Mismatch

Rate this: (2.5/5 from 2 votes)

	Hi I am having trouble with return data, when I run the optimization process with my return data I am getting strange outputs. This does not seem to be a problem with price data. Please help
	Posted by lush on 03 Nov 2015

Replies - Displaying 1 to 6 of 6

Order Replies By: Most Recent | Chronological | Highest Rated

	Data format for returns Rate this: (3/5 from 2 votes) Non-numerical data may cause this error so make sure all input data is format as numbers. If you still have issues, you can send through your template as a reply to this post notification email so that we can investigate the cause.
	Excel Business Forums Administrator
	Posted by Excel Helper on 03 Nov 2015

	Follow Up Rate this: (2.8/5 from 4 votes) Hi  It seems that in the "tech" sheet you need price data to do the analysis ? Could this be a reason for error?  To move forward with my work, if I was to use the price data instead of returns citrus parabis my results should be the same ?
	Posted by lush on 03 Nov 2015

	Prices versus returns Rate this: (3.5/5 from 2 votes) The technical indicators should convert to indices if returns are specified in the input tab. If returns are used, then the flag at the top of the Input tab should be set so that the system knows what to do with the data. If this is the case, then please send through your data so that we can investigate.  All data remains strictly confidential.
	Excel Business Forums Administrator
	Posted by Excel Helper on 03 Nov 2015

	Insert Spreadsheet Rate this: (3.3/5 from 3 votes) Hi I have multiple issues that I need help with. Is there any direct email for me to sent my queries to as a client? Having to insert 7 rows and columns at a time will be a huge waste of time and not helpful. My maximum sharpe ratio is negative which is a concern and clearly wrong
	Posted by lush on 03 Nov 2015

	Email address Rate this: (3/5 from 3 votes) When you get a notification email for posts here, you can use that address to communicate with us and send data. We don't post the address here as it can be scraped for misuse. If you don't get the notification email, you can use the Send Feedback form in the Support menu above.
	Excel Business Forums Administrator
	Posted by Excel Helper on 03 Nov 2015

Run time Error 13 Rate this: (3/5 from 1 vote) Uninstall The ProgramIt is found some application and software causes the runtime error. So, to fix the Excel file error, simply uninstall the problematic apps and programs. First, go to the Task Manager and stop the running programs.Then in the start menu > select Control Panel.In the Control Panel > choose Add or Remove Program. Here, you will get the list of installed programs on your PC. Then from the list select Microsoft Work.Click on uninstall to remove it from the PC. Hope doing this will fix the Excel file Runtime error 13, but if not then follow the third solution. J Wick

Posted by Jimmywick on 08 Jul 2022

Displaying page 1 of 1