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.

gomes

MP on excel

Recommended Posts

Hi, everybody.

First of all I want to thank you people who started this forum and all the participants that contribute.

I have a question about MP software. I want to be able to have MP on the excel spreadsheet. If anyone knows where I can find the MP code for excel I appreciate if you would share it. I have a MP software. I am looking for this learning and testing purposes. Thanks in advance.

Share this post


Link to post
Share on other sites

Hi Gomes,

 

I've known only one other person who's had Market Profile in an excel spreadsheet, and that was inputted by hand. Out of curiosity....what learning and testing are you looking to do? There may be things that either I or others can run for you.

 

Chris

Share this post


Link to post
Share on other sites

Hi, Chris

thank for your fast reply.

What I am looking to do with excel spreadsheet is front running the numbers and before it happens I want to see how the MP will look like. It is kind of a projections. things that I don't see on the software. exp If I have the excel spreadsheet I can run the market price higher or lower and can see the changes in the profile before the bracket ends. Things like that would be very beneficial for my understanding of MP. Looking for your responds

Humberto

Share this post


Link to post
Share on other sites

Very interesting idea...I've never heard of anyone wanting to do that sort of thing. So...if I'm understanding correctly, you want to be able to input prices that haven't yet traded, just to see what the profile would end up looking like if the prices do trade there? What insights would be gained from this sort of thing? I'm intrigued :)

Share this post


Link to post
Share on other sites

OK Here is my MP excel file. It has a number of features:

 

Sheet one is for data - only for reference in this version - mine has a dynamic link to quote.com so it will plot market profile in real time.

 

Sheet 2 is the 30 minute analysis. Cut and paste the high and low prices from your data and then paste special transpose. The profile will be created lower down.

 

Sheet 3 is very interesting. Here I have a 5 minute analyser. This plots half hour profiles with 5 min data. It also has a composite that shows how the profile is building up with each new half hour.

 

I am currently doing a kind of simulation with this to learn how to trade properly. It is going really well.

 

I am trying to put this into another language for a stand alone program.

 

The file is quite big - I have got MP for the whole of 2003 in the last sheet.

 

Regards,Nick

Share this post


Link to post
Share on other sites

Hi Nick,

I don't know how to thank you. I can't tell you that when I saw your reply that you are sharing your 3 years work (easy to say) and this is so much for me. I think this is something that I don't forget. You are very nice person. I will download it right away. Thanks a million.

Best Regards

Humberto

Share this post


Link to post
Share on other sites

small point lads - there is a slight error in the code - you will have to download it again I'm afraid. the small problem is that the bottom tick of the 5 minute profile did not show. I have corrected this.

 

MEGAUPLOAD - The leading online storage and file delivery service

 

Obviously if you want help on how to use this tool just give me a shout. I'm glad it's helpful.

 

Regards

Share this post


Link to post
Share on other sites

Out of interest for all of you to be converted from pivot points to Market Profile I have attached a file showing the high and the low only of each day. The red lines on the left side show the pivot levels. The market on the left are the same days as on the right, but on the right they are market profile. You can clearly see the support and resistance at work instead of the arbitrary pivot numbers.

 

Regards

 

MEGAUPLOAD - The leading online storage and file delivery service

Share this post


Link to post
Share on other sites

Hi, Nick

I downloaded your excel file. On first sheet (ES data) I didn't see MP, I think this is because I don't have a real time data feed into excel thats why I wasn't able to see MP. Correct me if I am wrong. And I have a question whenever you have a time to answer. On second sheet (daily analyze) I was able to create a MP with yesterdays data and I was amazed. But I couldn't see the Value Area numbers. I think I looked at everywhere on the sheet. If you please point me where and how I can see Value Areas I will appreciate. Thanks again for your hard work and sharing.

Best Regards Humberto

Share this post


Link to post
Share on other sites

I'm working on MP with Excel and have developped a spreadsheet to be able to see MP in it. I'm using Bloomberg as a datafeed so if some other people have BB and are interested in it, I could give you a version of the spreadsheet.

 

If others are interested, let me know maybe I could do some quick changes in the spreadsheet to allow you to work with it from a csv file.

 

I'm interested in sharing it cause the spreadsheet is still in development and I would like to have some feedback concerning calculations and also for improvements.

 

I joined a screenshot of EURUSD market profile.

 

Ryker

MPExcel.png.448424cde7b9224af3a87384bbc29792.png

Share this post


Link to post
Share on other sites

this is one of the things i dislike about MP - is that people get so dogmatic about it.

 

i use MP. i also use floor traders pivots.

 

they BOTH work.

 

but so many times, I see adherents of MP theory saying that various NON MP levels are "arbitrary" or some such

 

floor trader pivots were invented, and have been used by floor traders for decades.

 

 

i could sit and cherry pick charts that would (falsely) "prove" that MP levels don't work either.

 

fwiw, despite many claims, MP also has "arbitrary" aspects to it. why should 70% be the value area? why not 75% 65% 50% etc.?

 

it's just as arbitrary.

it works, that's the point

Share this post


Link to post
Share on other sites

Ok dalby - first to your point - you're right maybe I should keep my trap shut with regard to pivots - but I must add that I give no credence to the 70% value area either. Go with what you know. That is why - gomes - you will not find any value area on my chart. Plus they are a nightmare do mechanically. Also gomes the first sheet is just data, that's it there should be nothing else. In my sheet that will update from quote.com - I have to add that ryker's sheet looks far better than mine in plotting MP. My sheet is for MP training offline and can be used to determine how the trading day is developing. I have used it for pattern recognition of MP instead of bar charts.

Share this post


Link to post
Share on other sites

70% is because it's the closest round number to 1 standard deviation of a bell curve, which is what a perfectly balanced profile is. 70% is by no means an arbitrary number. It represents a statistical figure.

Share this post


Link to post
Share on other sites

thegull i am aware of that - but it makes all kinds of assumptions about price variation in a "normal" curve vs. gaussian distributions

 

like i said. i USE market profile

 

i LIKE market profile

 

i also use floor trader pivots, and they both work

 

MP adherents ime are among the most dogmatic (just go to cisco-futures for examples) of traders, because I just see this constant "market profile is scientific and stuff and other methodologies are arbitrary" repeated time and time again.

 

there is no holy grail, there is no one best way.

Share this post


Link to post
Share on other sites

Ok, I joined the spreadsheet.

 

Please note:

  • You can plot many days as long as you have data (not too much because of restrictions in excel).
  • This is note the last version but as I'm still working on it and have made a lot of changes in it, I can't share it for now. Probably in the near future :).

 

Waiting for your feedbacks,

Thanks

MP - 0.024.xls

Share this post


Link to post
Share on other sites

I completely agree with you. You had just mentioned in a previous post that 70% was arbitrary. There is no one way, thats what is awesome about the markets. MP gives a great way to look at the markets, and I do use MP levels for my trading. I also use floor trader pivots and the basic hi and lo of the current and previous day. I don't use fibs or anything else, though. That stuff starts to get a little esoteric for my palette, but lots of people have success with it.

 

:) Didn't mean any offense, so hope none was taken.

Share this post


Link to post
Share on other sites

no offense taken. the issue with arbitrary is that it is a loaded word, and one that "sets me off" cause i see it so much from MP adherents.

 

floor trader pivots are established using a formula

 

the value area is established using a formula.

 

whether or not either formula is "arbitrary" is frankly, a matter of opinion.

 

also, the 1 standard deviation thing is solidly dependanty on the assumption that equity markets distribute price in a normal curve. there is a fair bit of evidence that this is not the case in many respects.

 

this is similar to how some people say the bollinger bands correctly establish a X standard deviation, when i think it is relatively clear that markets do not distribute prices normally.

 

if they did, market events like 1987 would have less than a one in a million chance of occurring (approximately) as is the case with several other market events that occur much more frequently

 

the markets are a chaotic feedback system, and there ARE many ways to succeed - i agree.

 

MP does not have the stranglehold on market understanding or methodology, and that was my point.

Share this post


Link to post
Share on other sites

lol

 

boba, you sound conflicted.

 

first you retract the statement, then you reassert it.

 

"I voted for it before I voted against it"

 

or something

 

...

 

:D

Share this post


Link to post
Share on other sites

i'm just having a laugh with ya dalby - problem with forums is you can't get over subtle points. No really no offence just kidding. Pivots work because people watch them - I understand that.

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

    • Date: 16th April 2024. Market News – Stocks and currencies sell off; USD up. Economic Indicators & Central Banks:   Stocks and currencies sell off, while the US Dollar picks up haven flows. Treasuries yields spiked again to fresh 2024 peaks before paring losses into the close, post, the stronger than expected retail sales eliciting a broad sell off in the markets. Rates surged as the data pushed rate cut bets further into the future with July now less than a 50-50 chance. Wall Street finished with steep declines led by tech. Stocks opened in the green on a relief trade after Israel repulsed the well advertised attack from Iran on Sunday. But equities turned sharply lower and extended last week’s declines amid the rise in yields. Investor concerns were intensified as Israel threatened retaliation. There’s growing anxiety over earnings even after a big beat from Goldman Sachs. UK labor market data was mixed, as the ILO unemployment rate unexpectedly lifted, while wage growth came in higher than anticipated – The data suggests that the labor market is catching up with the recession. Mixed messages then for the BoE. China grew by 5.3% in Q1 however the numbers are causing a lot of doubts over sustainability of this growth. The bounce came in the first 2 months of the year. In March, growth in retail sales slumped and industrial output decelerated below forecasts, suggesting challenges on the horizon. Today: Germany ZEW, US housing starts & industrial production, Fed Vice Chair Philip Jefferson speech, BOE Bailey speech & IMF outlook. Earnings releases: Morgan Stanley and Bank of America. Financial Markets Performance:   The US Dollar rallied to 106.19 after testing 106.25, gaining against JPY and rising to 154.23, despite intervention risk. Yen traders started to see the 160 mark as the next Resistance level. Gold surged 1.76% to $2386 per ounce amid geopolitical risks and Chinese buying, even as the USD firmed and yields climbed. USOIL is flat at $85 per barrel. Market Trends:   Breaks of key technical levels exacerbated the sell off. Tech was the big loser with the NASDAQ plunging -1.79% to 15,885 while the S&P500 dropped -1.20% to 5061, with the Dow sliding -0.65% to 37,735. The S&P had the biggest 2-day sell off since March 2023. Nikkei and ASX lost -1.9% and -1.8% respectively, and the Hang Seng is down -2.1%. European bourses are down more than -1% and US futures are also in the red. CTA selling tsunami: “Just a few points lower CTAs will for the first time this year start selling in size, to add insult to injury, we are breaking major trend-lines in equities and the gamma stabilizer is totally gone.” Short term CTA threshold levels are kicking in big time according to GS. Medium term is 4873 (most important) while the long term level is at 4605. 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: 15th April 2024. Market News – Negative Reversion; Safe Havens Rally. Trading Leveraged Products is risky Economic Indicators & Central Banks:   Markets weigh risk of retaliation cycle in Middle East. Initially the retaliatory strike from Iran on Israel fostered a haven bid, into bonds, gold and other haven assets, as it threatens a wider regional conflict. However, this morning, Oil and Asian equity markets were muted as traders shrugged off fears of a war escalation in the Middle East. Iran said “the matter can be deemed concluded”, and President Joe Biden has called on Israel to exercise restraint following Iran’s drone and missile strike, as part of Washington’s efforts to ease tensions in the Middle East and minimize the likelihood of a widespread regional conflict. New US and UK sanctions banned deliveries of Russian supplies, i.e. key industrial metals, produced after midnight on Friday. Aluminum jumped 9.4%, nickel rose 8.8%, suggesting brokers are bracing for major supply chain disruption. Financial Markets Performance:   The USDIndex fell back from highs over 106 to currently 105.70. The Yen dip against USD to 153.85. USOIL settled lower at 84.50 per barrel and Gold is trading below session highs at currently $2357.92 per ounce. Copper, more liquid and driven by the global economy over recent weeks, was more subdued this morning. Currently at $4.3180. Market Trends:   Asian stock markets traded mixed, but European and US futures are slightly higher after a tough session on Friday and yields have picked up. Mainland China bourses outperformed overnight, after Beijing offered renewed regulatory support. The PBOC meanwhile left the 1-year MLF rate unchanged, while once again draining funds from the system. Nikkei slipped 1% to 39,114.19. On Friday, NASDAQ slumped -1.62% to 16,175, unwinding most of Thursday’s 1.68% jump to a new all-time high at 16,442. The S&P500 fell -1.46% and the Dow dropped 1.24%. Declines were broadbased with all 11 sectors of the S&P finishing in the red. JPMorgan Chase sank 6.5% despite reporting stronger profit in Q1. The nation’s largest bank gave a forecast for a key source of income this year that fell below Wall Street’s estimate, calling for only modest growth. Apple shipments drop by 10% in Q1. 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.
    • The morning of my last post I happened to glance over to the side and saw “...angst over the FOMC’s rate trajectory triggered a flight to safety, hence boosting the haven demand. “   http://www.traderslaboratory.com/forums/topic/21621-hfmarkets-hfmcom-market-analysis-services/page/17/?tab=comments#comment-228522   I reacted, but didn’t take time to  respond then... will now --- HFBlogNews, I don’t know if you are simply aggregating the chosen narratives for the day or if it’s your own reporting... either way - “flight to safety”????  haven ?????  Re: “safety  - ”Those ‘solid rocks’ are getting so fragile a hit from a dandelion blowball might shatter them... like now nobody wants to buy longer term new issues at these rates...yet the financial media still follows the scripts... The imagery they pound day in and day out makes it look like the Fed knows what they’re doing to help ‘us’... They do know what they’re doing - but it certainly is not to help ‘us’... and it is not to ‘control’ inflation... And at some point in the not too distant future, the interest due will eat a huge portion of the ‘revenue’ Re: “haven” The defaults are coming ...  The US will not be the first to default... but it will certainly not be the very last to default !! ...Enough casual anti-white racism for the day  ... just sayin’
    • Date: 12th April 2024. Producer Inflation On The Rise, But Will Earnings Hold Demand Steady?     Producer inflation rose slightly less than previous expectations, but the annual figure continues to rise. The annual PPI rose to 2.1% and the Core PPI rose to 2.4%. The NASDAQ and SNP500 end the day higher, but the Dow Jones continues to struggle. This morning earnings kick off with the banking sector including JP Morgan, BlackRock and Wells Fargo. All 3 stocks trade higher during pre-trading hours. The Euro trades lower against all currencies despite the ECB’s attempt to establish a hawkish tone. USA100 – The NASDAQ Climbs Higher, But Is the Growth Sustainable? The NASDAQ was the only index which did not witness a significant decline at the opening of the US session. In addition to this, the USA100 is the only index which is witnessing indications of a bullish market. The price has crossed onto a higher high breaking the resistance level at $18,269. The index is also trading above the 75-Bar EMA and at the 65.00 level on the RSI which signals buyers are controlling the market. However, a similar large bullish impulse wave was also formed on the 3rd and 5th of the month and was followed by a correction. Therefore, investors need to be cautious of a bearish breakout which may signal a correction back to the 75-bar EMA (18,165). The medium-term growth and its sustainability will depend on the upcoming earnings data.   Bond yields declined during this morning’s Asian session by 18 points, which is positive for the stock market. However, even with the decline, bond yields remain significantly higher than Monday’s opening yield. This week the 10-year bond yield rose from 4.424 to 4.558, which is a concern. If bond yields again start to rise, the stock market potentially can again become pressured. 25% of the NASDAQ ended the day lower and 75% higher. This gives a clear indication of the sentiment towards the technology sector and reassures traders about the price movement. Another positive was all of the top 12 influential stocks rose in value. Apple, NVIDIA and Broadcom saw the strongest gains, all rising more than 4%. Producer inflation read slightly lower than expectations, however, the index continues to rise. The Producer Price Index rose from 1.6% to 2.1% and the Core PPI from 2.1% to 2.4%. Therefore, it is not indicating inflation will become easier to tackle in the upcoming months. For this reason, investors should note that inflation and the monetary policy is still a risk and can trigger strong bearish impulse waves. EURUSD – The Euro Declines Against Major Currencies The European Central Bank is attempting to concentrate on the positive factors and give no indications of when the committee may opt to cut rates. For example, President Lagarde advises “sales figures” remain stable, but the issue remains they are stably low. Officials said the decline in prices generally confirms medium-term forecasts and is ensured by a decrease in the cost of food and goods. Most experts continue to believe that the first reduction in interest rates will happen in June, and there may be three or four in total during the year. Due to this, the Euro is declining against all currencies including the Pound, Yen and Swiss Franc. The US Dollar Index on the other hand trades 0.39% higher and is almost trading at a 23-week high. Due to this momentum, the price of the exchange continues to indicate a decline in favor of the US Dollar.   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 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.
    • $MSFT Microsoft stock top of range breakout above 433.1, https://stockconsultant.com/?MSFT
×
×
  • Create New...

Important Information

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