金融市场的AnalyzerXL产品组
АnalyzerXL is an add-in for Microsoft Excel 2010-2016, designed to help you create trade systems and conduct technical analysis calculations directly in your worksheets. The product was released in 1998.
Technical Analysis is essentially the methods of predicting the price movement through the use of chart patterns and market indicators. AnalyzerXL Pro Technical Analysis Functions Library allows you to produce your own trading system using all power of Microsoft Excel environment.
该函数库包括81个技术分析函数、指标和警报，分为以下几个组别：
功能摘要
- 直观且易于使用的界面
- 针对 MS Excel 的全面技术分析功能库
- 宏创建和管理
- MS Excel环境为您的特定计算和分析提供了很大的整合可能性
- 根据您的偏好，有各种不同的调整选项
日期
July 1998
BacktestingXL 是一款用于构建和测试交易策略的插件 Microsoft Excel 2010-2016.
用户可以使用 VBA (Visual Basic for Applications) 为构建 BacktestingXL Pro 的策略。然而，VBA 知识是可选的 - 除了使用 VBA 构建的交易规则外，您还可以使用标准预制的回测代码在电子表格上构建交易规则。
提供免费的示例回测策略。它们演示了如何高效地应用 BacktestingXL Pro。
BacktestingXL Pro支持高级功能，如金字塔加仓（在开放交易期间更改头寸大小）、多空头寸限制、佣金计算、资产追踪、止损控制、买入/卖出价格定制（您可以按照今天或明天的开盘、收盘、最高或最低价交易）。这样的功能使您能够构建“自然”的交易策略，避免将策略束缚在“框架”中。
BacktestingXL Pro创建了信息丰富且高度详细的策略测试绩效报告。每个报告有七个选项卡：
- 总结报告 摘要报告
- 数据序列报告 交易、权益和盈亏动态以表格和图表形式显示
- 交易报告 交易报告（按仓位分组）
- 交易报告（按时间顺序） 按照时间顺序列出的交易
- 信号报告 – 策略产生的所有信号及其结果（订单是否已处理）
- 设置报告 所有的配置设置
- 策略代码报告 包含原始策略代码。
特点概述：
- 简单的策略创建
- 策略代码可以使用Excel或VBE（Visual Basic Environment）进行开发
- 7页的信息丰富和详细的策略测试绩效报告
- 资产跟踪（初始资本和佣金）
- 单独的多头和空头仓位限制
- 金字塔加仓支持
NeuroXL Predictor is a neural network forecasting tool that quickly and accurately solves forecasting and estimation problems in Microsoft Excel. It is designed from the ground-up to aid experts in solving real-world forecasting problems. The NeuroXL Predictor interface is easy-to-use and intuitive, does not require any prior knowledge of neural networks, and is integrated seamlessly with Microsoft Excel. The software brings increased precision and accuracy to a wide variety of tasks, including stock price prediction, sales forecasting, and sports score prediction.
Easy to Learn and Use
Since users make predictions through the familiar Excel interface, learning time is minimal, greatly reducing the interval between loading the software and performing useful predictions. The application is extremely intuitive and easy-to-use for beginners yet powerful enough for the most demanding professionals. Users just need to specify input and output references, perform a few mouse movements, and their prediction is returned. Also, using NeuroXL Predictor requires no prior knowledge of neural networks.
功能摘要
- Easy to learn and use
- No advanced knowledge of neural networks required
- Integrates seamlessly with Microsoft Excel
- Provides proven neural network technology for highly accurate forecasts
NeuroXL Clusterizer is an add-in for Excel designed to aid experts in real-world data mining and pattern recognition tasks. It hides the underlying complexity of neural network processes while providing graphs and statistics for the user easily to understand results. NeuroXL Clusterizer uses only proven algorithms and techniques, and integrates seamlessly with Microsoft Excel.
Neural networks are a proven, widely used technology to solve complex clustering problems. Loosely modeled after the human brain, neural networks are interconnected networks of independent processors that, by changing their connections (known as training), learn the solution to a problem. NeuroXL Clusterizer software implements self-organizing neural networks, which perform clustering by learning the trends and relationships within your data.
NeuroXL Clusterizer’s ability to handle numerous, often-interrelated variables makes it widely applicable for market data cluster analysis. For example, a trader may wish to categorize stocks as buy, hold, or sell based on historical data.
功能摘要
- Easy to learn and use
- No advanced knowledge of neural networks required
- Integrates seamlessly with Microsoft Excel
- Provides proven neural network technology for highly accurate classification
- Detects relationships and trends in data that traditional methods overlook
- Lowest cost neural network classification product on the market
- Compatible with all Microsoft Excel-based trading software
DownloaderXL 是为 MS Excel 2010-2016, designed to help you download securities’ price data directly into your workbook.
DownloaderXL Pro downloads free quotes from the following data sources:
- Yahoo Finance (Historical prices) – free historical daily, weekly, and monthly prices for stocks, indices, and mutual funds from Yahoo Finance
- Yahoo Finance (Dividends) – free historical dividend data from Yahoo Finance
- PiFin (Historical prices) – free historical end-of-day data for currency FX rates, financial futures, commodity futures, and indices from PiFin
- CryptoCompare – free historical cryptocurrency prices from CryptoCompare (beta)
DownloaderXL provides advanced charting capabilities, generating candlestick, bar, and line charts from downloaded data quickly and easily. Moving Average and Trendline functions are available for basic chart analysis.
功能摘要
- 直观且易于使用的界面
- Free quotes for stocks, indices, mutual funds, futures, options, and dividends
- Multiple and reliable data providers such as Yahoo! Finance, Google Finance etc.
- Downloading quotes and building charts for numerous tickers in one click
- Advanced charting capabilities including Moving Average and Trendlines
- One-click data update and selective data update
- MS Excel environment provides great possibilities for using downloaded data in your particular calculations and analysis
- Experienced users can call DownloaderXL commands from VBA
- 根据您的偏好，有各种不同的调整选项
RTQuotesXL 是为 MS Excel 2010-2016, designed to help you download securities’ real-time data directly into your workbook. Data is provided by Alpha Vantage (a personal API key is required which is available for free upon request). The full list of eligible symbols is available here.
功能摘要
- 直观且易于使用的界面
- Downloading quotes for numerous tickers in one click
- MS Excel environment provides great possibilities for using downloaded data in your particular calculations and analysis.
- 根据您的偏好，有各种不同的调整选项
BulkQuotesXL is an add-in for MS Excel 2010-2016, designed to help you download free quotes directly into your worksheets and automatically apply technical analysis functions to the downloaded data.
BulkQuotesXL Pro downloads free quotes from the following data sources:
- Yahoo Finance (Historical prices) – free historical daily, weekly, and monthly prices for stocks, indices, and mutual funds from Yahoo Finance.
- PiFin (Historical prices) – free historical end-of-day data for currency FX rates, financial futures, commodity futures, and indices from PiFin.
The software is designed to easily handle downloads for tens or even hundreds of tickers simultaneously. It gives you great flexibility and allows you to immediately apply technical analysis to the downloaded data. You can also instantly apply your own macros to all your tickers.
BulkQuotesXL Pro makes it easy to generate bar, candlestick, or line charts instantly from the downloaded data. It also lets you export your data to world known formats, such as ASCII, MetaStock and others. Also, you can display the downloaded data in side-by-side rows or columns, or choose another display format from the pre-defined templates.
BulkQuotesXL Pro contains the library of 81 technical analysis functions, indicators, and alerts which can be easily used in the creation of your particular trading systems. The library consists of 81 technical analysis functions, indicators, and alerts which are divided into the following groups:
功能摘要
- 直观且易于使用的界面
- Free historical stock, index and mutual fund data from Yahoo! Finance and Google Finance
- Free historical data for futures from PiFin
- Free options data from CBOE and Yahoo! Finance
- Free dividends data from Yahoo! Finance
- Downloading data for hundreds of tickers simultaneously by one click
- Automatic application of 81 technical analysis functions, indicators, and alerts of our comprehensive Technical Analysis Functions Library
- Automatic application of your own macros to the downloaded data
- Automatic creation of candlestick, bar and line charts from the downloaded data
- Automatic export of downloaded data to world-known formats (CSV, ASCII, Metastock, etc.)
- Selective data download
