Financial-edu.com / Venus United Capital - Software Products

EZ-Files Technical Indicator Library

The EZ-Files Library contains 26 technical indicators pre-built in Excel Spreadsheet Format. These Excel files are tremendously useful for constructing securities trading, technical analysis, or statistical models in Excel. EZ-Files save you countless hours of research and calculation time, and each indicator is guaranteed to have 100% correct formulas. EZ-Files can be combined to build sophisticated trading models that perfectly suit your particular investment criteria. All indicators are pre-built in Excel format with "open source" formulas left unlocked to enable easy adjustment and modification. The indicators cover 300 periods of data, and can be expanded as desired. Benefits - Eliminates the time and expense of constructing your own formulas - Easily combine indicators to build your own custom trading or analysis systems - Save money by eliminating recurring software costs - Guaranteed 100% correct! - Learn how each indicator works (a key for institutional audits and transparency) - Modify the formulas to suit your own analysis needs Technical Requirements - Microsoft Excel - WinZip software to unzip the files

Keywords: ezfile ez-files ez-file education finance financial excel model modeling models formula spreadsheet excel trading trade stock stocks bond

Build an Automated Spread Trading System

This online course shows you how to build an automated spread trading model using MS Excel. The System captures the price difference between security pairs of any type - indexes, stocks, futures, options, LEAPs, currencies. The System uses three proven technical indicators - exponential moving averages, Percentage Price Oscillator (PPO), and Donchian Channels - to capture spread movements when profits are likely to be greatest. Includes three spread strategies for Swiss Franc - Japanese Yen futures, Nasdaq - S&P 500 E-Mini, and 10-Year vs 5-Year U.S. Treasury Notes. The System is optimized for use with daily or hourly data, but can be used on any time interval. You are shown how to build a data "hub" with a DDE link, or run the model with free .csv data files from Yahoo! Finance or another source. A PDF Guide is provided along with the online course so you can choose how to learn in the most comfortable way. Also included is a complete backtesting model -- simply import historical data and see statistical and graphical results for your chosen spread strategy. What You Get: A TREMENDOUS 3-IN-1 VALUE! - PDF Guide - Online course including everything in the PDF Guide PLUS VBA Code and FAQs sections - Pre-built Backtesting Model in MS Excel with graphs and trade statistics - Online access to the course materials Benefits - Integrate Excel, VBA, formulas, and data sources into a profitable trading tool - Acquire knowledge applicable to any Excel modeling project - Save money by eliminating recurring software costs - Calculate Buy/Sell signals on multiple spread pairs within seconds Technical Requirements - MS Excel for Windows - Adobe Acrobat Reader - 5Mb disk space - Date-Time-Close price data on your chosen time interval - (OPTIONAL) DDE data import link for Excel

Keywords: spread trading system building automated excel spreadsheet vba macro dde active-x quote.com price index stock future option leap

Build an Automated Sector Fund System

This online course shows you how to build a long term sector fund rotation model using MS Excel. Microsoft's Visual Basic (VBA) language is used with Excel's user interface, formulas, and calculation capabilities to deliver a powerful and flexible investment tool. Uses the classic market economist's Sector Rotation Model, with several improvements that eliminate the guesswork in timing fund switches. THE SYSTEM CAN OUTPERFORM DIVERSIFIED BUY AND HOLD MUTUAL FUND INVESTING BY A FACTOR OF 2-4 TIMES. Incorporates three proven technical indicators--relative strength, moving average crossovers, and moving average slope, to identify the sector funds most likely to provide long term profits. Can be used with any mutual fund, index fund, SPDR, ETF, future, or other index security to allocate capital to the most profitable sectors. Uses weekly .csv data files available for FREE from Yahoo! Finance, or an automated DDE data link if desired. Simply run the system on a weekly basis and make your investment decisions. A PDF Guide is provided so you can choose how to learn in the most comfortable way. Also included is a pre-built Excel backtest model that allows you to test up to 10 different funds versus buy and hold over a 10 year period. What You Get: A TREMENDOUS 3-IN-1 VALUE! - PDF Guide showing you how to build and use the model - Online course - Pre-built Backtesting Model in MS Excel with graphs and trade statistics - Direct online access to the course materials Benefits - Integrate Excel, VBA, formulas, and data sources into a profitable trading tool - Get knowledge applicable to any Excel modeling project - Eliminate recurring software costs - Calculate Buy/Sell signals on hundreds of funds within seconds Technical Requirements - MS Excel for Windows - Adobe Acrobat Reader - 5Mb disk space - Weekly Close Fund price data - (OPTIONAL) DDE data import link for Excel

Keywords: fund sector trading system building automated excel spreadsheet vba macro dde active-x quote.com weekly rotation relative strength moving