Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

  • Welcome Guests

    Welcome. You are currently viewing the forum as a guest which does not give you access to all the great features at Traders Laboratory such as interacting with members, access to all forums, downloading attachments, and eligibility to win free giveaways. Registration is fast, simple and absolutely free. Create a FREE Traders Laboratory account here.

sergio83

How to Calculate Volume by Price

Recommended Posts

Hi all,

 

As in the title I am wondering how can I calculate the volume by price having the volume of every single bar of 1 minute.

 

So basically how to transfer the vertical histogram of the volume to the horizzontal histogram of the volume.

 

I am making a java program that visualize my own customised charts starting from a CSV file from MetaTrader that contain only the volume for each period of time/candlestick.

 

 

Thanks for any help, suggestion or link to websites or books.

 

Sergio

Share this post


Link to post
Share on other sites

You can't calculate it with 100% accuracy without transaction (tick) data. You could estimate by evenly distributing the volume over the whole bar and perhaps weighting the closing price a bit.

 

But since you seem to be using spot for ex the volume information you have is not accurate already, so that's two levels of inaccuracy.

 

A better option IMO would be to forget volume and use time at price instead. At least this way it's accurate. You might find that it's just as good or better anyway.

Share this post


Link to post
Share on other sites

yes sure! I am programming it already with time at price, but I would also like to implement the volume by price. Actually the whole a idea was to make charts that shows somehow the difference between time at price and volume at price so that (for what I think) you can see when the volumes are high not just because the price has been there for lot of time.

 

Anyway I am using data from metatrader, but not from the Spot market, I will use BrocoTrader or Sunbird which I told were from the features... aren't they?

 

I know that is an approximation with the bar of 1 minute, but I just want to create a program that get's you used to market profile playing with historical data... I won't use it for trade real money.

 

Might you then explain to me briefly, but step by step hoow would you calculate the volume by price from the volume of each 1M bar?

 

thanks a lot for any help

Share this post


Link to post
Share on other sites

This guy has a volume profile in Excel that uses 1min data. Well done him, Respect due.

 

There are no macros on the worksheet and all his formulas are visible. I'm sure you could

de-construct his formulas and transpose it into Java.

 

Its the file in the 4th post down.

 

Forums - Excel-cumulative volume profiles?

 

 

 

VT

 

Ps If the above helps you're more than welcome to send me a Beta version of your App! lol

Share this post


Link to post
Share on other sites

yes this looks like it is what I was looking for.. I will just have to trust this guy that the procedure is correct.

 

It might take me ages as I am doing it in the sparetime, but sure, I will share my app probably making a website.

Anyway I need feedbacks to see if I did it correctly.

 

Cheers

 

Sergio

Share this post


Link to post
Share on other sites

apparently it should work that way:

 

first we spread the volume of every single bar on all the ticks (the which size we will choose) that this bar has covered:

VolumeOfTheBar/(HighBar-LowBar+1 Tick) * Tick

 

and then for every price tick we will give a value which is the sum of all the volume spreaded volumes which are from the bars that passes from this price tick..

 

as an example:

exaq.jpg

 

 

Does this make sense? will it work correctly even if with approximation?

Share this post


Link to post
Share on other sites

Looks like you've unlocked the secret!

 

Unless you are using a High end data feed, the volume you will receive from a retail broker will be abbreviated anyhow, so don't sweat a few contracts here or there.

 

The excel volume profile tallys up with my charting platforms volume profile, in relation to where the peaks,nodes,and low volume is situated. The figures can sometimes differ, but its not a huge disparity.

 

If it helps, in my trading I'm more concerned with the structure of the profile and where the key areas are, not the exact figures to the nearest contract that made them.

 

VT

Share this post


Link to post
Share on other sites

Ya I also use a Tick chart. In essence instead of the bars being formed after X amount of time has passed they form after X amount of trades have taken place. When the bars for quickly volume is high, when they form slowly, volume is low. I prefer them to time based charts. Daily, 15-min and 512 tick are what I use most.

Share this post


Link to post
Share on other sites
first we spread the volume of every single bar on all the ticks (the which size we will choose) that this bar has covered:

 

Hmm, sounds a lot like this:

 

You could estimate by evenly distributing the volume over the whole bar and perhaps weighting the closing price a bit.

 

But if you were to profile one minute bars like I did just a second ago, you will find that the distributions based on just averaging like you did will be far enough off that you will probably not want to use it. One idea is give less weight to the high and low tick of the bars. I know that estimation can be done because I have software that profiles using one minute data (no tick data), and supposedly is about 95% accurate to the tick data. But no doubt it's being calculated using well-tested data, which you do not have access to.

 

Particularly since you are talking about comparing this with TPOs, I don't see the point of this... what did you hope to find again, if volume was high in an area, and a time-based profile showed that it was not there for a long time? You can get this same data much more easily by looking at a simple volume histogram, and look for high volume per time bar, no need to calculate an inaccurate volume profile and then do a difference with a market profile.

 

Why not just get tick data? MetaTrader must be the most bare bones software out there, and I understand the desire to get stuff cheap, but why not just get the tools you need? You are working on a project which can only yield inaccurate output. I'm not trying to burst your bubble, but just being real as to what you can expect.

 

If you go through with this, I'll be happy to post an actual volume profile so you can compare yours for accuracy.

Share this post


Link to post
Share on other sites

yes sorry Joshdance I could get the first formula from your words.

 

I think that making a program from the tick data would result in a heavier and slower program and also the file to store the data throught the years would be probably huge.

 

I would prefer to remain with the 1min bar for the moment.

 

Keep in mind that I just want to create an educational app, just to get used with the volume profile trading.

I first started because I would like to use VolFix / LuxVol but being that expensive it seems a bit a jump in the unknown to take it just to learn.

Now is more like a game to create this app.. i would also like to implement a tool that makes you see how the time at price or volume at price develope during the time with a sort of replay of the trading session. ..and other sort of this things that a novice might wonder about but which none of the platforms offer to visualize.

Maybe you are right the idea of the difference between Time and Volume at price is useless.

 

I definitely would like to implement this weighted volumes at the extremes... but I can not just invent a method... If I can find a source where a correct way of doing it is explained I can do it otherwise I will just add imprecision I guess.

Could you tell me something more?

 

So it seems that taking data from Broco or other metatrader futures platform is not going to give me anything usefull in terms of volumes...

what exactly does Valuetrader mean when he says:

 

the volume you will receive from a retail broker will be abbreviated anyhow

?

 

Could you tell me which is the best way to get volume wise correct historical data atleast for the EUR/USD future?

 

Maybe the only way is to get my hands on my wallet and get something like this:

FOREX Historical Data, Major Indices and Futures Historical Intraday and Daily Market Data - Through Download and on DVDs/CDs.

Global Historical Intraday Futures Tick Data | Trade and Quote Futures Data | Tick Data

 

it is going to become an expensive game ^_^

better going directly with VolFix :P

Share this post


Link to post
Share on other sites

could anyone tell me how much is the average order of dimension for the 1min Bar volume in the E7?

 

1 bar as usually around 10 or more likely 1000+?

 

just trying to understand what kind of data I have got

 

for example:

2008.01.22,20:36,1.45990,1.46000,1.45980,1.45990,9

2008.01.22,20:37,1.46000,1.46000,1.45980,1.46000,9

2008.01.22,20:38,1.45990,1.46000,1.45990,1.46000,6

2008.01.22,20:39,1.45990,1.45990,1.45980,1.45990,21

2008.01.22,20:40,1.46000,1.46010,1.45980,1.45990,13

2008.01.22,20:41,1.46000,1.46000,1.45990,1.46000,21

2008.01.22,20:42,1.46010,1.46010,1.46000,1.46000,8

 

are those volumes probably only from the broker I am using?

Share this post


Link to post
Share on other sites

First tests of the app...

 

is the Volume @ Price histogram shape anywhere close to what professional platform plots?

 

this is the chart for the EUR/USD date: 2011/07/07...

I am not sure if I have the data from the futures or just Forex Spot

 

firstfm.jpg

Edited by sergio83

Share this post


Link to post
Share on other sites

with tick at 0.0001 is more precise for comparison...

 

POC at 1.4326

 

secondi.jpg

 

 

I am actually now downloading history data from NinjaTrader AMP on 6E.... this should have the correct data, right?

Share this post


Link to post
Share on other sites
It's looking good. The figures you have look correct. Will your app have the ability to create composite profiles over an imputable number of days?

 

I am thinking to have a big profile of the previous week or two, and then you will watch every single day of the current week aside the big profile with the possibility to hide/replay part of the day and when you finish with wednsday (example) you can add its profile to the big one with a different color or watch its profile next to the big one and the profile only of monday and tuesday.

 

what exactly do you mean with composite profiles?

Share this post


Link to post
Share on other sites

A composite profile is two or more day profiles amalgamated together. In my humble opinion a one day profile has limited value. Rather than setting the profile to a fixed time period (eg. Week / month) with an inputable number of days you can create a profile to fit in with the current valed distribution.

Share this post


Link to post
Share on other sites

I will definetely put something like this.

 

you will choose a period in which you can choose a point in time where what is before that point will be summed in a big profile and what is after will be shown as many different profiles aside each the which lenght will be choose from you.

Moving the point you will see how the big profile developes.

 

 

But form me priority will be the visualization of the previous week profile in order to find the POC of this week... and then analize the days of the following week to see how do they behave when they meet POC of the previous week

Share this post


Link to post
Share on other sites

that would be free I guess... that I can customize it as I want... and that I can work on historical data as they are live with some sort of replay function..

 

But yes the all point is to get something that can exercise me to a level which can make me feel conscious in invest the money to get a real platform like VolFix (now LuxVol?)

 

or maybe it is just a game :p

Share this post


Link to post
Share on other sites

Hi guys I finished a first very rough version of my app...

 

ReMarket

 

basically from a NinjaTrader/metatrader4 exported CSV/txt file you can make a file .wem that my app an read... check the menu bar to convert you CSV files.. or download a sample from the website.

Once you got a database .wem you set it from my app (check the menu bar) and you can start to select the dates you want to analise.

 

Since the app has to access you local machine to select the database the app will require you to accept a certificate.

 

The idea is to have a big profile (A-B) from where to spot a POC... then you can select a day after this week to play like it is live.. choosing an increment and then pressin teh button SHOWday++ to see how the profile changes with time.

 

LeftMouseButton LMB makes you pan..

 

CTRL+LMB makes you scale the whole thing... but better to set proper scaling settigns from the menu bar.

 

If you press the RightMouseButton RMB you can place reference lines that will stay even when you pass from a profile to another.

 

The indicator on the left are in blue the VWAP and in red the PVP as taught from JPerl.

 

Check out the difference profile... I know I have been told being useless.. but I find it interesting to spot when a volume is high not only because price has been there for a long time.

 

Sorry the quick post but I am short of time.

Edited by sergio83

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Topics

  • Posts

    • also ... and barely on topic... Winners (always*) overpay. Buying the dips is a subscription to the belief that winners win by underpaying - when in actuality winners (inevitably/always*) win by overpaying... it’s amazing the percentage of traders who think winners win by underpaying ... “Winners (always*) overpay.” ...  One way to implement this ‘belief’ is to only reenter when prices have emphatically resumed the 'trend' .   (Fwiw, While “Winners (always*) overpay.” holds true in most endeavors (relationships, business, sports, etc...) - “Winners (always*) overpay.”  is especially true for auctions... continuous auctions included.)
    • re:  "Does it make sense to always buy the dips?  “Buy the dip.”  You hear this all the time in crypto investing trading speculation gambling. [zdo taking some liberties] It refers, of course, to buying more bitcoin (or digital assets) when they go down in price: when the price “dips.” Some people brag about “buying the dip," showing they know better than the crowd. Others “buy the dip” as an investment strategy: they’re getting a bargain. The problem is, buying the dip is a fallacy. You can’t buy the dip, because you can't see the total dip until much later. First, I’ll explain this in a way that will make it simple and obvious to you; then I’ll show you a better way of investing. You Only Know the Dip in Hindsight When people talk about “buying the dip,” what they’re really saying is, “I bought when the price was going down.” " ... example of a dip ... 
    • Date: 19th April 2024. Weekly Commodity Market Update: Oil Prices Correct and Supply Concerns Persist.   The ongoing developments in the Middle East sparked a wave of risk aversion and fueled supply concerns and investors headed for safety. Hopes for imminent rate cuts from the Federal Reserve diminish while attention is now turning towards the demand outlook. The Gold price hit a high of $2417.89 per ounce overnight. Sentiment has already calmed down again and bullion is trading at $2376.50 per ounce as haven flows ease. Oil prices initially moved higher as concern over escalating tensions with the WTI contract hit a session high of $85.508 per barrel overnight, before correcting to currently $81.45 per barrel. Oil Prices Under Pressure Amid Middle East Tensions Last week, commodity indexes showed little movement, with Oil prices undergoing a slight correction. Meanwhile, Gold reached yet another record high, mirroring the upward trend in cocoa prices. Once again today, USOil prices experienced a correction and has remained under pressure, retesting the 50-day EMA at $81.00 as we moving into the weekend. Hence, despite the Israel’s retaliatory strike on Iran, sentiments stabilized following reports suggesting a measured response aimed at avoiding further escalation. Brent crude futures witnessed a more than 4% leap, driven by concerns over potential disruptions to oil supplies in the Middle East, only to subsequently erase all gains. Similarly with USOIL, UKOIL hovers just below $87 per barrel, marginally below Thursday’s closing figures. Nevertheless, volatility is expected to continue in the market as several potential risks loom:   Disruption to the Strait of Hormuz: The possibility of Iran disrupting navigation through the vital shipping lane, is still in play. The Strait of Hormuz serves as the Persian Gulf’s primary route to international waters, with approximately 21 million barrels of oil passing through daily. Recent events, including Iran’s seizure of an Israel-linked container ship, underscore the geopolitical sensitivity of the region. Tougher Sanctions on Iran: Analysts speculate that the US may impose stricter sanctions on Iranian oil exports or intensify enforcement of existing restrictions. With global oil consumption reaching 102 million barrels per day, Iran’s production of 3.3 million barrels remains significant. Recent actions targeting Venezuelan oil highlight the potential for increased pressure on Iranian exports. OPEC Output Increases: Despite the desire for higher prices, OPEC members such as Saudi Arabia and Russia have constrained output in recent years. However, sustained crude prices above $100 per barrel could prompt concerns about demand and incentivize increased production. The OPEC may opt to boost oil output should tensions escalate further and prices surge. Ukraine Conflict: Amidst the focus on the Middle East, markets overlooking Russia’s actions in Ukraine. Potential retaliatory strikes by Kyiv on Russian oil infrastructure could impact exports, adding further complexity to global oil markets.   Technical Analysis USOIL is marking one of the steepest weekly declines witnessed this year after a brief period of consolidation. The breach below the pivotal support level of 84.00, coupled with the descent below the mid of the 4-month upchannel, signals a possible shift in market sentiment towards a bearish trend reversal. Adding to the bearish outlook are indications such as the downward slope in the RSI. However, the asset still hold above the 50-day EMA which coincides also with the mid of last year’s downleg, with key support zone at $80.00-$81.00. If it breaks this support zone, the focus may shift towards the 200-day EMA and 38.2% Fib. level at $77.60-$79.00. Conversely, a rejection of the $81 level and an upside potential could see the price returning back to $84.00. A break of the latter could trigger the attention back to the December’s resistance, situated around $86.60. A breakthrough above this level could ignite a stronger rally towards the $89.20-$90.00 zone. Always trade with strict risk management. Your capital is the single most important aspect of your trading business. Please note that times displayed based on local time zone and are from time of writing this report. Click HERE to access the full HFM Economic calendar. Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding on how markets work. Click HERE to register for FREE! Click HERE to READ more Market news. Michalis Efthymiou Market Analyst HMarkets Disclaimer: This material is provided as a general marketing communication for information purposes only and does not constitute an independent investment research. Nothing in this communication contains, or should be considered as containing, an investment advice or an investment recommendation or a solicitation for the purpose of buying or selling of any financial instrument. All information provided is gathered from reputable sources and any information containing an indication of past perfrmance is not a guarantee or reliable indicator of future performance. Users acknowledge that any investment in FX and CFDs products is characterized by a certain degree of uncertainty and that any investment of this nature involves a high level of risk for which the users are solely responsible and liable. We assume no liability for any loss arising from any investment made based on the information provided in this communication. This communication must not be reproduced or further distributed without our prior written permission.
    • Date: 18th April 2024. Market News – Stock markets benefit from Dollar correction. Economic Indicators & Central Banks:   Technical buying, bargain hunting, and risk aversion helped Treasuries rally and unwind recent losses. Yields dropped from the recent 2024 highs. Asian stock markets strengthened, as the US Dollar corrected in the wake of comments from Japan’s currency chief Masato Kanda, who said G7 countries continue to stress that excessive swings and disorderly moves in the foreign exchange market were harmful for economies. US Stockpiles expanded to 10-month high. The data overshadowed the impact of geopolitical tensions in the Middle East as traders await Israel’s response to Iran’s unprecedented recent attack. President Joe Biden called for higher tariffs on imports of Chinese steel and aluminum.   Financial Markets Performance:   The USDIndex stumbled, falling to 105.66 at the end of the day from the intraday high of 106.48. It lost ground against most of its G10 peers. There wasn’t much on the calendar to provide new direction. USDJPY lows retesting the 154 bottom! NOT an intervention yet. BoJ/MoF USDJPY intervention happens when there is more than 100+ pip move in seconds, not 50 pips. USOIL slumped by 3% near $82, as US crude inventories rose by 2.7 million barrels last week, hitting the highest level since last June, while gauges of fuel demand declined. Gold strengthened as the dollar weakened and bullion is trading at $2378.44 per ounce. Market Trends:   Wall Street closed in the red after opening with small corrective gains. The NASDAQ underperformed, slumping -1.15%, with the S&P500 -0.58% lower, while the Dow lost -0.12. The Nikkei closed 0.2% higher, the Hang Seng gained more than 1. European and US futures are finding buyers. A gauge of global chip stocks and AI bellwether Nvidia Corp. have both fallen into a technical correction. The TMSC reported its first profit rise in a year, after strong AI demand revived growth at the world’s biggest contract chipmaker. The main chipmaker to Apple Inc. and Nvidia Corp. recorded a 9% rise in net income, beating estimates. Always trade with strict risk management. Your capital is the single most important aspect of your trading business. Please note that times displayed based on local time zone and are from time of writing this report. Click HERE to access the full HFM Economic calendar. Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding on how markets work. Click HERE to register for FREE! Click HERE to READ more Market news. Andria Pichidi Market Analyst HFMarkets Disclaimer: This material is provided as a general marketing communication for information purposes only and does not constitute an independent investment research. Nothing in this communication contains, or should be considered as containing, an investment advice or an investment recommendation or a solicitation for the purpose of buying or selling of any financial instrument. All information provided is gathered from reputable sources and any information containing an indication of past performance is not a guarantee or reliable indicator of future performance. Users acknowledge that any investment in FX and CFDs products is characterized by a certain degree of uncertainty and that any investment of this nature involves a high level of risk for which the users are solely responsible and liable. We assume no liability for any loss arising from any investment made based on the information provided in this communication. This communication must not be reproduced or further distributed without our prior written permission.
    • Date: 17th April 2024. Market News – Appetite for risk-taking remains weak. Economic Indicators & Central Banks:   Stocks, Treasury yields and US Dollar stay firmed. Fed Chair Powell added to the recent sell off. His slightly more hawkish tone further priced out chances for any imminent action and the timing of a cut was pushed out further. He suggested if higher inflation does persist, the Fed will hold rates steady “for as long as needed.” Implied Fed Fund: There remains no real chance for a move on May 1 and at their intraday highs the June implied funds rate future showed only 5 bps, while July reflected only 10 bps. And a full 25 bps was not priced in until November, with 38 bps in cuts seen for 2024. US & EU Economies Diverging: Lagarde says ECB is moving toward rate cuts – if there are no major shocks. UK March CPI inflation falls less than expected. Output price inflation has started to nudge higher, despite another decline in input prices. Together with yesterday’s higher than expected wage numbers, the data will add to the arguments of the hawks at the BoE, which remain very reluctant to contemplate rate cuts. Canada CPI rose 0.6% in March, double the 0.3% February increase BUT core eased. The doors are still open for a possible cut at the next BoC meeting on June 5. IMF revised up its global growth forecast for 2024 with inflation easing, in its new World Economic Outlook. This is consistent with a global soft landing, according to the report. Financial Markets Performance:   USDJPY also inched up to 154.67 on expectations the BoJ will remain accommodative and as the market challenges a perceived 155 red line for MoF intervention. USOIL prices slipped -0.15% to $84.20 per barrel. Gold rose 0.24% to $2389.11 per ounce, a new record closing high as geopolitical risks overshadowed the impacts of rising rates and the stronger dollar. Market Trends:   Wall Street waffled either side of unchanged on the day amid dimming rate cut potential, rising yields, and earnings. The major indexes closed mixed with the Dow up 0.17%, while the S&P500 and NASDAQ lost -0.21% and -0.12%, respectively. Asian stock markets mostly corrected again, with Japanese bourses underperforming and the Nikkei down -1.3%. Mainland China bourses were a notable exception and the CSI 300 rallied 1.4%, but the MSCI Asia Pacific index came close to erasing the gains for this year. Always trade with strict risk management. Your capital is the single most important aspect of your trading business. Please note that times displayed based on local time zone and are from time of writing this report. Click HERE to access the full HFM Economic calendar. Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding on how markets work. Click HERE to register for FREE! Click HERE to READ more Market news. Andria Pichidi Market Analyst HFMarkets Disclaimer: This material is provided as a general marketing communication for information purposes only and does not constitute an independent investment research. Nothing in this communication contains, or should be considered as containing, an investment advice or an investment recommendation or a solicitation for the purpose of buying or selling of any financial instrument. All information provided is gathered from reputable sources and any information containing an indication of past performance is not a guarantee or reliable indicator of future performance. Users acknowledge that any investment in FX and CFDs products is characterized by a certain degree of uncertainty and that any investment of this nature involves a high level of risk for which the users are solely responsible and liable. We assume no liability for any loss arising from any investment made based on the information provided in this communication. This communication must not be reproduced or further distributed without our prior written permission.vvvvvvv
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.