Author Topic: Custom Cells and formula to show Volume  (Read 3121 times)

Tags:
  • All members
  • Posts: 10
Custom Cells and formula to show Volume
« on: 16 Dec 2021, 05:16 »
Hi. Thanks in advance for your help.

I'm using the standard Excel interface in Section 11, and was wondering if it was possible to get Selection Volume.

I can get it in the app by putting up a chart, but is it possible to have them all export as custom cells?

I saw an example on 
https://marketfeeder.co.uk/learn/triggers/labouchere/

but didn't understand how I can make it loop through the whole market and place it the same row (ie column M) or one of the always zero/reserved for future use cells.

Thanks again

  • All members
  • Posts: 10
Re: Custom Cells and formula to show Volume
« Reply #1 on: 16 Dec 2021, 05:18 »

  • All members
  • Posts: 3654
Re: Custom Cells and formula to show Volume
« Reply #2 on: 16 Dec 2021, 18:06 »
Hi
Is it selection's volume percentage you are wanting i.e. selection variable "volume"?
It is there in column A under selection name  
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: 10
Re: Custom Cells and formula to show Volume
« Reply #3 on: 16 Dec 2021, 18:12 »
Hi it's volume, but thanks for that I just realised you also gave me the answer lol. 

M4 =$E$3*(A5/100)
M7 =$E$3*(A8/100)
etc


  • All members
  • Posts: 3654
Re: Custom Cells and formula to show Volume
« Reply #4 on: 16 Dec 2021, 18:30 »
ok, but you only need one custom cell address:

each selection is displayed in 3 rows, so row = 1 to 3

syntax for custom cell address: S[column]:[row]  

e.g.
address: S13:2
Value: market_volume*(volume/100)

will put your formula in 2nd row of each selection in column M
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.

 

Please note, BetFair is seems to be currently OFFLINE