Replace a formula input w/ a series of inputs & display respective series of outputs
I am working on a financial spreadsheet. One cell is a formula that equals the profit or loss of a given trade based on a number of assumptions.
One assumption in another cell (let's say B35) is the final stock price (i.e. in a few months...a prediction). However, I would like to create a column that is a series of potential final stock prices (maybe 100 prices or so) and then have the cell right next to each of those assumptions equal the profit/loss that the trade would then equal. I don't know how to take all these new assumed stock prices and plug them into the equation so my new profit/loss is based on the new assumption. I don't want to have to change the assumption each time. I want a bunch of assumptions and then the output for each of those assumptions.
This should be pretty simple to do but I don't know how to do it.
Update: I posted my worksheet. Right now I input my assumed final stock price into B3 and then the total profit/loss from the trades (up to 4 calls, 4 puts, 1 long and 1 short) in cell B35.
However, I'd like to have this final profit/loss read out in cells B43:B443 based on each cell's respective assumed stock price (the cell right next to it in column A). e.g. since A97 is 13.50 and the two trades currently loaded in my worksheet would then equal a 1,722.22 profit, cell B97 should be a formula that reads 1,722.22.
thanks for any help
Last edited by Beezer4; 12-12-2010 at 07:50 PM.
Re: Basic question
Probably easiest to post a sample workbook.
And you'll probably be asked by the moderators to change the title of the post to something more meaningful (as per the rules of the forum)
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Re: Replace a formula input w/ a series of inputs & display respective series of outp
Any ideas? Sorry for the lengthy post and I think my question is pretty basic but I still can't figure it out.
Any help would be much appreciated. Thanks
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1