+ Reply to Thread
Results 1 to 1 of 1

Excel help for day-trading journal

  1. #1
    Registered User
    Join Date
    03-19-2014
    Location
    NYC
    MS-Off Ver
    Excel 2021
    Posts
    1

    Excel help for day-trading journal

    Hello all, I am a basic excel user with zero knowledge on VBA or macros. I created a simple stock options day-trading journal but I'm having trouble formatting specific data from my broker to import into my journal.

    Excel A shows my edited broker data. Excel B shows my trading journal and how I would like data from A to show up in B, color-coded. The thing that throws me off is that my broker has a "buy to open" and "sell to close" row that I don't know how to reduce into one merged row.

    I normally day-trade so for my QQQ trades, they are closed same day but on occasion I will hold a position longer like with AMD, where I bought 5, sold 3 same day and sold 2 the next day.

    What would be the best way to show what I am looking for? Can I do it via formula or conditional formatting or can this only be done through VBA or macros? I believe QQQ trades should be easy enough to show but it might be a bit more difficult to show the AMD trades in my particular format as it will need additional math formulas.

    Any help would be greatly appreciated. Thank you.
    Attached Files Attached Files

+ 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. Replies: 1
    Last Post: 03-26-2020, 12:27 PM
  2. Options Trading And Excel
    By OptionsCBOE in forum Excel General
    Replies: 3
    Last Post: 03-08-2020, 02:03 AM
  3. Journal for trading stocks help
    By EFW in forum Excel General
    Replies: 11
    Last Post: 07-29-2018, 05:48 PM
  4. Replies: 4
    Last Post: 02-13-2014, 09:16 AM
  5. Need help with an "if function" to improve a Forex trading journal
    By baelar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-18-2013, 03:09 AM
  6. Excel trading calculator
    By tigorin in forum Excel General
    Replies: 0
    Last Post: 01-13-2013, 04:23 PM
  7. how do i keep a journal or log with excel?
    By nancerella tapioca pudding fox in forum Excel General
    Replies: 1
    Last Post: 08-21-2006, 08:05 AM

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