XLTools.xla - Tool For Traders
XLTools has some handy tools for the trader. I has: a calender tool (for calculating the trading and calender days between dates or finding a date in the future); a parse tool which refomats the data (to that which is required by HLC_CHart.xlt and Midas.xlt) downloaded from sources like YAHOO! so it can be easily cut and paste into a template; a compress (intra-day) data (into daily bars) tool; an insert/remove weekends and holidays tool and a "export image tool".
XLTools are accessible from the XLTrader drop down menu.
Calender Tool
When you click on the calender tool menu item, it brings up the XLCalender form. You specify the calender dates by clicking on the calender icon. If you click the bullet next to the date, it tells the program to change that date when you tell it to calculate say: a user specified number of either trading days or calender days from the other date. When you press the arrow icon… next to the trading days and calender days input box, it recalculates.
Insert/Remove Weekends & Holidays
When you download data from most sources, the file is in trading day format. But sometimes you want to include weekends and holidays. For instance, if you are plotting astronomical ephemeris functions from the XLPlanets add-in and you don't want steps then you must include weekends. This macro inserts (or removes) those dates.
Parse Data
If you know the ticker symbol and have an internet connection open, you can download data from the Yahoo finance website by simply typing (or cut-and-pasting) the URL into your browser address box and pressing enter.
Example URLS:
http://ichart.finance.yahoo.com/table.csv?s=^GSPC
&a=09&b=20&c=2004&d=11&e=29&f=2006&g=d&ignore=.csv
http://moneycentral.msn.com/investor/charts/
chartdl.asp?Symbol$INX
*note these should be all on one line!
When you do, a form pops up and asks you where you want to save the CSV file. CSV is a format which can be read by Microsoft® Excel. But it will not be formatted corectly for the HLC_Chart.xlt template. This tool reformats and pre-selects the data so you can "cut-and-paste" it directly into the template.
Export Image
If you have a chart you want to share with others (perhaps at our XLTrader-talk Google group) then you need to export it in a "web friendly" graphics format. Thats what this tool does. You can choose either gif or jpeg formats. Get XLTools by joining XLTrader-Talk Google group today!
XLTrader Add-ins, Templates, etc. work together seamlessly turning Microsoft Excel© into a powerful yet inexpensive Technical Analysis platform. All of the XLTrader add-ins together with the (HLC_Chart.xlt) template to make Technical Analysis as easy as pointing and clicking! 
You can get get XLTrader by joining XLTrader-Talk google group. The software is a group membership benefit.
Data Downloader
