Strange behavior

[serge mathieu]

To further help improving Excel Price Feed, here is what happened here.

Our financial algorithm on Excel detects when a stock should be sold, and Excel sends a SMS with a message like "Sell 242 AAPL". 

Since we installed Excel Price Feed, problems appeared, the macro went dysfunctional, a type mismatch was detected on a boolean variable. We unisntalled the Excel Price Feed add-in, and everything returned normal.

I asked an advice on Claude.ai, her is the answer: 

(ME:) For your information: I uninstalled the Excel Price Feed add-in, and everything went back to normal.

(Claude.ai:)   Thank you for this very helpful information! It does make sense that the "Excel Price Feed" add-in caused the "Type mismatch" error.

Financial data add-ins can sometimes:

• Modify cell behavior

• Interfere with data types

• Create conflicts with boolean values

• Alter formula interpretation

This is a good example of why it's important to test code in a "clean" environment when unexpected errors occur.

Is your macro now working correctly with the TRUE/FALSE values?

This experience could be helpful for other users who may encounter similar issues with third-party add-ins.

(Me:) Yes, my macro now works normally.