# calculate mp

hi @ all,

i just registered to this forum.

i saw the market profile generator http://www.mypivots.com/calculators/market-profile-calculator.aspx

and would like to calculate POC and the Valuearea with excel.

anyone could help how to calculate.

OHLC of 30min chart schould be base.

thx

frieda

i just registered to this forum.

i saw the market profile generator http://www.mypivots.com/calculators/market-profile-calculator.aspx

and would like to calculate POC and the Valuearea with excel.

anyone could help how to calculate.

OHLC of 30min chart schould be base.

thx

frieda

frieda, The market profile calculator doesn't use excel. Copy the high and low prices for each of the brackets that you want to profile and paste them into the box on that page and then click Generate. Delete the existing prices that are already in there - which are just there to demonstrate.

thx for your reply.

i do use the generator, but also want to build an excelsheet for calculation. so... ...if you do have an algorithm in another format, no problem. i would like to habe a look at it.

thx

frieda

i do use the generator, but also want to build an excelsheet for calculation. so... ...if you do have an algorithm in another format, no problem. i would like to habe a look at it.

thx

frieda

The algorithm for calculating it is here: Calculating Market Profile Value Area. I tried once to create a set of functions in Excel that would calculate it but never succeeded. Let us know if you manage to get it to work.

couldn't find the algo, just a description of mp. :(

I don't have any code for excel if that's what you're looking for.

ok. thanks you.

but why the market profile generator also include the single TPO when calculate the poc/vah/val?

mind to share your idea? I am doing the same thing now just like frieda

mind to share your idea? I am doing the same thing now just like frieda

I don't understand your question asiatrader98.

quote:Originally posted by day trading

I don't understand your question asiatrader98.

sorry....I try to explain more in detail..when I am using the market profile generator, I noticed sometimes the single TPO also treated as VAL esp if that day is trend day.

If that happens then it's just a coincidence. However, the theory is that if there are many lines of resistance or support calculated in different ways for a particular price point then that cluster will make that level more likely to work by dint of the fact that more traders will be trading it.

Emini Day Trading /
Daily Notes /
Forecast /
Economic Events /
Search /
Terms and Conditions /
Disclaimer /
Books /
Online Books /
Site Map /
Contact /
Privacy Policy /
Links /
About /
Day Trading Forum /
Investment Calculators /
Pivot Point Calculator /
Market Profile Generator /
Fibonacci Calculator /
Mailing List /
Advertise Here /
Articles /
Financial Terms /
Brokers /
Software /
Holidays /
Stock Split Calendar /
Mortgage Calculator /
Donate

Copyright © 2004-2023, MyPivots. All rights reserved.

Copyright © 2004-2023, MyPivots. All rights reserved.