Author Topic: Help needed to convert Excel Formula for use in condition  (Read 1725 times)

Tags:
  • All members
  • Posts: 32
y = 1.2999e-0.055x is the formula for an exponential trendline in an Excel chart.
I want to use it in a condition where Y < 1.2999e-0.055x

The -0.055x is 'to the power of' but it disappears when posted


Please can someone show me how do I write it for MFP to interpret it correctly?

Thanks
Moose

  • All members
  • Posts: 53
I had a similar problem and unfortunately it looks like exponential functions are not implemented in MF Pro.

What I did was the following thing:

I plotted data points of the exponential function in OriginPro and found a best fit to the data set using a different power function that does not use e.

  • Moderator
  • Posts: 3597
*
Hi
if your MFP session is linked to an Excel spreadsheet where the functions are being calculated you can use the cell values in a trigger expression, for example:
selections trigger expression cell_Sheet1_A2 is less than cell_Sheet1_A1
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 32
Thanks Markv and LiAlH4.
I'll try your suggestions

Moose

 

Please note, BetFair is seems to be currently OFFLINE