Supply and demand daily and weekly levels spreadsheet | Page 6 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

Firehorse's trading spreadsheet 45 replies

Important Levels Spreadsheet 0 replies

Spreadsheet with RSI and IFISH formulas 0 replies

VWB - Average Range Spreadsheet 6 replies

Does anyone have Daily range spreadsheet? 2 replies

Attachments: Supply and demand daily and weekly levels spreadsheet
Exit Attachments

Supply and demand daily and weekly levels spreadsheet

  • #101
  • Oct 18, 2013 6:50pm Oct 18, 2013 6:50pm
Quoting fortunateson
I have made the changes as Peter has suggested. So on Sheet2 column A it is called DDE Symbol and the standard symbol names are there (for example EURUSD). If your broker designates a mini (for example EURUSDm) then you can change the symbols on this workspace or use the one provided above on post 85. I would call your broker and ask them what their DDE symbol is if they use something different that these 2. Also the video “How to mechanically pre-plan a supply and demand trade” is now # 3 on page 1 post 1 on Alfonsos’ main thread at http://www.forexfactory.com/showthread.php?t=428204...
MT4/MT5 EAs/Indicators/Alerts coder
  • #102
  • Oct 19, 2013 11:13pm Oct 19, 2013 11:13pm
Here are an indicator a script and an excel spreadsheet that automatically collect the D1, W1, and MN1 supply and demand zones nearest the bid. To use these
1. Put the indicator !MC OBJ_GLOB.ex4 in your ...experts/indicators folder
2. Put the script !MC Export Globals v1.ex4 in your experts/scripts folder
3. Fire up Metatrader.
4. Use Rectangle Reader to define the D1,W1,MN1 zones on each chart that you trade.
5. Put a copy of !MC OBJ_GLOB on each chart that you trade. (Indicator only, do not put the script on each chart). Leave the indicator on each chart as long as you wish to automatically update the spreadsheet.
6. Run the script (!MC Export Globals v1) on one of your charts.
That will generate a file named SD levels.csv in your ...experts/files folder.

Now open the spreadsheet. It was developed by converting Joe's latest ods spreadsheet into an Excel spreadsheet. It contains several macros that were written in VBA for Excel 2007. I am reasonably sure that it will run in any version of Excel 2007 or later, but have not tested it since I have only Excel 2007. Although it should run with any version of Windows, one of the macros reads the SD levels.csv file. In WIN 8 this is in a folder that has the WIN 8 security protection, so on my laptop WIN 8 denies access to Excel. I could move the file to a different folder and change the path in the spreadsheet (this is what I recommend that you do if you run into the same problem) however this file moving is not my idea of automatically updating the spreadsheet, so I just run in WIN XP on my desktop machine.

On the first page of the spreadsheet, under the stuff that was there in Joe's Spreadsheet I have written the directions for use. You must enable macros on the spreadsheet. Follow those directions. With this workboook you can add and delete symbols and change the name from e.g. EURUSD to EURUSDm, then just press the "Update sheet" button, and the macro will modify the DDE calls to reflect the appropriate symbol.

There are a lot of moving parts with this set of tools, and although IMHO the directions are very clear,Smile you may have troubles. The effort may prove too tough, and you may return to manual updating. That's your choice. If you persist you will find that whenever you change the D1, W1, or MN1 zones on your chart, all you need to do is run the script on one chart, and press the "Update Zones" button on the spreadsheet. The zones will be updated.

If you want the prices (the current bid, not the zone prices) to be updated every time they change, you need to set the Excel Options /Formulas / Calculation Options to "automatic". If you leave it at "Manual" the prices will be updated whenever you hit F9.

I know this seems complicated, but MT4 being what it is and Excel being what it is, it is really about as simple as possible.

If anyone speaks the ODS macro language, I am sure that they can convert the Excel macros to ODS macros. AN ODS spreadsheet might be useful for users that do not have Excel, or perhaps ODS can circumvent the WIN 8 file access system.

MadCow
Attached File(s)
File Type: xls Supply_Demand_ Curve_Total Auto.xls   1.3 MB | 1,389 downloads
File Type: ex4 !MC OBJ_GLOB.ex4   6 KB | 849 downloads
File Type: ex4 !MC Export Globals v1.ex4   5 KB | 850 downloads
  • #103
  • Oct 20, 2013 4:27am Oct 20, 2013 4:27am
Dear Alfonso,
Dear Joe,

Firstly I would like to thank you for your most sincere and friendly efforts in sharing your knowledge and experience which I am learning from.

All is deeply appreciated.

Perhaps, more important and valuable than what you are putting forth in terms of knowledge and experience is your acting as role models for the whole of humanity in terms of sharing and doing for the best of others.

This is what the world needs. SHARING & GIVING...

I will be doing my best to share my experiences and knowledge when it is my turn, but now I am in the process of learning your methodology.

Apologies if I am asking a simple question yet not well understood by me personally.

My question is:

a. trading D1/H1 (EURUSD)

Attached Image (click to enlarge)
Click to Enlarge Name: eurusdh1.png Size: 57 KB


b. whole of the S/D spreadsheet is updated every morning with discipline
c. trendlines drawn (automatic indicator)
d. S/D zones drawn (automatically, thanks to Insanity Industries)
e. S/D zone colour coding: LIME=FRESH DEMAND ZONE, PALE GREEN=NON FRESH DEMAND ZONE, RED=FRESH SUPPLY ZONE, PALE YELLOW=NON FRESH SUPPLY ZONE
f. S/D zone type coding: BLANK RECTANGLES=UPPER TIMEFRAME=D1, SOLID/FILLED RECTANGLES=LOWER TIMEFRAME=H1
g. D1% 233.1 (green), W1% 186.4 (red), MN% 429.4 (green)

Attached File(s)
File Type: pdf Supply_Demand_ Curve_Total Standard Final.pdf   29 KB | 1,208 downloads


WHAT WOULD BE YOUR PROPOSED STRATEGY?
Should I stick to D1/H1 and still wait for D1% to get red and become fit for going short or given W1% is 186.4% (please, also see the attached W1/H4 screenshot) and price is HIGH in the D1 non fresh supply zone and go short?

Attached Image (click to enlarge)
Click to Enlarge Name: eurusdh4.png Size: 53 KB


Thank you very much for your help.

Tek
  • #104
  • Oct 21, 2013 2:38am Oct 21, 2013 2:38am

Hi MadCow,


Thank you for your hard work in setting up and sharing this helpful tool.


Joe

  • #105
  • Oct 21, 2013 3:43am Oct 21, 2013 3:43am
Quoting ConcreteWind
Dear Alfonso, Dear Joe, Firstly I would like to thank you for your most sincere and friendly efforts in sharing your knowledge and experience which I am learning from. All is deeply appreciated. Perhaps, more important and valuable than what you are putting forth in terms of knowledge and experience is your acting as role models for the whole of humanity in terms of sharing and doing for the best of others. This is what the world needs. SHARING & GIVING... I will be doing my best to share my experiences and knowledge when it is my turn, but now...

Hi Tek,

Thank you for your kind words. I am just a humble student, and am still in the early stages of learning the methodology that Alfonso has presented on this thread and his other 2 threads. The Rectangle extender indicator for Metatrader 4 at http://www.forexfactory.com/showthread.php?t=428268and the Supply and demand Swing Trading Journal by Alfonso Moreno http://www.forexfactory.com/showthread.php?t=428204) where his detailed methodology is explained in post 1 page 1 with many trade examples throughout that thread.


I don’t trade the D1/H1 setup but I agree we are high in the curve in non fresh, used up areas. So shorts should be considered (unless the supply zones are taken out then the dynamics have changed), I would wait and look for current demand areas to be taken out and new fresh supply areas to be formed then I would consider a confirmation trade to go short. Also I am not trading today as tomorrow is a big news day (U.S. unemployment).


All the best,


Joe

  • #106
  • Oct 21, 2013 1:27pm Oct 21, 2013 1:27pm
Hello Joe,

Thank you for your reply.
I will be doing my best to share with you all in Alfonso's threads my plans and setups for trade so as to learn and be of use to others.

I am also not opening new trades before NFP.

All the best,

Tek
  • #107
  • Oct 23, 2013 11:00am Oct 23, 2013 11:00am
Hi Guys


REF: from the first post


CONDITIONS AND CELL HIGHLIGHTING

• SD level about to be hit. If current price is between 0 to 40 pips from hitting the proximal line of a SD level, the pip cell will be highlighted to yellow



Please could some one tell me the formula for high lighting cells in colour when price is at a certain distance away on Opencalc.

many thanks
  • #108
  • Oct 23, 2013 11:31pm Oct 23, 2013 11:31pm
There is a small bug in the indicator (!MC OBJ_GLOBAL) that I posted above. I am working on a fix and will post it soon. So far there have been no users, (at least I have seen no questions), so I think that there is no hurry. You will only see the bug when the bid is within one of the zones in control. In this case you must update the zones manually until I fix the bug.

MadCow
  • #109
  • Oct 24, 2013 1:49am Oct 24, 2013 1:49am
Quoting MadCow
Here are an indicator a script and an excel spreadsheet that automatically collect the D1, W1, and MN1 supply and demand zones nearest the bid. To use these 1. Put the indicator !MC OBJ_GLOB.ex4 in your ...experts/indicators folder 2. Put the script !MC Export Globals v1.ex4 in your experts/scripts folder 3. Fire up Metatrader. 4. Use Rectangle Reader to define the D1,W1,MN1 zones on each chart that you trade. 5. Put a copy of !MC OBJ_GLOB on each chart that you trade. (Indicator only, do not put the script on each chart). Leave the indicator on...
Thaaaaaaanks a lot for this tool and indicators, I just realized you had posted all this. Hadn't checked the spreadsheet thread for quiet sometime and it looks like there has been some movement over here, sorry I hadn't initially used excel because it gave me lots of problems, blocked my computer and so on. I googled and found that most users trying to use Excel and MT had the same problem, I hope it works now!

I will be checking what you and Joe have done, it looks like a great tool to have based on the original spreadsheet. Now the original spreadsheet looks like a little baby compared to this giant it's become!

Thank you! And Joe as well, I really appreciate it. I believe you did a great job!
Alfonso
Set and Forget supply and demand trading community
  • #110
  • Oct 24, 2013 1:59am Oct 24, 2013 1:59am
Quoting panoramia
I will be checking what you and Joe have done, it looks like a great tool to have based on the original spreadsheet.
Thanks also to you to have started this thread

It would be great to update your post #1 with all these new tools.
MT4/MT5 EAs/Indicators/Alerts coder
  • #111
  • Oct 24, 2013 9:15am Oct 24, 2013 9:15am
Quoting FerruFx
{quote} Thanks also to you to have started this thread It would be great to update your post #1 with all these new tools.
Thanks for your kind words! I will be testing the tools and will updated post #1 once it's done. MadCow and Fortuneteson have both done a GREAT and AWESOME job!
Alfonso
Set and Forget supply and demand trading community
  • #112
  • Oct 24, 2013 9:27am Oct 24, 2013 9:27am
Quoting panoramia
I will be testing the tools and will updated post #1 once it's done.
Great!
MT4/MT5 EAs/Indicators/Alerts coder
  • #113
  • Oct 24, 2013 3:53pm Oct 24, 2013 3:53pm
Quoting panoramia
{quote} Thaaaaaaanks a lot for this tool and indicators, I just realized you had posted all this. Hadn't checked the spreadsheet thread for quiet sometime and it looks like there has been some movement over here, sorry I hadn't initially used excel because it gave me lots of problems, blocked my computer and so on. I googled and found that most users trying to use Excel and MT had the same problem, I hope it works now! I will be checking what you and Joe have done, it looks like a great tool to have based on the original spreadsheet. Now the...

Thanks for the kind words, but they may not yet be deserved. There is a small bug in the indicator. I have fixed it and the correct version is attached. The previous indicator version got confused when the price was inside a zone. This one does not. Please let me know if anyone finds a bug.

While I was checking it out I found an interesting flaw in Metatrader. Suppose that you have an H4 chart of EURUSD. If you look at the proximal line of the daily supply zone using the hover label, you may see that the price is off by as much as 3 pips from the actual proximal price seen in EURUSD D1. It seems to be a random error that occurs. Just be aware that if you want the true value of a HTF zone, look in the HTF.

As I said above, this set of tools works well using Excel 2010 and Win XP. It does not work so well using WIN 8. A partial solution for me is to move the SD levels.csv file from inside the 'program files' folder to a folder outside. However, I have been unable to solve the problem with the DDE access to the terminal that updates prices on the spreadsheet. In a windows forum here http://answers.microsoft.com/en-us/w...d-1174e00773c0
a similar problem was solved by setting both the DDE server (Metatrader) and Excel to 'Run as administrator'. Of course you must set the 'tools/options/server' tab on metatrader to 'enable DDE', and allow the links to be updated in Excel.

Since there seems to be a problem with excel, I will look at the ods macro language to see if I can figure out how to write the required macros. That will probably take a while, since I flunked Latin in high school.Smile
MadCow
Attached File(s)
File Type: ex4 !MC OBJ_GLOB v1.ex4   5 KB | 559 downloads
  • #114
  • Oct 24, 2013 5:44pm Oct 24, 2013 5:44pm
Thanks Madcow
  • #115
  • Oct 25, 2013 2:04pm Oct 25, 2013 2:04pm
The indicator !MC OBJ_GLOB v1.ex4 that was posted last depends on some of the color settings in Rectangle Reader. It assumes that the settings

D1_upper_color = Yellow;
WK_upper_color = Yellow;

MN_upper_color = Orange;

have not been changed. If you have changed those, then v1 will fail. But fear not, in case you want to use other color settings, you can use the version posted below (v1a) That version is identical to v1, but allows you to match the color settings to whatever you use for rectangle reader.

It has been pointed out that I failed to include a critical instruction for the use of this indicator. The indicator runs at the start of every new bar. So if you are running it on a D1 chart, it will run only at the beginning of each day. However, you may manually draw a new level on the D1 chart at any time during the day. The indicator will not recognize the level until the next day, unless you re-initialize the indicator. So, any time that you draw a new level on the D1, Wk, or Mn TF's you should initialize the indicator. This can be done by changing time frames, or by doing anything that causes indicators to initialize.

MadCow
Attached File(s)
File Type: ex4 !MC OBJ_GLOB v1a.ex4   6 KB | 550 downloads
  • #116
  • Oct 27, 2013 11:53am Oct 27, 2013 11:53am
Quoting dh001
Hi Guys REF: from the first post CONDITIONS AND CELL HIGHLIGHTING • SD level about to be hit. If current price is between 0 to 40 pips from hitting the proximal line of a SD level, the pip cell will be highlighted to yellow Please could some one tell me the formula for high lighting cells in colour when price is at a certain distance away on Opencalc. many thanks
Hi dh001,
Sorry it has taken awhile to get back to you. When you open the spreadsheet. click on the cell in question for example: cell F10, then click format on the top row where the arrow is pointing. A box will apear, click on conditional formatting 14 down) and the box will appear with the formula there as shown in the image.

I hope this helps.

Joe
Attached Image (click to enlarge)
Click to Enlarge Name: Conditional Formatting.png Size: 239 KB
  • #117
  • Oct 27, 2013 12:00pm Oct 27, 2013 12:00pm
Quoting panoramia
{quote} Thanks for your kind words! I will be testing the tools and will updated post #1 once it's done. MadCow and Fortuneteson have both done a GREAT and AWESOME job! Alfonso
Thanks Alfonso,

I'd be happy to help with the update.

Joe
  • #118
  • Oct 28, 2013 1:37pm Oct 28, 2013 1:37pm
Quoting MadCow
{quote} Thanks for the kind words, but they may not yet be deserved. There is a small bug in the indicator. I have fixed it and the correct version is attached. The previous indicator version got confused when the price was inside a zone. This one does not. Please let me know if anyone finds a bug. While I was checking it out I found an interesting flaw in Metatrader. Suppose that you have an H4 chart of EURUSD. If you look at the proximal line of the daily supply zone using the hover label, you may see that the price is off by as much as 3 pips...

Hi MadCow,

I need some help with you spreadsheet and indicators. I followed the instructions to install and run the indicator/script. When I try to update the zones I receive an error "Path not found" I don't think I am imputing my Mt trader path correctly. Please see screenshots attached. Please help when you get the chance.

Thanks
April
Attached Images
  • #119
  • Oct 28, 2013 5:29pm Oct 28, 2013 5:29pm
From the instructions, you need to place the path to your metatrader in the box at : row 1, column 3. This is the pink box with "PATH" written inside it.
and the path to your metatrader should be :
C:\Program Files\FXCM Metatrader4\

Then hit update zones button on spreadsheet.

Please correct me if I am wrong.
It never gets easier, you just get better
  • #120
  • Oct 28, 2013 5:36pm Oct 28, 2013 5:36pm
Quoting Shabs19
From the instructions, you need to place the path to your metatrader in the box at : row 1, column 3. This is the pink box with \"PATH\" written inside it. and the path to your metatrader should be : C:\Program Files\FXCM Metatrader4\ Then hit update zones button on spreadsheet. Please correct me if I am wrong.
Hi Shabs19,

Thanks for the response, I already tried the path C:\Program Files\FXCM Metatrader4\ in the box and I still receive the same error.

April
0 traders viewing now