Skip to main content
February 21, 2025
Question

I have about 200 stock transactions that are flagged as NEEDING REVIEW. I'll be at this for HOURS. Is there an easier way?

  • February 21, 2025
  • 1 reply
  • 0 views
Each transaction requires 3-4 mouse clicks. There's no missing information that TT should already know.

    1 reply

    DaveF1006
    February 26, 2025

    Yes, this does sound monotonous and repetitive.  If you're looking for a way to save time and clicks, you might consider automating the process using a macro or scripting tool. For instance, if you're using a platform like Excel or Google Sheets, you can record a macro to automate the repetitive parts of the process. Here's a quick overview of how you could do it in Excel:

     

    1. Go to the "View" tab and click on "Record Macro."
    2. Perform the actions you need for one transaction (e.g., clicking, entering data).
    3. Stop recording the macro.
    4. Assign the macro to a keyboard shortcut or button.
    5. Run the macro for each transaction.

    In Google Sheets:

     

    1. Go to "Extensions" > "Macros" > "Record Macro."
    2. Perform the necessary actions for one transaction.
    3. Save the macro.
    4. Run the macro for each transaction.
    **Say "Thanks" by clicking the thumb icon in a post**Mark the post that answers your question by clicking on "Mark as Best Answer"