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, 2010TraderXL Pro Package – PredictorXL
By Mark | Published September 1st, 2008PredictorXL is one of the components in TraderXL Pro. PredictorXL uses Artificial Intelligence to predict future movements in price of securities.
TraderXL Pro Package – BacktestingXL
By Mark | Published August 15th, 2008BacktestingXL is one of the components in TraderXL Pro that convinced me to buy the program. I am still learning how best to write my own strategies and integrate BulkQuotesXL, AnalyzerXL and BacktestingXL. For the purpose of this review I will use the tether line sample strategy to explore the features of this addin. The…
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 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…
Trading Tools: An Introduction to Microsoft Excel 2007
By Mark | Published December 3rd, 2007In 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…
Get Excel 2010
