Excel spreadsheet code help - Aussie Stock Forums

Results 1 to 3 of 3
  1. #1

    Default Excel spreadsheet code help

    Just trying to work out how to do a code for working out an issue.

    OK.....bare with me, i hope this makes sense.......here is a hypothetical

    Lets say i buy 1000 +++ shares at $1
    Lets say it drops to .70 a month later
    Lets say i buy 1000 more +++ at .70

    So now i have
    1000 x $1
    1000 x .7
    ave .85

    OK......so the SP hits .80 and hangs there for a while and while i've made a small profit on the second lot, i still haven't made my ave back. I see an opportunity somewhere else and want to sell these +++. I don't want to make a realized loss so i sell the second 1000 and some of the 1st 1000

    Trading with a company that charges $15 in/out, i sell the second 1000 and make a $70 profit. BUT, what if i want to get more cash?? I can sell a certain amount of my 1st 1000 with the 2nd 1000 and still come out at $0 profit/loss.

    With out going thru the BS to work out that i can sell 350 of the first lot (my calculations, i hope thats correct) what would i be coding in my spreadsheet to work that out in a flash?

    I currently have a spreadsheet that easily tells me out prices to make small profits and of course my profits/losses made. I just want to somehow start a new one or add this new equation onto it for instances like this.

    Cheers in advance.

  2. #2

    Default Re: Excel Spreadsheet help / Code

    See image below for sample spreadsheet. The "Additional Parcel Size" is highlighted and you can see the formula =(D2*(C2-A2)-E2*2)/(B2-C2).

    Your example is coded into it ... absolute no responsibility taken if my maths is dodgy.
    Attached Images
    Don't take investment advice from seafood.

  3. #3

    Default Re: Excel spreadsheet code help

    Excellent....cheers for that

Similar Threads

  1. Live feed for Excel spreadsheet?
    By wandering in forum Software and Data
    Replies: 7
    Last Post: 29th-September-2013, 11:09 PM
  2. Excel Spreadsheet
    By gregcourageous in forum Trading/Investing Resources
    Replies: 57
    Last Post: 6th-March-2013, 09:58 PM
  3. Importing into Excel
    By skyQuake in forum General Chat
    Replies: 0
    Last Post: 13th-September-2008, 04:39 PM
  4. Comsec contract notes -> Excel spreadsheet
    By MattB in forum Brokers
    Replies: 3
    Last Post: 28th-September-2007, 01:16 PM
  5. Excel genius required!
    By halfwheel in forum Software and Data
    Replies: 15
    Last Post: 4th-September-2007, 02:47 PM


Posting Permissions

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