+ Reply to Thread
Results 1 to 2 of 2

FOREX Trading - Calculating Today's Profit

  1. #1
    Registered User
    Join Date
    02-03-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    10

    FOREX Trading - Calculating Today's Profit

    Hello,

    I am making a spreadsheet in order to keep track of my FOREX Trading Data.
    I am relatively new to excel, and made my spreadsheet from various youtube tutorial videos.

    I use this spreadsheet to input new data everyday.
    I found a VBA script that creates a timetamp in the column just to the right of my data.

    I am currently trying to a make a field that would calculate the results of TODAY (Today's Profit).
    I want this cell to reset everyday.

    Im sure its a very simple task involving the =TODAY and =MATCH function, as well as a simple logic statement involving =IF , but I dont know how to go about it.

    I have attached my spreadsheet to this thread (without macros), if anyone has the time to help me out, I would greatly appreciate it.

    Alex
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: FOREX Trading - Calculating Today's Profit

    Hi Alex,

    Welcome to the forum.

    Please guide further which tab /column / row to look for in the attached workbook. Also let us know the column where you want the formula. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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