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

  • #181
  • Nov 23, 2013 3:36pm Nov 23, 2013 3:36pm
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

I found a supply demand indicator with source that appears to be functioning at other timeframes:

http://www.forexfactory.com/showthre...30#post5965130

Appears to be the same supply_demand_zones indicator. This I can already use with to identify the levels for putting the spreadsheet.
  • #182
  • Nov 23, 2013 11:47pm Nov 23, 2013 11:47pm
Quoting bruce_loco
{quote} 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....
Chewing glass is actually easier.

The indicator is actually from Insanity Industries, developed there as II_SupDem.mq4. It is free, so here it is. I think the LOGO and HUD have been disabled in the version on the thread. It can be improved.

Think about the supply demand model. Is it more realistic to expect demand from years ago to be playing a role, or to expect a moving average crossover based on price action in the last few days to predict good entries. I have a real problem with either because the market is not stationary ... but, Alfonso has developed a set of rules based on empirical observation that seem to work well. The supply demand model helps to understand his rules, so whether it is based on true supply and demand or based on the psychology of the market is not important. As a model it works. Any indicators that find zones need to follow his rules, so Sup Dem needs modification.

I will respond to your PM soon.


MadCow
Attached File(s)
File Type: mq4 II_SupDem.mq4   29 KB | 657 downloads
  • #183
  • Nov 24, 2013 6:39am Nov 24, 2013 6:39am
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}
Hi April,

I tried it again, with the sheet you send me, followed the steps as explained, but no joy. Left the sheet as xls, and allowed script in Excel.

As you can see, there are still some fields with text instead of numbers, it's those with "#WAARDE#", and a lot of other fields like price are not presented correctly.

Can you tell me how I can get my columns back to letters instead of numbers?

It's to bad it doesn't work in my pc, I would like to have this sheet automated.
Attached Image (click to enlarge)
Click to Enlarge Name: Auto_spreadsheet_Robert.png Size: 214 KB
Attached File(s)
File Type: zip Supply_Demand_ Curve_Total Auto-Robert.zip   172 KB | 868 downloads
  • #184
  • Nov 24, 2013 6:48am Nov 24, 2013 6:48am
Quoting Reacto
{quote} Can you tell me how I can get my columns back to letters instead of numbers? {image} {file}
To turn R1C1 reference style on or off

  1. Click Options on the Tools menu, and then click the General tab.
  2. Under Settings, select or clear the R1C1 reference style check box.

  • #185
  • Nov 25, 2013 12:35am Nov 25, 2013 12:35am
Quoting Carousel46
{quote} To turn R1C1 reference style on or off Click Options on the Tools menu, and then click the General tab. Under Settings, select or clear the R1C1 reference style check box.
Thanks Carousel46, it's solved.
I'm using Office 2010 and there it is placed under Formulas
  • #186
  • Nov 26, 2013 6:44pm Nov 26, 2013 6:44pm
Quoting Reacto
{quote} Thanks Carousel46, it's solved. I'm using Office 2010 and there it is placed under Formulas

Awesome! Glad to see it is solved!
  • #187
  • Nov 27, 2013 12:23am Nov 27, 2013 12:23am
Quoting aprilnparker
{quote} Awesome! Glad to see it is solved!

Hi April, It's not the SS working that's solved, just the columns are back to letters instead of numbers

But I might have found out where the problem comes from. I think it's the separators decimal and thousands, for Europe they should be "," for decimals, and a "." for thousands. Can you or MadCow fix this?
  • #188
  • Nov 27, 2013 9:19am Nov 27, 2013 9:19am
Quoting Reacto
{quote} Hi April, It's not the SS working that's solved, just the columns are back to letters instead of numbers But I might have found out where the problem comes from. I think it's the separators decimal and thousands, for Europe they should be "," for decimals, and a "." for thousands. Can you or MadCow fix this?
Hi Reacto.

It is just a setting in Excel

Change the separator for thousands and decimals
By default, Microsoft Excel uses the system separators that are defined in the regional settings in Control Panel. If you sometimes need to display numbers with different separators for thousands or decimals, you can temporarily replace the system separators with custom separators.

  1. On the Tools menu, click Options.
  2. On the International tab, under Number Handling, clear the Use system separators check box.
  3. Type new separators in the Decimal separator and Thousands separator boxes.

Tip When you want to use the system separators again, select the the Use system separators check box.

http://office.microsoft.com/en-us/ex...003089676.aspx

April

  • #189
  • Edited 12:46pm Nov 27, 2013 12:11pm | Edited 12:46pm
Hello Traders,

I wanted to post an updated version of Madcow's and Fortunateson's spreadsheet. I just make a few changes to help others so they don't have to dig through this thread to find the indicators and answers to problems they might be having.

Changes I made:

1. On Sheet 1 I added Madcow's instructions on where to place the indicators as mentioned in forum http://www.forexfactory.com/showthre...09#post7037309
I also embedded Madcow's indicators on that sheet in a .zip file.

2. I renamed the tabs to better understand what they all do and re-organized the order.

* MOST IMPORTANT
3. I added another tab called "Troubleshooting" with a list of the issues I have seen here on the forum that have been solved. I think this will help new people, who download this awesome spreadsheet, fix the common issues on their own without have to browse through pages of this forum for answers or just re-posting the same questions. So far I have seen 5 issues come up that we, as a community, provided answers. Please add more to this sheet if I missed any or you fixed some issues yourself without posting it here.

4. I made the format a little easier to read, in my opinion, added borders, etc.

5. I also added several more currencies to the spreadsheet that I trade.
*CADCHF
* EURCHF
*NZDCAD
*AUDCHF
*NZDJPY
*USDOLLAR

I hope this helps others. Let me know if you find or want to enhance the spreadsheet further.

Thanks
April
Attached File(s)
File Type: zip Supply_Demand_ Curve_Total Auto with indicators attached.zip   196 KB | 1,077 downloads
  • #190
  • Nov 28, 2013 12:24am Nov 28, 2013 12:24am
Quoting aprilnparker
Hello Traders, I wanted to post an updated version of Madcow's and Fortunateson's spreadsheet. I just make a few changes to help others so they don't have to dig through this thread to find the indicators and answers to problems they might be having. Changes I made: 1. On Sheet 1 I added Madcow's instructions on where to place the indicators as mentioned in forum http://www.forexfactory.com/showthre...09#post7037309 I also embedded Madcow's indicators on that sheet in a...

Great April, I'm going to give it another try with the seperators adjusted this time.

Thanks
  • #191
  • Nov 28, 2013 12:02pm Nov 28, 2013 12:02pm
Quoting Reacto
{quote} Great April, I'm going to give it another try with the seperators adjusted this time. Thanks
Great! let me know how it goes and if you need help.

April
  • #192
  • Edited Dec 1, 2013 3:19am Nov 30, 2013 4:06pm | Edited Dec 1, 2013 3:19am

Hi Everyone,


Great to see all of the activity and advancements made on the spreadsheet. I started a new job recently so I haven’t been around much lately but I am hoping that will change soon once I settle in. Also I am planning to upgrade to Windows 7 if my computer has the right hardware installed so I can get the spreadsheet to work in excel.


In the past, when working with a different charting software provider, I asked why they didn’t have any trendline indicators, their response was too difficult and subjective, because the trendlines’ angle would change as you expanded, compressed or manipulated the chart. So which would be the correct value to determine the proper angle of the trendline? But another charting software provider did have a trendline indicator so who knows. Just mentioning this as food for thought incase you want to add trendline angles to the spreadsheet.


If possible, I have an idea for an improvement to the spreadsheet. Please bear with me as I’m not sure if I’m explaining this properly.


Using Aprils’ Spreadsheet (from post 189)-- On the SD Levels sheet --setup a block for the 4 hour and 1 hour like we are using for the monthly, weekly and daily bringing in the proximal and distal lines from MT4. Tag them somehow (as well as the daily) so we know what timeframe we are using for the padding and wiggle room calculations (do this in a way so we don’t have to manually enter the timeframe on the Open Positions sheet). Now we have the curve in control and the trade timeframe data all in one place updating in excel for the 3 type of curve traders.


Once this is done maybe then set up a column where you can manually enter a 0 for no potential trade a 1 for a potential long and a 2 for a potential short (maybe down the road we can automate/improve this by using the trade timeframe rectangle reader colors and certain conditions to confirm or deny a levels trade possibility).


Since only the 1s’ and 2s’ matter can we run some type of “sort” that pulls the 1s’ and 2s’ to the Calc2 sheet where it pulls the symbol, timeframe tag, proximal and distal lines where it still does all the calculations for the longs and shorts. This way automating most of the work so then we only have the need for the Open Positions sheet for target data (which can probably also be automated depending on your exit strategy).


All of this is beyond my limited skills so I’m not sure if it is possible or even makes sense for that matter. Please let me know if it is, or if not and then I can better explain what I am thinking. I’m also sure there are more things to consider. I just wanted to start the dialog to see if any of this can be done.


Please bear with me if I am slow to respond, I will in time, I just have some adjustments to make with all that has been happening lately.

Also on a quick glance it looks like some of the cells/formulas aren’t working on the position spreadsheet. It could be me because I don’t have the spreadsheet running yet. I’ll look at them once I upgrade and get up to speed.


I hope all is well. Trade well!!


Joe

  • #193
  • Dec 10, 2013 4:51pm Dec 10, 2013 4:51pm
hi Madcow,

thank you for creating the indicator for the spreadsheet. Can you please let us know whether we can add the rectangle reader's reading for H4 and H1 as well. if we can have these values as well in the spreadsheet that will be very helpful..

thanks,

raj
  • #194
  • Jan 19, 2014 12:56pm Jan 19, 2014 12:56pm
Quoting rajnew
hi Madcow, thank you for creating the indicator for the spreadsheet. Can you please let us know whether we can add the rectangle reader's reading for H4 and H1 as well. if we can have these values as well in the spreadsheet that will be very helpful.. thanks, raj
Hi Rajnew,

I am sure it is possible but, sadly, the person that created the indicator passed away. I don't know mt4 code to modify the indicator. I am currently learning but it is going to take awhile as I need to know excel and mt4 codes.

April
  • #195
  • Jan 19, 2014 1:01pm Jan 19, 2014 1:01pm
*MINOR UPDATE on SPREADSHEET**

I made some minor changes on the spreadsheet that I wanted to share. First, I changed the color codes for the percentages, when price is in the middle of the curve between 45-60% the font color will be black. When prices is there just dont trade...wait for prices to move above or below. Also, I added another comment on the troubleshooting tab with a pic explaining why some pairs sd levels are not being pulled correctly from the indicator. Most of the pairs get pulled just fine but one or two just don't read. I found out why but the issue is with the rectangle reader.

*Note, the weekly proximal and distal lines are hidden as well as the D1 and Weekly percentages, just highlight the entire spreadsheet, right-click, and unhide.

Thanks
April
Attached File(s)
File Type: zip Supply_Demand_ Curve_Total-MONTHLY ONLY.zip   213 KB | 769 downloads
  • #196
  • Jan 25, 2014 1:02am Jan 25, 2014 1:02am
I am writting this Little message on the thread to inform you that MadCow (Stan) will not be able to continue with the great work he's been doing, he has sadly passed away. My most sincere condolences to his son and family. His mind

People over here did not know much about what he was trying to achieve working together with me, amongst other things an algorithm to detect different types of CP patterns and other things. In the past he worked in important projects, he was amongst other things one of the creators of the JPG format.

He created a couple of improvements for the auto-SD indicator but he couldn't finnish a few others we had agreed upon. We wanted to create a fuzz factor for the auto-sd levels so that the levels were not so strict, there would be a "fuzz" factor or multiplier and a sort of intelligent algorithm that would learn from past valid CP patterns fed into the system. By having this auto intelligent system and a fuzz factor, the padding and wiggle room would be much more flexible depending on what the algorithm had learnt and what had passed in similar scenarios in the past.

This was just the beginning of some of the ideas we had been discussing together. As you can see, Stan had a great mind. My ideas are nothing if a greater mind is behind them to make them real. All I can say is that I had a great privilege to be in contact for Stan (MadCow), even though it was only for work matters.

Looking forward to meeting you in the great beyond!
Alfonso
Set and Forget supply and demand trading community
  • #197
  • Jan 25, 2014 5:51am Jan 25, 2014 5:51am
So sorry to hear this sad news. May he rest in peace.
  • #198
  • Jan 25, 2014 7:34am Jan 25, 2014 7:34am
Quoting panoramia
I am writting this Little message on the thread to inform you that MadCow (Stan) will not be able to continue with the great work he's been doing, he has sadly passed away. My most sincere condolences to his son and family.
I also would like to offer my condolences to his family.
It never gets easier, you just get better
  • #199
  • Jan 28, 2014 11:14am Jan 28, 2014 11:14am
Quoting aprilnparker
*MINOR UPDATE on SPREADSHEET** I made some minor changes on the spreadsheet that I wanted to share. First, I changed the color codes for the percentages, when price is in the middle of the curve between 45-60% the font color will be black. When prices is there just dont trade...wait for prices to move above or below. Also, I added another comment on the troubleshooting tab with a pic explaining why some pairs sd levels are not being pulled correctly from the indicator. Most of the pairs get pulled just fine but one or two just don't read. I found...

**IMPORTANT SPREADSHEET UPDATE for the new version of MT4 released**

I updated my Meta Trader to version 4, Build 574 released on Jan. 10th 2014. If anyone has updated their MT4 client the old spreadsheet "Update Zones" button will not work. With this build release MT4 has re-organized the file structure within the installation folder. Before the sd levels.csv created by the indicator would reside in Meta Trader 4\experts\files but now that has changed to Meta Trader 4\MQL4\Files. The old spreadsheet cannot locate the csv file. I edited the macro that MadCow created to incorporate the new location. I have it working on my side. I attached the update spreadsheet below. Please test out and let me know it is universally working.

If you have NOT updated your Meta Trader then don't use this spreadsheet. The old one will work fine.

Thanks
April
Attached File(s)
File Type: zip Supply_Demand_ Curve_Auto_Spreadsheet MT4 Update.zip   214 KB | 1,161 downloads
  • #200
  • Feb 18, 2014 2:41am Feb 18, 2014 2:41am
Quoting panoramia
I am writting this Little message on the thread to inform you that MadCow (Stan) will not be able to continue with the great work he's been doing, he has sadly passed away. My most sincere condolences to his son and family. His mind People over here did not know much about what he was trying to achieve working together with me, amongst other things an algorithm to detect different types of CP patterns and other things. In the past he worked in important projects, he was amongst other things one of the creators of the JPG format. He created a couple...
this sad a news.. he was very helpful in coding.
Pray Lord to give courage to his family.
Hukam
0 traders viewing now