Home > Forum Home > Analyzing Corporate Financial Data > Run Time Error13:Type Mismatch Share

Run Time Error13:Type Mismatch

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


Forum TopicPost Reply Login

Run Time Error13:type Mismatch

Rate this:
(2.5/5 from 2 votes)
OopsHi 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 on
 
Replies - Displaying 1 to 5 of 5Order Replies By: Most Recent | Chronological | Highest Rated
Oops
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 on
Confused
Rate this:
(3/5 from 3 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 on
Grateful
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 on
Oops
Rate this:
(3.5/5 from 2 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 on
Confused
Rate this:
(3.5/5 from 2 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 on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Run Time Error13:Type Mismatch in the