The next component in TraderXL Pro we will have a look at is RTQuotesXL. RTQuotesXL allows you to import realtime stock data into Excel directly. RTQuotesXL makes use of Yahoo’s real time data service, so the catch is to make proper use of this plugin you need to be a paid subscriber to this service. [...]

BulkQuotesXL is the more robust sibling of DownloaderXL. BulkQuotesXL has a greater range of functionality and is more geared towards mass data acquisition. One of the standout features of BulkQuotesXL is the ability to obtain Futures data from PiFin the contracts are continuous and rolled on expiration. You can also download stock, indices and mutual [...]

Today we continue our brief look at the TraderXL Pro package and examine AnalyzerXL. In short AnalyzerXL allows you to apply technical analysis to price data. The technical analysis library is quite extensive with around 165 functions, experts and indicators. The best way to understand how AnalyzerXL operates is by way of example. You can download [...]

I am always on the lookout for tools and applications that will make life easier an on the weekend I stumbled across one of these applications TraderXL Professional. In my previous article you may have read that I was using the free Stock Market Functions Add In for Microsoft Excel to download data. This proved [...]

NinjaTrader is a broker independent trading platform. This means that you can use one piece of software with several different brokers. NinjaTrader is available as a free download (after providing your email address). The free download version can be used for simulation and testing. Before you download this software you should ensure your computer [...]

When it comes to writing computer programs or in this case automated trading systems translating English into programming code can be fraught with danger. Pseudo Code on the other hand refers to a more structured English for describing a process or program. It is important that you learn to write quality pseudo code as [...]

It has been a little over a week now since I first installed Visual Studio 2008 Professional Edition. My first impressions are that this is a very solid program. Visual Studio 2008 was released in late November 2007 and by now most investment banks have migrated their development environments from Visual Studio 2005 to [...]

In our previous article we used a simple method for importing stock quote data into Excel. Today we will look at a robust automated method for querying more data sources then just Yahoo finance. The Stock Market Functions Add-in for Excel is a free tool developed by by Randy Harmelink. The stock market functions [...]

My copy of Microsoft Visual Studio 2008 Professional Edition arrived today and I made sure I installed it promptly. The software comes packaged in the new style plastic boxes, much like Office and Vista. There are two DVD’s one contains Visual Studio 2008 and MSDN documentation and the second contains SQL Server 2005 Developers Edition. [...]

This is part six of our Microsoft Excel Tutorial Series, if you haven’t read the previous articles you can find them here: An Introduction to Microsoft Excel 2007 The basic’s data entry and navigation Importing Market Data from Yahoo Finance The basic’s of charting market data the line chart The basics of charting market data the bar chart Today we [...]