You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Help coding for 10 different X Axis

I have a table, “control 1,” for the manual input of mid asset prices for the x axis, eg 12600 for the £/$. 


In another table called "Legs 1-10 P/L,” I have 10 columns of x axis data (10 columns with 100 rows above and 100 below the mid price in increments of +/-25), located in columns L2 to U2, that is sourced from the real data in columns A to J).


The offset code for the first Leg in Col L is:

IFERROR(OFFSET($A$2, ROW(cell)− ROW($L$2), MATCH('Control 2 - Individual / Strategies'::$B$2, $A$1:$K$1,0) − 1), "")


I want to be able to manually enter the mid asset prices in B2, C2, D2 etc to K2 in “Control 1” and have the choice of which x axis data to display for the charts x axis (vertical right display) from "Legs 1-10 P/L.”


Eg Legs 1, 2 and 3 are £/$ trades and the mid asset price value at the time of trade = 12600 (ranging from 10100 to 15100). I would like to be able to use the offset formulas (as I have for plotting other x and y axis data), so that the chart will show the asset prices from 10100 to 15100 below the x axis. 


How can I achieve this?


Cheers!



MacBook Pro 15″, macOS 12.3

Posted on Jul 22, 2024 2:35 AM

Reply
2 replies

Help coding for 10 different X Axis

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.