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

By gomes, in Market Profile

Recommended Posts

Bob00    10

Bob00
Posted

Tks for your reply,

Yes IQfeed does provide DDE feed, they also include a saple DDE spreadsheet in Excell but it doesn't work to me.

 

I've put all the settings they say but nothing.

May be I have an old version of Excell (2002)

 

Tks again

Share this post

Link to post
Share on other sites

Soultrader    12

Soultrader
Posted
Thanks :), I have to say that when I started to work on the spreadsheet I never thought that I could have that...

 

I'm not sure to understand what do you mean by a composite profile or day by day profiles?

 

Thanks

 

Hi Ryker,

 

Thank you for your reply. I am actually interested in a day by day profile as well. Right now I do this manually which is not a problem but wanted to see if this could be done automatically.

 

Also, I would like to be able to plot a MP chart anytime I want. In other words, if the cells are not filled the MP button will give me an error. Is there anyway for me to fix this as I want to be able to plot a MP chart throughout the day instead of end of day only.

 

By a composite profile, I am interested in plotting a combination of the past sessions. So instead of TPO counts of just one day, a composite profile would plot a combined TPO print of the past x trading days. So you will get one fat profile consisting of x days.

 

Thanks Ryker.

Share this post

Link to post
Share on other sites

ryker    10

ryker
Posted
Hi Ryker,

 

Thank you for your reply. I am actually interested in a day by day profile as well. Right now I do this manually which is not a problem but wanted to see if this could be done automatically.

 

Also, I would like to be able to plot a MP chart anytime I want. In other words, if the cells are not filled the MP button will give me an error. Is there anyway for me to fix this as I want to be able to plot a MP chart throughout the day instead of end of day only.

 

By a composite profile, I am interested in plotting a combination of the past sessions. So instead of TPO counts of just one day, a composite profile would plot a combined TPO print of the past x trading days. So you will get one fat profile consisting of x days.

 

Thanks Ryker.

 

Hi,

Which version of the spreadsheet do you use?

With the latest version of the spreadsheet (version 0.030) you can plot a MP chart throughout the day with no problem (the refresh version doesn't work yet with a merge profile but work well with a split one. Refresh can be done by pressing split and then merge again until I add a fix).

 

I don't understand when you say that cells are not filled, which cells?

 

There is a way to export Tradestation data to a file readable by the spreadsheet so that you'll have an auto refresh possibility.

 

For composite profile:

I was thinking of adding that aswell, it won't be too difficult to add but I'm still unclear on which last days will be better to have as a composite profile as I still want to be able to compare today's with a composite one or to compare todays + last week as a composite profile. If you have any suggestions on that I'll be glad to hear them.

 

Thanks

Share this post

Link to post
Share on other sites

ryker    10

ryker
Posted
Tks for your reply,

Yes IQfeed does provide DDE feed, they also include a saple DDE spreadsheet in Excell but it doesn't work to me.

 

I've put all the settings they say but nothing.

May be I have an old version of Excell (2002)

 

Tks again

 

You should look also for the possibility to download historical intraday data as live prices through DDE is not ideal.

You could ask their support to help you a bit on that, what you should ask for is a way to download into excel (or somewhere else) todays data (1min bars would be ideal). If possible you'll be able to use the spreadsheet efficiently.

Share this post

Link to post
Share on other sites

Blu-Ray    10

Blu-Ray
Posted

For composite profile:

I was thinking of adding that aswell, it won't be too difficult to add but I'm still unclear on which last days will be better to have as a composite profile as I still want to be able to compare today's with a composite one or to compare todays + last week as a composite profile. If you have any suggestions on that I'll be glad to hear them.

 

Thanks

 

Ryker

 

Excellent work on the Excel program, works a treat, with regards to the composite profile, it would be good if you could choose how many days you want to merge eg. 5 days and then have a section for inputting 5 days worth of data.

 

Just my thoughts, Cheers

 

Blu-Ray

Share this post

Link to post
Share on other sites

Ricardo Salas    10

Ricardo Salas
Posted

Hi:

 

First of all I want to thank Ryker and Boba for their contributions to create a MP program in excel.

I'd like that you could add a window on the left that shows the data for the day you chose. The windows must have the following data:

Date,

The total number of TPOs, For exemple: (169)

The TPOs above the POC, the TPOs at the POC, the TPOs below the POC,

For exemple: (91/10/68)

Put also the prices above in % of the total number of TPOs.

The RANGE(in points)=high price-low price. (15.25)

 

In the profile please on the left add a color column, showing the Initial Balance for the first hour of trading and on the right add another column that shows the Value Area.

 

I know that I asked to be implemented too many things, but I think they could help too.

 

Cheers

 

Ricardo

Share this post

Link to post
Share on other sites

TinGull    10

TinGull
Posted

When I click a different currency in the top and then go back to the EUR_Curncy it gives an error saying "Input past end of file". When I click OK it says then... "Unable to get the Floor property of the WorksheetFunction class." and then the MP chart disappears. Could it be because it's Excel 2007?

Share this post

Link to post
Share on other sites

ryker    10

ryker
Posted
When I click a different currency in the top and then go back to the EUR_Curncy it gives an error saying "Input past end of file". When I click OK it says then... "Unable to get the Floor property of the WorksheetFunction class." and then the MP chart disappears. Could it be because it's Excel 2007?

 

Possible, although, I think it's more coming from the data you're using rather than from Excel 2007.

Maybe you could send me the data you're trying to use so I can check on my version to see if it works?

Share this post

Link to post
Share on other sites

ryker    10

ryker
Posted
Hi:

 

First of all I want to thank Ryker and Boba for their contributions to create a MP program in excel.

I'd like that you could add a window on the left that shows the data for the day you chose. The windows must have the following data:

Date,

The total number of TPOs, For exemple: (169)

The TPOs above the POC, the TPOs at the POC, the TPOs below the POC,

For exemple: (91/10/68)

Put also the prices above in % of the total number of TPOs.

The RANGE(in points)=high price-low price. (15.25)

 

In the profile please on the left add a color column, showing the Initial Balance for the first hour of trading and on the right add another column that shows the Value Area.

 

I know that I asked to be implemented too many things, but I think they could help too.

 

Cheers

 

Ricardo

 

Hi Ricardo,

Thanks for your suggestions. Will put some in my TODO list, but don't know at all when this is gonna be implemented yet...

 

For the IB and the VA you have some colours on the chart that show them.

Share this post

Link to post
Share on other sites

TinGull    10

TinGull
Posted
Possible, although, I think it's more coming from the data you're using rather than from Excel 2007.

Maybe you could send me the data you're trying to use so I can check on my version to see if it works?

 

I'm just using the same spreadsheet that you uploaded...no other data. Is that the problem perhaps?

Share this post

Link to post
Share on other sites

ryker    10

ryker
Posted
I'm just using the same spreadsheet that you uploaded...no other data. Is that the problem perhaps?

 

Yes it is the problem. The spreadsheet can't fetch the data for you unless you have a bloomberg terminal. If you don't you need to input your data.

Also, if you have a realtime feed, you can have a realtime update of the spreadsheet (just need to export the data in the csv file every minute).

Share this post

Link to post
Share on other sites

wow    10

wow
Posted

I propose somebody use the google spreadsheet experiment with up to date S&P futures MP and let members in here update volunteering at convenient times. This could help solve probelms quicker.

Share this post

Link to post
Share on other sites

PeXiS    10

PeXiS
Posted

it is a big work I did in vba one year ago, after that I have taken investor rt...it was too long to run it every night...and boring...

 

you need a historical ticks serie, you can use a dde or something. it computes volume and market profile...

Share this post

Link to post
Share on other sites

kuky969    10

kuky969
Posted

Please is somebody using Excel MP from ryker ???

could you please write exactly procedure how use it if I dont want use datafeed or terminal Bloomberg and no need auto update. I wan just daily market profile after close market. I have csv file 1 min data in required format ,I copied it to adresar Import but what next ???? Please can anybody help me ???

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.

×
Go To Topic Listing

  • Topics

  • Posts

    • HFblogNews
      HFMarkets (hfm.com): Market analysis services.

      By HFblogNews · Posted

      Date: 22nd January 2025.   Netflix Earnings Surge Driving the NASDAQ to Monthly Highs!   The NASDAQ increases in value for a fourth consecutive day, gaining momentum after Netflix stocks rise more than 15%. Earnings reports are gaining speed for the technology sector, but why has Netflix stocks seen such a high and sudden rise in demand? Netflix Stocks Increase 15% Supporting the NASDAQ! Netflix stocks have been one of the best-performing stocks within the NASDAQ, rising more than 79% in 12 months. However, even for Netflix, a 15% rise in less than 24 hours is considered substantial. The quarterly earnings report was made public by Netflix after the market closed on Tuesday. The earnings report confirmed the following: Netflix beat their earnings per share expectations - $4.27 reported vs $4.21 expectations. Netflix’s revenue surpasses the previous quarter - $10.25 billion this quarter vs $9.82 billion in the previous quarter. The online streaming company confirms projects to expand into live sport and event streaming will proceed. In addition to this, the company’s forward guidance for 2025 remains positive. Netflix is the 10th most influential company for the NASDAQ meaning the positive earnings data and bullish price movement supports the overall price of the NASDAQ. In addition to this, the positive earnings improve the sentiment towards the entire US technology sector. Investors will now turn their attention to the quarterly earnings report for Intuitive Surgical. Intuitive Surgical stocks on Tuesday rose 1.94%. How is the Economy And Politics Affecting the NASDAQ?     The US stock market is witnessing an upward correction after struggling in the last weeks of 2024. The bullish price movement is a result of a sharp decline in bond yields, the new US administration and earnings season. Investors remain relieved that bond yields have fallen back down from the 5.00% level. If bond yields continue to decline further, particularly below 4.50%, the move would be deemed as positive for the US stock market. President Trump took office on Monday and so far the pro-US rhetoric from the President, Vice President and Secretary of State continues to support the stock market. So far, the main concern is how upcoming tariffs can negatively affect inflation and growth. However, some economists advise tariffs will become the “norm” and may have a lesser effect compared to 2018. However, this is something traders will continue to evaluate and monitor. The VIX this morning fell 0.83% lower and trades more than 5.70% lower over a 7-days. The lower VIX indicates a higher risk appetite towards the stock market. If the VIX continues to decline a strong buy indication may materialize. On the most influential stocks for the NASDAQ, 82% rose in value on Tuesday. However, Apple stocks, the most impactful stock, fell 3.19% due to poor sell data. If Apple stocks continue to decline, the NASDAQ’s upward trend may come under strain. In the meantime, investors over the next week will continue to monitor upcoming earnings reports. NASDAQ - Technical Analysis The price of the index is trading significantly higher than all Moving Averages on a 2-hour timeframe and relatively high on oscillators. These factors indicate that buyers are controlling the order book. However, price action also confirms the latest impulse wave measures 3.43% which is normally the point at which the index retraces. This is something that investors may also consider. The retracement potentially also may be triggered by Netflix buyers quickly selling to cash in profit after the sudden 15% bullish surge. If a retracement does indeed form, price action and the 75-period EMA indicates that the pullback may drop as low as $21,391.30.     Key Takeaways: The NASDAQ increases in value for a fourth consecutive day, but price action signals a possible retracement before continuing its bullish trend. Netflix stocks increase more than 15% due to strong earnings data. Netflix beat earnings and revenue expectations by 1.39% and confirmed projects to add live sports streaming to its platforms. The VIX trades more than 5.70% lower over a 7-days and US Bond Yields remain at recent lows. On the most influential stocks for the NASDAQ, 82% rose in value on Tuesday. 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 of how markets work. Click HERE to register for FREE!   Click HERE to READ more Market news. Michalis Efthymiou 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 Leveraged 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.
    • Stocks4life
      Breakout and Swing Stock Ideas

      By Stocks4life · Posted

      DASH DoorDash stock, watch for a top of range breakout at https://stockconsultant.com/?DASH
    • Stocks4life
      Breakout and Swing Stock Ideas

      By Stocks4life · Posted

      SYF Synchrony Financial stock with a top of range breakout at https://stockconsultant.com/?SYF
    • Stocks4life
      Breakout and Swing Stock Ideas

      By Stocks4life · Posted

      RKLB Rocket Labstock, big rally off support and breakout at https://stockconsultant.com/?RKLB
    • Stocks4life
      Breakout and Swing Stock Ideas

      By Stocks4life · Posted

      RDW Redwire stock, what a launch off the 14.16 support area at https://stockconsultant.com/?RDW
×
×
  • Create New...

Important Information

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

  I accept