A production-ready Excel Add-In (.xlam) that provides a deterministic worksheet function returning official CME/NYMEX CL holiday dates for any given year.
The Add-In exposes a single worksheet function: CrudeOilHoliday(HolidayNumber, Year)
.
.
It returns either:
A valid Excel date
An Excel error value (#N/A, #VALUE!, #NUM!)
Function Parameters
Year: Four-digit integer in the range 1900–9999.
HolidayNumber: Integer in the range 1–14 identifying the holiday, as defined below.
1 New Year's Day
2 Martin Luther King Jr. Day (3rd Monday of January)
3 Presidents Day (3rd Monday of February)
4 Good Friday (Easter − 2 days)
5 Memorial Day (Last Monday of May)
6 Juneteenth (June 19, Year ≥ 2022)
7 Day Before Independence Day (conditional early close)
8 Independence Day (July 4, observed rule applied)
9 Labor Day (1st Monday of September)
10 Thanksgiving (4th Thursday of November)
11 Day After Thanksgiving
12 Christmas Eve (conditional early close)
13 Christmas Day (December 25, observed rule applied)
14 New Year's Eve (conditional early close)
A complete explanation of the Add-In is available in the GitHub repository.
A custom PowerLanguage indicator for MultiCharts .NET that visualizes two moving averages as a "cloud." The area between the two averages is filled with color that changes dynamically based on the relationship between the fast and slow averages (bullish or bearish). This provides a visual cue for trend direction and strength. V1
This is a refinement of my ever-popular dpDPO. (At least I think so!) This the Detrended Price Oscillator modified with a Twigg's MoneyFlow component. It's shows a slightly different view of what price is really doing. It works the same way as the DPO and can send signal lines into the price chart as the histogram crosses the zero line. It's retained the ADX-increasing colorization of the bar outline (made thicker or thinner by using the thickness property in the Data Series popup,) yellow in this screenshot. You'll notice how the dpVolXray beats the dpDPOT zero-line crossover by a bar or two, so between the two indicators you have a lot of information at your fingertips. As always, if you find a bug the work, let me know. If you find the dpDPOT useful, let others know by leaving a glowing comment!
Thanks,
Dave P.
Here's my small visual contribution to analyzing volume behavior. The subpanel shows "who's winning" in the volume fight and you have the option to paint the background of the subpanel and the chart. Signals are painted as one side takes over from the other; stars in this screenshot. The dpDPOT, a refined version of my dpDPO, shows how the colorization of the chart shows how volume leads price, since the background has changed color before the dpDPOT histogram has crossed its zero-line. It provides a 'heads-up' that trend or the micro-trend is changing. Works on just about everything I've tried it on.
Try it out. I find it useful. Maybe you will, too. As always, this is an educational effort to make all of us better traders. If you like it, leave a comment- it's the only way I know if any of this is helpful. If you find a bug in it, you can contact me through the forum.
Thanks,
Dave P.
UPDATE 8-11-2025: There was a small bug in the sound alerts which allowed the alert to sound off waaay too many times. Took care of it.
UPDATE 8-14-2025: Fixed a small sync issue with the signal and background painting.
Aren't you sick of the standard NT8 Skins ?!?! I created this simple skin, based on the Catppuccin Macchiato theme and style guide. The screenshot should show give you a good idea of the visuals. This is version 1.0.0.
This is only a skin for the NinjaTrader 8 application and has no relation to any indicators that are shown on screen.
This is my take on the linear regression line. I think I've made it a bit more useful, but you will be the judge of that. The plotted object 'line' has three parts: the linear regression line, the warning tab, and the shadow.
The actual linear regression line fills the area between the shadow or outside boundary lines. The 'tab' (see arrows in picture) is the linear regression line, but it's painted to reflect that price is closing in the opposite direction of the linear regression. In effect, this gives a 'heads-up!' warning that price is weakening in its trajectory. As you see in the picture, the tab appears when price is no longer in agreement with the direction of the LinReg. The shadow is simply the outside border of the full line. Change the color and/or thickness of it to better see the line on light or dark charts.
The indicator will load with a relatively thick line, but everything is is adjustable. The period is set to 50, but I use 25 on my charts. Again, you'll decide how you want to use it.
As always, Mr. Phelps, should you or any of your team be caught or killed, the secretary will disavow any knowlege of your actions.
Then again, you can always get me at [email protected].
Please leave a comment. It's the only way I know if anyone finds this stuff useful. Thank you.
Here's my take on the Bollinger/MACD indicator. I've added some bells and whistles and think it's an improvement, but what else would I say, right? I find it most useful when it overlays my dpDPO. The yellow dots on the zero line and the white segments on the midline reflect areas in the data where 'flatness' is happening. The degree of flatness is a user input. Watch for the usual squeeze behavior and where it is happening. Validate what the BMD is telling you with what the DPO is doing in the background. The BMD and DPO are justified on opposite sides and I manually sync up the zero lines when NT8 doesn't get it right.
For example, look at 'A' in the screen shot. The BMD is just coming out of a squeeze and the midline has gone from white (flat) to red. The BMD's MACD line has crossed down through the white flat zone. (Red line crossing down through white segment.) We have the red vertical DPO signal line indicating the DPO has gone negative. Finally, we have the dpQGP giving a short signal coming out of its flat zone. Of course, even with all these pieces falling into place, the move might only be a couple ticks, so that's where your experience and 'gut' tell you what to do. The point of the effort is that it gives us an edge over throwing a dart. Just about everything visual is a user-input so you may color code as you wish. I've also include my default template just to speed things along.
Good luck with it. As always, comments are always welcome. You can contact me directly at [email protected].
This simple indie uses 'added data' in the code.. Just input the 'data series' you want to
study in relation to the 30min BB's and it will plot values (estimates) of where the 30 min
BB 'Upper' and 'Lower' will plot on the hour and half-hour that is coming up..
These bands will also show you the median value of the current 30minute study which I
find very useful to form a "bias"..
In general : if price is below the 'Lower' plotted 30min BB (30 min chart) AND below the
'Lower' (already plotted 'fulcrum') 10 min BollingerPro (10 min data on any tick or volume
series chart) then price is in oversold territory ... at least its below the number of SD's you're
studying AND what's projected..
**Important : This indicator will stop working on Rollover.. .. The 'added data' in the code
needs to be updated to the current Sept, Dec, Mar, June series AND underlying !.. i.e. if you
want to study ES, the code has to be changed to use ES as 'added data'.. It's very simple to
do - the 'added data' lines are 70 and 71.. (try changing them yourself - you'll feel like a coder)
Note: I've updated the code to a 'Source Code' version (I hope).. I also hope it works as a
version everyone can access and change as needed, as I had hoped to share originally..
** I'd like to include the link for a new 'source code' version of BollingerPro now 'BollingerProChof'
I wasn't aware I had uploaded a .dll version. I apologize and bear responsibility for what got
posted/shared.. …
I attached a couple more pics to explain 'Ellipse #'s 1 & 2' in the pic attached here..
I've penned specifics on data series and some tips you 'May' use.. "Only trade with money
you can afford to lose" haha - seriously I hope it all helps.. Chof
February 26th, 2026 03:32 PM Shivaya This really looks like it will help in eliminating my getting in too early at tops and bottoms. Thanks. Well done!
February 12th, 2026 01:39 AM BoltTrader Thank you!
December 17th, 2025 12:49 AM TakingStock12 PLEASE NOTE ALL: I believe this indicator re-paints and so gives false signals/info in real-time. I know it shows re-pai
nting on my charts -- got me quite excited at first for its apparent ability to pinpoint safe entry at turning points bu
t it turns out many of those "signals" were due to re-painting, changing the past. Tread with care on this one.
October 23rd, 2025 02:56 AM Belly Thank you very much
October 23rd, 2025 02:55 AM Belly
August 25th, 2025 09:15 PM ValLiant great tool thanks
October 30th, 2025 05:05 PM EFFEM Hi! I wanted to ask for what settings do you use for this and how did you get the colored backgrounds to line up on all