Microsoft

Visual Studio 2008 Professional Edition Overview

By Mark | Published April 24th, 2008

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 2008….

Importing Stock Quotes to Excel using SMF Add-in

By Mark | Published April 22nd, 2008

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 Add-In…

Visual Studio 2008 and some Quant Links

By Mark | Published April 11th, 2008

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….

Microsoft Excel Tutorial Series: The basic’s of charting: Candlestick Charts

By Mark | Published April 9th, 2008

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…

Microsoft Excel Tutorial Series: The basic’s data entry and navigation

By Mark | Published January 7th, 2008

If you have not already read the brief introduction to Excel 2007 I would advise you do so before continuing on with this tutorial series. You may be asking yourself what is the point using Excel as an analysis platform when there are products such as Wealth Lab and TradeStation available. I think that it…

Trading Tools: An Introduction to Microsoft Excel 2007

By Mark | Published December 3rd, 2007

In trading as in any other profession it is important to have the right tool for the right job. In our daily life as a trader we work with a large range of data that requires analysis. If you have done any kind of statistical or financial analysis I am sure you will be familiar…