+ Reply to Thread
Results 1 to 3 of 3

Replace a formula input w/ a series of inputs & display respective series of outputs

  1. #1
    Registered User
    Join Date
    12-12-2010
    Location
    San Francisco
    MS-Off Ver
    Excel 2007
    Posts
    2

    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.

    Thanks

    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
    Attached Files Attached Files
    Last edited by Beezer4; 12-12-2010 at 07:50 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,047

    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)

    Regards
    Trevor Shuttleworth - Excel Aid

    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


  3. #3
    Registered User
    Join Date
    12-12-2010
    Location
    San Francisco
    MS-Off Ver
    Excel 2007
    Posts
    2

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1