Supply and demand daily and weekly levels spreadsheet | Page 9 | 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

  • #161
  • Nov 22, 2013 7:14am Nov 22, 2013 7:14am
Quoting MadCow
{quote} Hi Reacto, It might be that open office is a better solution, though I am not sure if anyone has tested it retrieving data from MT4 in Win 8. Joe uses Vista. Don't know about Alfonso. My problem is that there is no simple way to translate Excel macros to OO macros. To write the macro in OO I would have to learn a new language, and I am reluctant to spend the time when Excel works just fine. There are several possible problems with your set up. 1. You may not have turned on the DDE server in your metatrader. Use 'tools/options/server' to...
Hi April, here it is in zip

With regard to the HTF direction, I collar them manually, only the text high or low in the curve is done automatic. To ad this it would just be a matter of inserting some columns, but I don't know whether that would mess up the rest of the SS
Attached File(s)
File Type: zip Supply_Demand_ Auto_Robert.zip   234 KB | 498 downloads
  • #162
  • Nov 22, 2013 7:30am Nov 22, 2013 7:30am
Quoting MadCow
{quote} Hi again, Where will the data on the higher TF direction come from? I have never seen this from Rectangle Reader, or any other indicator that we use. I think you will have to provide that data manually. If you do that, what is the use of automating the spreadsheet? On second thought, if you draw trend lines on the HTF charts to show direction, it might be possible to modify a couple of indicators to capture the slope of the trend line and export it to the SD_levels file. A lot of work, but if there is reason enough (enough people want it,...
Hi MadCow,

A response to your possible causes:

There are several possible problems with your set up.
1. You may not have turned on the DDE server in your metatrader. Use 'tools/options/server' to turn on DDE. DDE is on, OO is recieving data
2. You are operating with the metatrader in the program files folder in Win 8. If this is the case you need to either move the terminal outside the program files, or take steps to inform Win 8 that it is OK for a DDE server to send/recieve messages from within the program files directory. I don't know how to do the latter, so I have done the former. Perhaps April or someone more familiar with Win 8 can help here. I'm using Win 7, does your remark apply for this too?
3. You may not have enabled the spreadsheet to use external links. Use the Excel Options panel to do this. I did get the question, and I have OKed it
4. You have changed to xlsm from xls. I know that is what Excel suggests, but I do not know how Win 8 and xlsm interact. I know that the xls file works fine with Win XP. (xlsm is supposedly just xlsx with macros enabled, but I bet there are other subtle differences). As I said, I use Win 7, but got the same remark you dirscirbe from Windows. In order to use the macro's I had to save as xlsm

So what would you suggest would be the best way forward for me?
  • #163
  • Nov 22, 2013 7:48am Nov 22, 2013 7:48am
Hi MadCow,

Quote:
While I agree that Metatrader is difficult to deal with sometimes, I don't think it is giving bad info, I think it is we mortals that are interpreting the data incorrectly. I have never had any trouble exporting account data from Metatrader. If you right click the account window you can save as report or as detailed report. That will be an htm file that you can export directly into excel. All the numbers will be correct.

It's clear to me I know less about this then you do, so maybe I have been doing something wrong. April has my copy of the spreadsheet now, so she will be able to tell what has been going on. Before I have made a DDE connection with Excel, in a file of my own, and the same formula worked for some pairs, but it did not for DAX DJI etc. those came up as text instead of numbers.

You say one can export the detailed report from MT4 to Excel, how do I go about that routine? Right clicking the file does not give me that option, and I looked in Excel if I could import htm, but did not find this format. Can you explain how it's done please? I hate typing over the report in Excel, importing in such a way that I have numbers in Excel would be great.
  • #164
  • Nov 22, 2013 8:05am Nov 22, 2013 8:05am
Hi Madcow and April,

Quote:
As to spreadsheet modifications. I derived this spreadsheet by using OO to export the ods spreadsheet as an xls sheet. So the sheet is exactly as Joe originally made it. I have no reason to change it. If you and April see a way to make things better, please do so and post the result. I will modify the macros to match the sheet. If you need some help programming a modified sheet, I will try to help there too, but I am not an Excel expert, so make the mods simple. Hopefully we need do this only once, so be careful that you ask for the whole pie.

Alfonso has the HT-direction added recently as a separate file on the S&F website. I like to have one view to tell me direction and hight in the curve on all combo's, so I inserted the columns, put in the formula to place the text high / low in the curve, based on the corresponding percentage column, and collar the field manually. Since it's a task I only have to do once a week, for the most part, automating it would be to much work in comparison with the benefit it would give.

If we can get the SS working as it is that would be great, with the columns inserted as mentioned above even greater, and something to dream about would be having the levels update automaticly
  • #165
  • Nov 22, 2013 10:44am Nov 22, 2013 10:44am
Why not code all of this in MT4?

I can easily do it to be honest.

All it would take is to blank the background, set it into a color and then draw labels and stuff.
To refresh all that it the only thing you would need to do is to wait or what ever.
Even notifications could be sent to check for levels.

Seems that everybody is giving, here so fill me in and I will do it.
  • #166
  • Nov 22, 2013 12:00pm Nov 22, 2013 12:00pm
Quoting Reacto
{quote} Hi April, here it is in zip With regard to the HTF direction, I collar them manually, only the text high or low in the curve is done automatic. To ad this it would just be a matter of inserting some columns, but I don't know whether that would mess up the rest of the SS {file}
Hi Reacto.

I think the issue is with the .xlsm format. As soon as I converted mine to that format everything got messed up. I had to go back to the original .xls format. Attached is my spreadsheet. I changed the location of my MT4 to yours. Please test it out to see if it is working for you. Also. Make sure you ran the script again before you update zones. The sheet will not update newly painted zones unless I ran the script again. Let me know.

Thanks
April
Attached File(s)
File Type: zip Supply_Demand_ Curve_Total Auto-Robert.zip   169 KB | 530 downloads
  • #167
  • Nov 22, 2013 12:02pm Nov 22, 2013 12:02pm
Quoting aprilnparker
{quote} Hi Reacto. I think the issue is with the .xlsm format. As soon as I converted mine to that format everything got messed up. I had to go back to the original .xls format. Attached is my spreadsheet. I changed the location of my MT4 to yours. Please test it out to see if it is working for you. Also. Make sure you ran the script again before you update zones. The sheet will not update newly painted zones unless I ran the script again. Let me know. Thanks April {file}
also, whatever you do, DO NOT SAVE the spreadsheet back to xlsm format. No matter what Excel tells you...it's lying.
  • #168
  • Nov 22, 2013 12:04pm Nov 22, 2013 12:04pm
Quoting bruce_loco
Why not code all of this in MT4? I can easily do it to be honest. All it would take is to blank the background, set it into a color and then draw labels and stuff. To refresh all that it the only thing you would need to do is to wait or what ever. Even notifications could be sent to check for levels. Seems that everybody is giving, here so fill me in and I will do it.
Hi Bruce,

That sound great, Although I a not sure what that would look like? I have never heard of anything like that before. The more automated the better.

April
  • #169
  • Nov 22, 2013 12:18pm Nov 22, 2013 12:18pm
Quoting Reacto
Hi Madcow and April, Quote: As to spreadsheet modifications. I derived this spreadsheet by using OO to export the ods spreadsheet as an xls sheet. So the sheet is exactly as Joe originally made it. I have no reason to change it. If you and April see a way to make things better, please do so and post the result. I will modify the macros to match the sheet. If you need some help programming a modified sheet, I will try to help there too, but I am not an Excel expert, so make the mods simple. Hopefully we need do this only once, so be careful that...
Hi Reacto,

Yes I saw the HT-direction spreadsheet, for simplicity I just took a screenshot of it, cropped it and inserted it as a picture in my spreadsheet so I can look at everything in one shot. It actually works quite well for me. When Alfonso updates the sheet I will just take another screenshot and insert it into my spreadsheet. For now, that might just be the easiest.

April
  • #170
  • Edited 12:41pm Nov 22, 2013 12:27pm | Edited 12:41pm
Quoting aprilnparker
{quote} Hi Bruce, That sound great, Although I a not sure what that would look like? I have never heard of anything like that before. The more automated the better. April
I just have to understand needs to be visible.
There are far too many variables in the spreadsheet.
And it probably has to be split into a period viewer, so 3 windows would be loaded with the indicator using different time frames.
Or maybe doing:


WK SUPPLY PIPS D1 SUPPLY PIPS CURRENT PIPS D1 DEMAND PIPS WK DEMAND

The Periods seen could be done on a parameter level:
ie:
PERIODS : "WK,MN,D1"
And it would start from the middle outwards.
As of yet I do not know what needs to be seen

Also, where are the distal/proximal values taken from?
Is this something that can be extracted from the supply_demand_zones indicator?
  • #171
  • Nov 22, 2013 2:22pm Nov 22, 2013 2:22pm
Quoting bruce_loco
{quote} I just have to understand needs to be visible. There are far too many variables in the spreadsheet. And it probably has to be split into a period viewer, so 3 windows would be loaded with the indicator using different time frames. Or maybe doing: WK SUPPLY PIPS D1 SUPPLY PIPS CURRENT PIPS D1 DEMAND PIPS WK DEMAND The Periods seen could be done on a parameter level: ie: PERIODS : "WK,MN,D1" And it would start from the middle outwards. As of yet I do not know what needs to be seen Also, where are the distal/proximal values taken from? Is this...
Hi Bruce,

Madcow's original post here:

http://www.forexfactory.com/showthre...09#post7037309

This would tell you how we are pulling the distal and proximal numbers. on Alfonso's original spreadsheet, you have to enter them manually. I will let Reacto respond to your post; as he wanted to add the ability to detect where we are on the curve.

Reacto - Can you show us a screenshot of the added columns you made so we can get an idea of how we can further automate the spreadsheet?

April
  • #172
  • Nov 22, 2013 2:53pm Nov 22, 2013 2:53pm
Quoting aprilnparker
{quote} Hi Bruce, Madcow's original post here: http://www.forexfactory.com/showthre...09#post7037309 This would tell you how we are pulling the distal and proximal numbers. on Alfonso's original spreadsheet, you have to enter them manually. I will let Reacto respond to your post; as he wanted to add the ability to detect where we are on the curve. Reacto - Can you show us a screenshot of the added columns you made so we can get an idea of how we can further automate the spreadsheet? April
Hi April

Based on what I have seen, supply and demand are based on a candle range being large by x% at a given point in time and not declining to the initial values of that candle range which is about 2-4 candles or so.
The zone itself is the candle preceding the movement.

And as I could tell, there is an indicator that draws this in this thread:

http://www.forexfactory.com/showthread.php?t=428204

Strangely it only draws the zones in H1 and lower
  • #173
  • Nov 22, 2013 3:59pm Nov 22, 2013 3:59pm
Quoting bruce_loco
{quote} Hi April Based on what I have seen, supply and demand are based on a candle range being large by x% at a given point in time and not declining to the initial values of that candle range which is about 2-4 candles or so. The zone itself is the candle preceding the movement. And as I could tell, there is an indicator that draws this in this thread: http://www.forexfactory.com/showthread.php?t=428204 Strangely it only draws the zones in H1 and lower
Yep, I use that indicator. Not sure why it only draws for H1 or lower but learning to draw the levels manually is good practice.
  • #174
  • Nov 22, 2013 7:08pm Nov 22, 2013 7:08pm
Quoting bruce_loco
{quote} Hi April Based on what I have seen, supply and demand are based on a candle range being large by x% at a given point in time and not declining to the initial values of that candle range which is about 2-4 candles or so. The zone itself is the candle preceding the movement. And as I could tell, there is an indicator that draws this in this thread: http://www.forexfactory.com/showthread.php?t=428204 Strangely it only draws the zones in H1 and lower



Thanks for offering Bruce. To which indicator do you refer? I thought I had seen them all on that thread, and they all work on any TF.

The problem with trying to automate the zone definition is that everyone draws slightly different zones. The Sup Dep indicator draws zones on any TF using a standard zig zag to find swing high and low points. That is where most of the zones originate. It finds the distal lines just fine, but it does not find the proximal lines as well. Also it does not find the zones at 'CP' points. There is a Support/Resistance indicator that also finds zones, but it finds way too many. Furthermore, the rules that describe which zones are used must be considered, yet they are sort of fuzzy rules.

So unless you write an indicator to find the zones, you must rely on the zones found manually. These are 'documented' by Rectangle Reader as Rectangle, trendline, and text objects. So you can use these objects to to derive the info used to fill out the spread sheet. Unfortunately Rectangle reader does not name the objects with the symbol in the name, so in truth you must add an indicator to each chart that will read the objects and write global vars with names that include the symbols. Then you can automate the spreadsheet from a single chart using a single indicator.

That said, you may have difficulty finding a common definition of what vars should be on the display. Perhaps April or someone that uses the spread sheet could define which columns are important.

I have been working on automatic drawing of the SD zones for a while with great frustration. If you want more info, PM me. This thread does not seem the place for a tech discussion.

MadCow
  • #175
  • Nov 23, 2013 2:08am Nov 23, 2013 2:08am
Quoting bruce_loco
{quote} Hi April Based on what I have seen, supply and demand are based on a candle range being large by x% at a given point in time and not declining to the initial values of that candle range which is about 2-4 candles or so. The zone itself is the candle preceding the movement. And as I could tell, there is an indicator that draws this in this thread: http://www.forexfactory.com/showthread.php?t=428204 Strangely it only draws the zones in H1 and lower
If you referred to Supply_Demand_Zones indicator, then it is able to draw zones on any timeframe. By default, it is set to visualize them on H1 and lower. Check the settings.
  • #176
  • Nov 23, 2013 6:30am Nov 23, 2013 6:30am
Quoting Carousel46
{quote} If you referred to Supply_Demand_Zones indicator, then it is able to draw zones on any timeframe. By default, it is set to visualize them on H1 and lower. Check the settings.
Hi Carousel

I changed the show in X timeframe from false to true and still no cigar.
Any hints? or is there more than on version of the indicator?
  • #177
  • Nov 23, 2013 7:04am Nov 23, 2013 7:04am
Quoting MadCow
Just so you all know. The 'Update Zones' macro works as follows: Gets the symbol in the first column Reads the ...expertsfilesSD levels.csv file to find the symbol that matches the symbol in the row Gets the proximal line data from the file Fills in the cells that use this data, e.g. cell(5,7) uses the daily proximal supply line. It repeats that operation for every symbol in the first column. That is all that it does. It should not cause the price columns to update. This macro requires that you have enabled macro's for this spreadsheet. It may require...
thanks MadCow
  • #178
  • Nov 23, 2013 9:14am Nov 23, 2013 9:14am
Quoting aprilnparker
{quote} Hi Reacto. I think the issue is with the .xlsm format. As soon as I converted mine to that format everything got messed up. I had to go back to the original .xls format. Attached is my spreadsheet. I changed the location of my MT4 to yours. Please test it out to see if it is working for you. Also. Make sure you ran the script again before you update zones. The sheet will not update newly painted zones unless I ran the script again. Let me know. Thanks April {file}
I'll give it a try April, thanks
  • #179
  • Nov 23, 2013 9:15am Nov 23, 2013 9:15am
Quoting bruce_loco
{quote} Hi April Based on what I have seen, supply and demand are based on a candle range being large by x% at a given point in time and not declining to the initial values of that candle range which is about 2-4 candles or so. The zone itself is the candle preceding the movement. And as I could tell, there is an indicator that draws this in this thread: http://www.forexfactory.com/showthread.php?t=428204 Strangely it only draws the zones in H1 and lower

Hi Bruce,

Would be interesting to see if a different approach might help making things easier still
  • #180
  • Nov 23, 2013 2:56pm Nov 23, 2013 2:56pm
Quoting Reacto
{quote} Hi Bruce, Would be interesting to see if a different approach might help making things easier still
I'm still pretty new to all of these concepts to be honest.
I got interested by looking at Sam Seiden's webminars and now I got here.
I spent already ages looking at trix, thv, moving averages, cycles, ocean theory etc
However, they really don't make sense to me, it is like people wanting to see what they want to see instead of what is happening.

There is a PDF around called "BS trading - Buying and selling no bull" which summarizes Sam's approach. Because going through the webminars is like chewing glass, so much wasted time some times.
This led me to this thread which is based on the same principles.
Who owns the supply demand zones indicator? anyone on this thread?
1 trader viewing now