+ Reply to Thread
Results 1 to 5 of 5

Simple Buy Order Formula!

  1. #1
    Forum Contributor
    Join Date
    08-18-2017
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    308

    Wink Simple Buy Order Formula!

    Hi excelers,
    Being trying to develop a simple Buy order sheet for hours now!!!!

    IF "BUY" appears, hold price until limit price is reach.
    Hard to explain you need to see attached sheet...

    Any suggestions is welcome and please keep your formula as simple as possible as it will be used on massive data sets) thx
    Attached Files Attached Files
    Last edited by QuantEdge; 09-28-2018 at 03:09 PM.

  2. #2
    Forum Contributor
    Join Date
    03-28-2018
    Location
    Houston, TX
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    127

    Re: Simple Buy Order Formula!

    This will need further explanation. I looked at the attached file, and it doesn't help much with explaining the desired outcome. Thanks!

  3. #3
    Forum Contributor
    Join Date
    08-18-2017
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    308

    Re: Simple Buy Order Formula!

    Brant,
    IF "BUY" appears, hold price until limit price is reach.

    Note, overlaying BUY signal should be ignored, until the first Buy reaches its limit.

    its what we call in finance as a target or limit profit (exit order).

  4. #4
    Forum Contributor
    Join Date
    08-18-2017
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    308

    Re: Simple Buy Order Formula!

    new example sheet...
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    03-28-2018
    Location
    Houston, TX
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    127

    Re: Simple Buy Order Formula!

    QuantEdge,

    I would like to help you and I'm sure others would too, but you need to be much more clear with what exactly you are trying to accomplish here. This is (I believe), why you are not getting responses. The problem is most likely a quite simple one to solve, but I do not understand what exactly needs to happen. Please be clear and specific.

    Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Simple Purchase Order
    By Jack 605 in forum Excel General
    Replies: 2
    Last Post: 06-02-2017, 09:39 AM
  2. [SOLVED] Order Form to Summarise Order on another sheet with a Submit Order Button
    By KazzICC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-01-2014, 03:25 AM
  3. Simple Stock Order Delivery Date Notice
    By Preshantanp007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2014, 06:33 AM
  4. [SOLVED] Probably a SUM formula for order no. to get the total amount of order
    By Konnie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2013, 04:29 AM
  5. Replies: 4
    Last Post: 12-07-2012, 11:49 AM
  6. Creating a simple order form
    By matthew1968 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-06-2010, 03:27 PM
  7. simple purchase order
    By deaconmoon in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-15-2007, 05:44 PM

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