Pages:
Actions
  • #1 by ryan on 16 Dec 2021
  • 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
  • #2 by ryan on 16 Dec 2021
  • #3 by MarkV on 16 Dec 2021
  • Hi
    Is it selection's volume percentage you are wanting i.e. selection variable "volume"?
    It is there in column A under selection name  
  • #4 by ryan on 16 Dec 2021
  • 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

  • #5 by MarkV on 16 Dec 2021
  • 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
Pages:
Actions