Chart Update and Planet S/R
posted by XLTrader at 4:00 PM
XLTrader 's Blog
Thursday, July 30, 2009
Saturday, June 27, 2009
XLMidas S/R and Parallel offset curves
Hello,
This week's screencast shows how to prepare a Midas chart for the S&P 500. Midas is the acronym for the late Dr. Paul Levine's Market Interpretation/Data Analysis System. I cover S/R (support or resistance) curves and the parallel offset. These two tools form the backbone of the extremely powerful Midas method. In another screencast I'll discuss Topfinder, Midas moving average and Granville's On-Balance-Volume which helps us to interpret Midas charts, but for now... take 4 minutes and see some Midas S/R magic.
Rick
This week's screencast shows how to prepare a Midas chart for the S&P 500. Midas is the acronym for the late Dr. Paul Levine's Market Interpretation/Data Analysis System. I cover S/R (support or resistance) curves and the parallel offset. These two tools form the backbone of the extremely powerful Midas method. In another screencast I'll discuss Topfinder, Midas moving average and Granville's On-Balance-Volume which helps us to interpret Midas charts, but for now... take 4 minutes and see some Midas S/R magic.
Rick
posted by XLTrader at 8:28 AM
Friday, June 19, 2009
XLCycles SSA smoothing with 95% Confidence Bands
Hi Guys,
As I promised here is a re-do of the video showing how to put 95% confidence bands around the SSA smoothed reconstruction of price. I'll do another video soon discussing the parameters which make up an SSA analysis such as embedding dimensions and RC components (which are summed to arrive at the smoothed reconstruction).
Rick
As I promised here is a re-do of the video showing how to put 95% confidence bands around the SSA smoothed reconstruction of price. I'll do another video soon discussing the parameters which make up an SSA analysis such as embedding dimensions and RC components (which are summed to arrive at the smoothed reconstruction).
Rick
Labels: 95% Confidence, Caterpillar, SSA, XLCycles
posted by XLTrader at 2:48 PM
Tuesday, June 02, 2009
Trading with Triangle Points
Hi Folks,
Here's my first "talky" screencast.
-> http://www.technical-analysis-addins.com/blog/index.php
I must apologize as I don't have a voice for radio and am, its seems, perpetually congested especially this time of year... anyway... The subject is triangle points. I love this method. One thing to keep in mind that I don't covered in the screencast is that these vectors seem to increase (and decrease) in the "just" ocatve ratios (i.e. the integer ones 9/8, 6/5, 5/4, 4/3, 3/2, 15/16, 2 etc). So if the market doesn't reverse where you're expecting, watch the next interval out. Trade well
Rick
PS I found a error in the point selection algorithm in the XLAngles. So if you want to try this at home (which I recommend) and if you are using Office 2007, download the bug fixed version of XLAngles I put in the files area. (Just swap out the old one)
Here's my first "talky" screencast.
-> http://www.technical-analysis-addins.com/blog/index.php
I must apologize as I don't have a voice for radio and am, its seems, perpetually congested especially this time of year... anyway... The subject is triangle points. I love this method. One thing to keep in mind that I don't covered in the screencast is that these vectors seem to increase (and decrease) in the "just" ocatve ratios (i.e. the integer ones 9/8, 6/5, 5/4, 4/3, 3/2, 15/16, 2 etc). So if the market doesn't reverse where you're expecting, watch the next interval out. Trade well
Rick
PS I found a error in the point selection algorithm in the XLAngles. So if you want to try this at home (which I recommend) and if you are using Office 2007, download the bug fixed version of XLAngles I put in the files area. (Just swap out the old one)
posted by XLTrader at 2:59 PM
Sunday, May 31, 2009
S&P 500 Gann Charts
Hi Folks,
I'm experimenting with Vblogging. Here are some current Gann charts on the S&P500
http://www.technical-analysis-addins.com/blog/index.php
I'm experimenting with Vblogging. Here are some current Gann charts on the S&P500
http://www.technical-analysis-addins.com/blog/index.php
posted by XLTrader at 2:00 PM
Wednesday, May 13, 2009
New Office 97 Version...
Hi Folks,
One of our members who uses Office 97 brought to my attention a problem with the new HLC_Chart template. Consequently I have had to produce an Office 97 specific version of the template and add-ins. I also found and fixed some other issues related to the early versions of VBA (missing functions). Anyone using Office 97 should download from the files area, the XLTraderOffice97.zip
While i was fixing the Office 97 template I also came across a bug that found its way into all versions. The scale factor for Gann Angles, and the Futia Price/Time square in XLANGLES and the scale factor for Fibonacci angles in XLFIBONACCI was not working. People that wish to update to the bug-fixed version should download the appropriate zip from the files. If you've got the most recent version already installed, simply swapping out the old XLAngles.xla and XLFibonacci.xla for the new ones should resolve the issue.
Sorry for these inconvenience but unfortunately there are differences between different versions of Excel that reek havoc. I'm working pretty much exclusively in Office 2007 these days so if you find a bug in the other versions I would very much appreciate your letting me know so I can attempt to fix it.
Have a great day!
Sincerely,
Rick
aka xltrader
One of our members who uses Office 97 brought to my attention a problem with the new HLC_Chart template. Consequently I have had to produce an Office 97 specific version of the template and add-ins. I also found and fixed some other issues related to the early versions of VBA (missing functions). Anyone using Office 97 should download from the files area, the XLTraderOffice97.zip
While i was fixing the Office 97 template I also came across a bug that found its way into all versions. The scale factor for Gann Angles, and the Futia Price/Time square in XLANGLES and the scale factor for Fibonacci angles in XLFIBONACCI was not working. People that wish to update to the bug-fixed version should download the appropriate zip from the files. If you've got the most recent version already installed, simply swapping out the old XLAngles.xla and XLFibonacci.xla for the new ones should resolve the issue.
Sorry for these inconvenience but unfortunately there are differences between different versions of Excel that reek havoc. I'm working pretty much exclusively in Office 2007 these days so if you find a bug in the other versions I would very much appreciate your letting me know so I can attempt to fix it.
Have a great day!
Sincerely,
Rick
aka xltrader
posted by XLTrader at 10:44 AM
Monday, May 04, 2009
New Version(s) Released
Hello,
Today I am pleased to announce I have released the latest verion of XLTrader Add-ins for both Office 97-2003 and Office 2007. The Zip files can be found in the group files area. My aim with this release was to make things easier for those who are less familiar with Excel.
1) Data downloading (from Yahoo! Finance) has gotten much easier. The HLC_CHart template now asks you, when you first launch it, if you want to set it up for automatic downloading. If you say yes it presents a form not unlike XLYahoo that asks for the symbol, frequency , start and stop dates etc. It then downloads the latest data from Yahoo and sets the template up so that all you have to do to update it is press a button on the template toolbar (in the future when more historical data is available). You can change the default path if its not working (Yahoo sometimes (fortunately rarely) changes it)
2) All forms now default to the next available column on the data sheet. You only need to choose a column for output from the drop box if you intend to overwrite an existing data series.
3) All Array formulas now extend well into the future. You no longer need to manually edit your array formulas to reflect new data once new data becomes available.
4) There are a couple of new feature in XLAngles: Carl Futia's Price Time Squaring method, and Stevenson Price Time targets.
5) The TA-LIB stochastics was added to the XLIndicators form
6) A "price time coordinates" Algorithm was added to XLTools (so now you can click any place on the chart (on a remote spiral location for instance) and find the corresponding price and time.
7) THe Office 2007 version now uses the native XLM file formats (i.e XLSM, XLAM and XLTM)
8) You can now install an add-in by double clicking it....
Well that's about all the changes I can remember at this time. Everyone should upgrade to the appropriate version.
Here is a quick sneek peek at what I'm working on:
1) Everyone will soon be issued a password to the members area on the website. That is where links to the most recent versions of the add-ins will be in the future.
2) Yahoo! Intraday is now a reality using the great little add-in that is free at Greenturtle.us Im working on how best to get that data-stream into XLTrader. Everyone interested in intraday TA (of stocks on Yahoo! Finance) should get a copy of the Yahoo realtime add-in at http://www.greenturtle.us/
3) Front end for the Swiss Ephemeris dll. This is the premier digital ephemeris and the price is right.... its free for personal use!
4) Videos.... more instruction is on the way.
That's about it for now but I'm always open to your suggestions. Please feel free to post to the group. The more activity we generate, the more people will join us.
Rick
aka XLTrader
Today I am pleased to announce I have released the latest verion of XLTrader Add-ins for both Office 97-2003 and Office 2007. The Zip files can be found in the group files area. My aim with this release was to make things easier for those who are less familiar with Excel.
1) Data downloading (from Yahoo! Finance) has gotten much easier. The HLC_CHart template now asks you, when you first launch it, if you want to set it up for automatic downloading. If you say yes it presents a form not unlike XLYahoo that asks for the symbol, frequency , start and stop dates etc. It then downloads the latest data from Yahoo and sets the template up so that all you have to do to update it is press a button on the template toolbar (in the future when more historical data is available). You can change the default path if its not working (Yahoo sometimes (fortunately rarely) changes it)
2) All forms now default to the next available column on the data sheet. You only need to choose a column for output from the drop box if you intend to overwrite an existing data series.
3) All Array formulas now extend well into the future. You no longer need to manually edit your array formulas to reflect new data once new data becomes available.
4) There are a couple of new feature in XLAngles: Carl Futia's Price Time Squaring method, and Stevenson Price Time targets.
5) The TA-LIB stochastics was added to the XLIndicators form
6) A "price time coordinates" Algorithm was added to XLTools (so now you can click any place on the chart (on a remote spiral location for instance) and find the corresponding price and time.
7) THe Office 2007 version now uses the native XLM file formats (i.e XLSM, XLAM and XLTM)
8) You can now install an add-in by double clicking it....
Well that's about all the changes I can remember at this time. Everyone should upgrade to the appropriate version.
Here is a quick sneek peek at what I'm working on:
1) Everyone will soon be issued a password to the members area on the website. That is where links to the most recent versions of the add-ins will be in the future.
2) Yahoo! Intraday is now a reality using the great little add-in that is free at Greenturtle.us Im working on how best to get that data-stream into XLTrader. Everyone interested in intraday TA (of stocks on Yahoo! Finance) should get a copy of the Yahoo realtime add-in at http://www.greenturtle.us/
3) Front end for the Swiss Ephemeris dll. This is the premier digital ephemeris and the price is right.... its free for personal use!
4) Videos.... more instruction is on the way.
That's about it for now but I'm always open to your suggestions. Please feel free to post to the group. The more activity we generate, the more people will join us.
Rick
aka XLTrader
posted by XLTrader at 2:31 PM
Join our 
