+ Reply to Thread
Results 1 to 4 of 4

Help automating formula to sum trade profits within each workday.....See details below.

  1. #1
    Registered User
    Join Date
    12-19-2020
    Location
    Los Angeles
    MS-Off Ver
    10
    Posts
    2

    Help automating formula to sum trade profits within each workday.....See details below.

    I would like to use sumif (or else) to calculate trade profits within each trading day of the week, month, year.

    For example, how to sum the profits from 10 trades that I had made this past Monday (December of 2020) and so on?

    I know that these results can eventually be plotted in a pivot table.

    Here is what I am trying to automate
    Daily trading profits .jpg

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,457

    Re: Help automating formula to sum trade profits within each workday.....See details below

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Registered User
    Join Date
    12-19-2020
    Location
    Los Angeles
    MS-Off Ver
    10
    Posts
    2

    Re: Help automating formula to sum trade profits within each workday.....See details below

    Thank you for your quick response, but the only thing I have is a spreadsheet w two columns:
    Column1 - dates w the following format (mm/dd/yyyy ddd)
    Column2 - profit or losses

    The attached picture is what I would like to create (I found it in the internet)

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,457

    Re: Help automating formula to sum trade profits within each workday.....See details below

    As requested, please post a sample sheet.
    You can't really expect our members helping for free on their spare time to recreate a sheet for testing purposes because you do not want to.
    Also add some manually expected results

+ 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: 3
    Last Post: 05-18-2020, 07:10 AM
  2. [SOLVED] I need a formula to calculate the commission per trade of my broker
    By sigma_ in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-06-2018, 02:11 PM
  3. [SOLVED] A complex formula to calculate the profits
    By shimaa01234 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-29-2015, 03:44 PM
  4. Automating workday while considering time format
    By crius in forum Excel General
    Replies: 3
    Last Post: 05-05-2014, 07:03 AM
  5. Sumproduct formula to trade the Week
    By cartica in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 03-25-2014, 09:46 AM
  6. [SOLVED] Formula(ae) to mimic offsetinmg of losses against profits
    By Bill in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-26-2005, 07:06 PM
  7. Formula(ae) to mimic offsetinmg of losses against profits
    By Bill in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2005, 05:06 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