March 16 , 2010
Strategy Backtesting in TraderCode
ConnectCode is proud to announce the release of TraderCode version 4.0, a comprehensive suite of technical indicators and technical analysis functions for use with Microsoft Excel. This latest version includes a new Backtesting Expert to perform strategy backtesting and performance analysis.
Backtesting is the process of testing a trading strategy using historical data and analyzing how well it has performed. The trading strategy typically involves the use of technical indicators. Through the study of the performance of the strategy, a trader will be able to better gauge his odds of winning in the current market conditions.
The Backtesting Expert can be setup to enter into Long or Short positions when certain conditions occur and exit the positions when another set of conditions are met. By trading automatically on historical data, the model can determine the profitability of a trading strategy very quickly and easily.
This new version also introduces the Trader's Calculator for calculating Stock Beta, Jensenís Alpha, Porfolio Risk and Assets Correlations of stocks automatically. The calculator is based on a spreadsheet and can thus be easily expanded or integrated with existing trading process. With this information, a typical user is now equipped with the information and tools in an integrated manner that was once only available to a financial analyst.
For more information, please visit TraderCode Technical Indicators
January 04 , 2010
InvestmentCode Financial Models
InvestmentCode is a comprehensive suite of investment calculators and modelling templates developed by ConnectCode. It significantly improves the productivity of investors and analysts on the different aspects of financial modelling. Equipped with over 100 financial templates in over 30 categories of finance, it certainly helps to reduce the effort in managing investments, calculating cash flows, optimizing portfolio, valuing bonds and equities, analyzing financial statements and performing forecast quickly and easily.
For more information, please visit InvestmentCode Financial Models
December 16 , 2009
TraderCode Technical Indicators
TraderCode is a comprehensive library of technical indicators and technical analysis functions for use with Microsoft Excel. It allows you to create many types of technical indicators used in trading systems like Moving Average, Bollinger Bands, Average Directional Movement Index, Oscillators, True Range, Standard Deviation, Donchian Channels and many more. With these indicators you can easily perform end-of-day analysis or back-testing of historical stock data. The software comes with both formulas for Excel and a built-in Wizard to help you create the indicators.
For more information, please visit TraderCode Technical Indicators
July 22 , 2008
ConnectCode Text Manager
ConnectCode Text Manager is a productivity Add-in for working with numbers in Microsoft Excel. It allows you to easily make text modifications to your existing cells, range or entire worksheet. Changing a range of cells to different case, removing specific special characters(multiple characters) and trimming the cells can all be carried out very effectively and easily. This Add-in also allows you to concatenate several cells together and add spaces for the text of the cells. This is a must have Add-in if your daily tasks involve working with text in Excel. It will definitely save you many hours of tedious work.
For more information, please visit ConnectCode Text Manager
June 17 , 2008
ConnectCode Number Manager
ConnectCode Number Manager is a productivity Add-in for working with numbers in Microsoft Excel.
It allows you to easily increase and decrease the number of decimal places, add leading zeros,
align the decimals in numbers, display negative numbers in brackets(and red),
manipulate the display of zeros/positives/negatives/text, format numbers as currency.
You can choose to either modify the display of the numbers or change it's underlying values.
If your daily tasks involve number crunching, then this Add-in will save you many hours of tedious work.
For more information, please visit ConnectCode Number Manager
June 3, 2008
ConnectCode Barcode Font Pack
ConnectCode barcode fonts enable barcodes in office applications and softwares that support text display. It includes an Add-In for Excel that mass converts rows of data into multiple barcodes.
A barcode font is a specially designed font that allows you to specify and generate barcodes on normal text characters. Using it can be as simple as installing the font, loading up a text editor (like Wordpad or MS Word) and entering the text for the barcodes.
ConnectCode ships with an Encoder that can create images out of the barcode fonts and prepare raw data into a form suitable for barcode encodation. Additionally, a variety of tools, applications and source codes are provided to ease integration with third party products. This includes a Microsoft Office Macros, Crystal Reports Formulas and WPF samples.
The fonts support symbologies such as Code39, Code 39 Extended, Code93, Code 128 Auto, Code128A, Code128B, Code128C, I2of5 (Interleaved 2 of 5), ITF14, EAN 13 (European Article Numbering), EAN 8, UPCA (Universal Product Code), UPCE, UCCEAN, ISBN, ISSN, MSI, Codabar, UPC/EAN Extension 2 and Extension 5 barcodes.
The font pack includes TrueType fonts, PostScript fonts, and OpenType fonts (that can be used in Mac OS). Additionally human readable fonts are also available for Code 39, Code 128B and I2of5 barcodes.
For more information, please visit ConnectCode Barcode Font Pack
Feb 1, 2008
Release of SparkCode Professional - Add-in for Creating Dashboard Reports in Excel
SparkCode Professional is an add-in for Excel that lets you create sparklines - intense, simple graphics that are as small as a cell - using TrueType fonts. It is a valuable tool for creating professional dashboard reports containing multiple graphics for the purpose of visualizing and comparing vast quantities of data.
With SparkCode, you will be able to create quality dashboard reports in just a few simple steps. The software provides a very easy to use interface that aids the generation of different chart types by guiding users through the flow and allows users to customize the charts with
The graphics in SparkCode are implemented as font glyphs, which means the charts (lines, columns, dots) are actually a string of text that are easily portable to third party softwares that support text and fonts.
For more information, please visit the SparkCode Professional page
Dec 17, 2007
Announcing the Launch of ConnectCode Duplicate Remover
ConnectCode Duplicate Remover is a powerful add-in for finding and removing duplicates entries in Excel. It can save you hours of time when you need to prepare an unique list from a huge list of multiple entries. With the ConnectCode Duplicate Remover Add-in for Excel, you will be able to
- Create a new worksheet to store the unique list (leaving the original list unchanged)
- Hide the duplicates in the original list temporarily
- Highlight the duplicates in a list using a different background color
- Delete duplicates by making cells blank
- Compare two lists and find the similarities or differences among them
For more information, please visit the ConnectCode Duplicate Remover for Excel page
Aug 21, 2007
Open Source Add-in for Sparklines Generation in Excel
We are pleased to announce the release of TinyGraphs 1.0, an open source add-in for generating sparklines in Excel. The sparklines, or tiny graphs, are as small as a cell and can be placed next to the items they describe. Multiple number of such graphics present an elegant way for visualizing large quantities of data, such as stock prices and exchange rates.
The TinyGraphs plug-in creates a sparkline for every row of data in a rectangular block of cells. It supports lines, area and column charts and provides options for customizing them. The tiny graphics generated by the plug-in can be further reformatted for more variations, like soft shadows, 3D and glow effects.
TinyGraphs currently supports Excel 2000, 2003 and 2007.
For more information, please visit the TinyGraphs page