+ Reply to Thread
Results 1 to 2 of 2

Find average price based on threshold in volume

  1. #1
    Registered User
    Join Date
    03-23-2018
    Location
    London
    MS-Off Ver
    Excel for Mac latest version
    Posts
    1

    Find average price based on threshold in volume

    Hello,

    I'm trying to work out how i return the average price based on volume and buy order.

    1. I want to buy 1 bitcoin
    2. Add each of the volume to get 1 bitcoin
    3. Return average price based on the volume up to 1

    Expected result based on the data example beloq: If I buy 1 Bitcoin, I would need to buy from 3 different places in the order book in the volume column (0.42, 0.18 and reminder from the 18.7). So therefore, the average price would be 8944.90.

    What formula can I use to calculate this based on me changing my buy order? E.g The same as above but for 2 Bitcoin.

    Thanks in advance.

    Data example

    Buy order: 1 Bitcoin


    Price Volume (Bitcoin)
    8944.8 0.426146
    8944.91 0.187818
    8945 18.741518
    8945.33 0.05
    8946 1
    8946.96 0.001644
    8948 4.773755
    8948.15 0.01242
    8948.33 0.018924

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Find average price based on threshold in volume

    Hi

    Try this formula where column A has price and column B has the volume

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. Volume Price Mix Calculation
    By Drewftaylor in forum Excel General
    Replies: 1
    Last Post: 11-15-2016, 12:39 PM
  2. [SOLVED] Find volume based on depth in relation to a fill table
    By Eddles in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-19-2014, 04:28 PM
  3. Does anyone have models for price/volume variance
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 03-27-2014, 01:16 PM
  4. Comparative chart for volume and price
    By Aman Bains in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-06-2013, 04:50 PM
  5. adjusting a price based on volume
    By kwkness in forum Excel General
    Replies: 6
    Last Post: 06-17-2013, 03:53 AM
  6. price breaks based on volume and a threshold
    By sallan in forum Excel General
    Replies: 2
    Last Post: 05-22-2013, 01:46 PM
  7. [SOLVED] calculate/convert volume price to monthly average price
    By Bultgren in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2006, 05:40 AM

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