Author Topic: Excel Cells Created Using Import and Custom Cells  (Read 1713 times)

Tags:
  • All members
  • Posts: 60
Hi All

I have imported horse ratings into column N using the "Import Selection Cells" feature and that works fine. I have the horse rank (sel_order) in column M using custom cells feature (s13:1 = sel_order) and this also works fine. Now I just want to multiply the two numbers together for each horse to give my own value rating for each selection. I am trying to put the total for each horse in column N using custom cells feature. I define the cell address as s15:1 and the cell formula as =s13:1+s14:1. MF Pro (or Excel) won't let me do this and Excel freezes until I delete the Custom Cell.

Any ideas (a) what I'm doing something wrong or (b) a workaround?

Thanks.
Ed

  • Moderator
  • Posts: 3597
*
Re: Excel Cells Created Using Import and Custom Cells
« Reply #1 on: 05 Jul 2016, 19:32 »
Hi
Perhaps it may be better to do the total in Excel and not as custom cell:

If, as you say, your columns N and M data is working OK, then try this:
in cell reference O4 put the formula you want for row 4
then click the bottom right corner of cell O4 and drag it down column O
it should put the formula in all the rows in column O

see attached screenshot for a simple example, I used addition rather than multiplication.
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: 60
Re: Excel Cells Created Using Import and Custom Cells
« Reply #2 on: 06 Jul 2016, 07:30 »
Thanks, Mark, for taking the time to reply. Your suggestion would mean though that I would have to be in front of the screen for every race to manually do that and could not just set up my triggers for the day and leave for work.
Ed

  • Moderator
  • Posts: 3597
*
Re: Excel Cells Created Using Import and Custom Cells
« Reply #3 on: 06 Jul 2016, 09:52 »
Hi
Indeed  :)

Custom Cell S15:1 should be:
=SUM(M(sel_index*3+1):N(sel_index*3+1))
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: 60
Re: Excel Cells Created Using Import and Custom Cells
« Reply #4 on: 06 Jul 2016, 12:37 »
Excellent, Mark, you're a star! That works perfectly and I'll cut you in if - when - I win my first million. I can now design my triggers around this data. Thanks very much for taking the time to respond.
Ed

 

Please note, BetFair is seems to be currently OFFLINE