+ Reply to Thread
Results 1 to 2 of 2

Visualize profit (3rd column) based on buy&sell levels (1st+2nd columns)

  1. #1
    Registered User
    Join Date
    03-24-2014
    Location
    Vienna, Austria
    MS-Off Ver
    Excel 2010
    Posts
    72

    Visualize profit (3rd column) based on buy&sell levels (1st+2nd columns)

    Hi.

    I did historical backtesting of a financial instrument and would like to plot the results in a meaningful way. The data looks like that:

    lzPJd77QQtyDeFc4yNcLyQ.png

    Without going into details, I calculated the profit for every combination of a so-called BUY-LEVEL from 0.1% to 10% (0.1% steps) and SELL-LEVEL from 0.6% to 10% (0.1% steps).

    Basically, I would like to have a graph that emphasizes/gives a hint which combinations are the most profitable.

    Does anybody know of a good plot in Excel that can visualize what I would like to have?
    My first idea (paper&pen) was BUYLEVEL on x-axis, SELLLEVEL on y-axis and profit on a 2nd y-axis on the right side. However it would be misleading and not plotted correctly, since SELL-LEVEL&Profit are not independent events.

    I am very thankful for any hint (also on theory/examples of financial plotting, or similiar)
    Cheers

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Visualize profit (3rd column) based on buy&sell levels (1st+2nd columns)

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.
    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
    Include in the attachment any code you're currently using (whether it works or not) and an After of what you wish the output to be.

    To attach a Excel file to your post,
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post

+ 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. [SOLVED] I cannot visualize column in my form
    By rickmeister in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-04-2017, 11:40 AM
  2. Help with win loss and tie column & adding profit based on win or loss.
    By schroeder641 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-25-2016, 03:41 PM
  3. [SOLVED] Find desired sell price after costs with target profit margin
    By Juddk in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-13-2016, 02:41 PM
  4. Replies: 2
    Last Post: 09-30-2013, 07:06 PM
  5. [SOLVED] Function/Formula to display minimal sell price for profit
    By DKSJ in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-22-2012, 10:17 AM
  6. Triggers to buy/sell based on histogram
    By x3mist in forum Excel General
    Replies: 0
    Last Post: 07-23-2006, 09:30 PM
  7. [SOLVED] i need template for my cost/profit on materials i sell
    By AMC Photo in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 07-29-2005, 01: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