Excel Universal DDE and floating point error in Multicharts

Questions about MultiCharts and user contributed studies.
reitberg
Posts: 77
Joined: 20 Mar 2006
Been thanked: 1 time

Excel Universal DDE and floating point error in Multicharts

Postby reitberg » 23 Apr 2006

I came accross an error if you are using a DDE server to your excel spreadsheets, which can cause MC to have a floating point error.

I have found a relatively simple fix, which can be done in EXCEL(not multicharts). You can try this in your cell for example:

=IF(ISNUMBER(L37),L37,0)

The ISNUMBER function will check to make sure that the cell contains a number.

You'll get a floating point error in MC if the cell is a word error, such as "NAME?"

User avatar
Alex Kramer
Posts: 834
Joined: 23 Feb 2006

Postby Alex Kramer » 24 Apr 2006

Thanks for the tip, it may be useful for someone, but it isn't in my opinion much related to MultiCharts data.
It's a generic data problem - if there's a word entry in a file containing quotes data, that file is pretty much broken, and this won't occur in something like a data stream from a data vendor.


Return to “MultiCharts”