Home
Help
Calendar
Login
Register
Our partners:
BetFair APIs status:
BetFair Software Community
/
MarketFeeder Pro
/
Troubleshooting
(Moderators:
MarkV
,
mcbee
)
/
Help needed to convert Excel Formula for use in condition
ID:
12478
, Pages:
1
Go Down
Author
Topic: Help needed to convert Excel Formula for use in condition (Read 219 times)
moose
All members
Posts: 31
Karma: +0/-0
Help needed to convert Excel Formula for use in condition
«
on:
Mon, 16 April, 2018, 12:13 »
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
Logged
faint heart never hog-tied a buffalo... Dim hog-tied As whatever you want
Eight years into a lifetime subscription and still a newcomer ... It's like Devon all over again
LiAlH4
All members
Posts: 25
Karma: +0/-0
Re: Help needed to convert Excel Formula for use in condition
«
Reply #1 on:
Tue, 17 April, 2018, 00:05 »
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
.
Logged
MarkV
Moderator
Posts: 2787
Karma: +229/-0
Re: Help needed to convert Excel Formula for use in condition
«
Reply #2 on:
Tue, 17 April, 2018, 05:49 »
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
Logged
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.
moose
All members
Posts: 31
Karma: +0/-0
Re: Help needed to convert Excel Formula for use in condition
«
Reply #3 on:
Tue, 17 April, 2018, 10:06 »
Thanks Markv and LiAlH4.
I'll try your suggestions
Moose
Logged
faint heart never hog-tied a buffalo... Dim hog-tied As whatever you want
Eight years into a lifetime subscription and still a newcomer ... It's like Devon all over again
Pages:
1
Go Up
BetFair Software Community
/
MarketFeeder Pro
/
Troubleshooting
(Moderators:
MarkV
,
mcbee
)
/
Help needed to convert Excel Formula for use in condition