This post is for my Australian readers, but if you are from far away lands and are curios to see what us Australians pay in tax, feel free to download the spreadsheet. As most of you will be aware the tax office made some minor adjustments to the thresholds and the martingale tax rate which…
Australian Taxation Calculator: Excel Spreadsheet
By Mark | Published August 18th, 2010Office 2010 Professional Edition Install
By Mark | Published June 28th, 2010I was happy to get my copy of Microsoft Office 2010 Professional Edition today and will be putting it through its paces in the coming weeks. I am most excited about the new version of Excel and the addition of sparklines. Microsoft Office Professional 2010 contains the following applications: Microsoft Word Microsoft Excel Microsoft PowerPoint…
*** FREE Microsoft Office 2010 Beta Download FREE***
By Mark | Published March 18th, 2010Microsoft has released free for download the Office 2010 suite of beta applications. The Office 2010 Free Beta download consits of all the applications you would expect to find: Microsoft Word 2010. Microsoft PowerPoint 2010. Microsoft Access 2010. Microsoft Publisher 2010. Microsoft Excel 2010. Microsoft Outlook 2010. You can also download additional beta applications: Microsoft…
TraderXL Pro Package – BulkQuotesXL
By Mark | Published August 12th, 2008BulkQuotesXL 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…
Importing Stock Quotes to Excel using SMF Add-in
By Mark | Published April 22nd, 2008In 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…
Microsoft Excel Tutorial Series: The basic’s of charting: Candlestick Charts
By Mark | Published April 9th, 2008This 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 of charting: Bar Charts
By Mark | Published March 19th, 2008This is part five 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 Today we will be looking at…
Microsoft Excel Tutorial Series: The basic’s of charting market data
By Mark | Published February 25th, 2008In the previous article we went through the basics of importing company data from Yahoo Finance. If you are not familiar with Microsoft Excel and have not read the previous article I suggest you read that before continuing. In today’s article will be using Microsoft Excel to generate charts using market data from Yahoo Finance….
Microsoft Excel Tutorial Series: Importing Market Data from Yahoo Finance
By Mark | Published February 11th, 2008This article is the next article in the Microsoft Excel tutorial series. If you are not familiar with Microsoft Excel or have not read the previous article data entry and navigation I would suggest you read it before continuing. There are many ways in which Yahoo Finance data can be imported into Microsoft Excel, however…
Microsoft Excel Tutorial Series: The basic’s data entry and navigation
By Mark | Published January 7th, 2008If 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…

