Use Drop Down Menu to reference different tables which produce different graphs
H I there,
I was wondering is it possible to use a Drop Down Menu to reference different tables which will then show different graphs?
Macroption com - a provider of options graphs has a calculator made in Excel that allows you to draw different graphs using the drop down menu. Pls see my Macro image.
In my Macro image, in the top graph, we see the price of eg a £/$ Call option (a bullish derivative instrument who's price changes based on what the underlying price of the £/$ (or other assets) does or changes in interest rates or other variables (that are listed in the drop down menu).
With the use of drop downs, Macroption have produced different graphs that can show different financial relationships (from a pre created set of different tables that give different metrics like the relationship between the Call price and a change in the underlying price of the £/$ or a change in volatility %'s. They can change the bottom Delta graph and display a Theta decay graph.
I have made my own Black Scholes Option pricing sheet (please see images) and wondered how to pull up or reference different financial tables so that my Drop Down's will produce different graphs where the X and Y axis might completely change? Eg the X axis might change from underlying price of the £/$ to the number of days left to contract expiry.
I'm hoping a method is available in Numbers?
Cheers for any insights or ideas.
MacBook Pro 15″