|
|
|
|
|
| 4. Build an Automated Stock Trading System in Excel |
24/Nov/2004
|
Rating :
This online course shows you how to build a sophisticated automated stock trading model using Microsoft Excel. Microsoft's Visual Basic (VBA) language is used in conjunction with Excel's user interface, formulas, and calculation capabilities to deliver a powerful and flexible trading tool. The Model includes five proven technical indicators (ADX, moving average crossovers, stochastics, Bollinger bands, and DMI).
|
|
|
|
| 5. Cash Flow Valuation Model for Excel |
06/Jul/2007
|
Rating :
Cash flow analysis is the basis for most sound investment and business decisions. It is heavily relied upon for value investing, both in the stock market and for private company and project investment. Our Cash Flow Model is useful across all financial and investment disciplines.
|
|
|
|
| 6. Spread Trading Contract Calculator |
09/Jul/2007
|
Rating :
This Calculator is a must have for spread traders!
When spread trading two different futures contracts, it is important to equalize the value of each side of the spread Â? the short position in Contract #1 should be offset as closely as possible by a long position in Contract #2. Constructing and maintaining a perfectly balanced spread can be difficult due to differences in:
-Currency denominations (e.g. two Nikkei 225 futures denominated in $USD and Yen)
-Currency unit sizes (e.g. dollars and cents, pounds and pence)
-Quote units (e.g. basis points and dollars)
-Contract multipliers (e.g. full size vs. E-Mini S&P 500 futures)
This pre-built Excel workbook allows you to simply plug contract parameters into 1 of 3 different Calculators, and balance the number of contracts to equalize the value of each spread leg.
|
|
|
|
| 7. Pivot-Stochastic Futures Trading Model |
09/Jul/2007
|
Rating :
Pivot-Stochastic Futures Trading Model is an efficient, time-saving tool for intraday traders using pivot points to trade futures price reversals. This pre-built Excel model dramatically cuts down on the time and effort required to screen for profitable price reversals.
Pivot point analysis is widely used in the futures markets as a way for floor traders to predict intraday price reversals. However, like any technical indicator, pivot points have their limitations. The Pivot-Stochastic Futures Trading Model is designed to capture the strengths of pivot points while overcoming their limitations.
The Pivot-Stochastic Futures Trading Model is best used as a real-time reversal screening and trade setup tool. The Model allows you to scan for powerful reversal setups among one or more futures contracts in primary Â?pivot zonesÂ? that are most likely to generate profitable trades.
IMPORTANT: The Model operates on 5-minute price bars. You will need a real-time DDE/Active-X data import tool from your broker or data provider to operate the model (DDE NOT INCLUDED).
What You Get: A Tremendous Value!
-A complete pre-built Excel Trading Model (DDE data link not included)
-A complete Users Guide in Word format showing you how to use the model, including multiple real-world trading examples
-Unlimited lifetime Single User License
Features & Benefits
-Integrate Excel, formulas, and data sources into a profitable trading tool
-Position the Model on your screen so only the signals show -- allows you to do other work while you scan for price reversals!
-Can be used with any futures contract -- including indexes, metals, softs, currencies, financials, rates, etc.
-Introduces discipline and well-defined trading rules to "seat of the pants" pivot reversal trading
-Pivot points and the associated support and resistance levels are treated as high probability Â?reversal rangesÂ?
-Pivot failures are taken into account by reversing the entry rules under certain situations -- this adds flexibility to the model
-The Stochastic indicator is incorporated to screen for true reversals based on internal price strength
-Trade frequency is minimized by screening for the best setups with greatest likelihood of profit
-The Pivot-Stochastic strategy naturally finds low-risk trading setups, with stop placement nearby the entry point and large potential upside
-Save money by eliminating recurring software costs
-Easily track multiple futures contracts by simply copying worksheets and adding contracts to the Signals page
Technical Requirements
-Microsoft Excel
-Microsoft Word
-Real time DDE link with 5-minute futures price data from your broker or data provider (DDE NOT INCLUDED)
-Internet access (high speed DSL or cable modem suggested, but not necessary)
-WinZip software (to unzip files)
|
|
|
|
| 8. 50 Ways to Survive a Recession |
10/Jul/2007
|
Rating :
Let's face it -- an economic recession can hit you, your family, your job or your business hard!
Have you...
-Suffered financial difficulties due to the slowing economy?
-Lost or fear losing your job?
-Had a business slowdown?
-Recently retired or are thinking of retirement?
Do you want to...
-Protect your investments and assets from a downturn?
-Take advantage of a recession to increase your wealth and financial security?
-Increase your job security or find a new job in a growth sector?
-Build and protect your business despite the economic downturn?
-Position yourself in the right spot to take advantage of a post-recession recovery?
Whether you want effective advice about your job, personal finances, investments, assets, business, or customers, our 50+ page ebook How to Survive a Recession (and Come Out Wealthy on the Other Side!) provides the advice you need and more!
Just take a look at what you get in this 50+ page ebook...
Your Job
-Working in the right job sectors
-Which industries are hot (or not) during recessions
-How to network and get real results
-Skills to protect and keep the job you already have
-Profiting from education as an alternative career
Your Personal Finances
-Finding cheap, high growth locations
-Back to school -- the smart way
-Getting creative to solve your financial challenges
-Achieving health and financial stability -- at the same time
-Marriage -- maximizing the financial benefits
-Effective credit protection -- avoiding scams
-Getting kids to participate in your family's financial success
-Alternative vacations that maximize dollar-enjoyment value
Your Investments and Assets
-Cutting cash expenses quickly and effectively
-Eliminating credit card debt -- the smart way
-The ins and outs of consolidating accounts
-Stocks vs. Bonds -- when to buy and sell each
-Profiting from stock market downturns
-Foreign currencies -- capturing macroeconomic moves
-The commodity revolution -- profits when the economy sours
-Option-writing basics
-How going against common wisdom can create tremendous wealth
-Capturing major demographic trends for long-term gain
-Techniques to maximize your 401(k), 403(b), and IRA accounts
-When and how to capture major moves in technology
-Diversification -- the smart way
-Hedge funds -- how and why
-Refinancing your home for maximum cash savings
-Vacation properties -- when and where
-Real estate lease-options and when to use them
-Collectibles as investments
Your Business and Customers
-Debt vs. Equity financing -- how to use each to maximum advantage
-Minimizing your borrowing costs
-Timing strategic business moves for explosive results
-Maximizing advertising effectiveness
-Capturing the customer "value" dynamic
-Cutting cost of sales to increase margins
-Managing and transforming excess capacity into profits
-Opportunities in government contracting
-Expanding into international markets -- the smart way
-How to track and use macroeconomic indicators to make business decisions
-When to buy and when to lease
-How and when to enforce contracts
-Identifying and acting on setups for major market shifts
-Management and maintenance on depreciable assets
-Succeeding through flexible pricing
-Prepaid services -- where they work best
-Maintaining and attracting customers in difficult markets
What You Get
-A PDF ebook with over 50 pages of financial strategy!
-Instant online access to download the E-book immediately (you have 2 full days)!
Within our ebook you are guaranteed to find a lifetime of tremendous financial value!
|
|
|
|
| 9. Excel with Yahoo! Finance - Building a Cash Flow Valuation Model |
30/Jun/2008
|
Rating :
This detailed course shows you how build a Cash Flow Valuation Model using Excel and Yahoo! Finance data. You are taught in detail how to build a Discounted Cash Flow Model using Yahoo! Finance fundamental stock data. The course also shows you how to import cash flow data automatically into Excel from Yahoo! Finance using a Web Query.
|
|
|
|
| 10. Consulting Expense Excel Template |
26/Dec/2008
|
Rating :
The Consulting Expense Excel Template is an easy to use expense claim spreadsheet and tracking tool. Completely pre-built and ready to use, this template allows you to track any expenses associated with consulting projects, client expenses incurred, travel, hotels, food and entertainment, and much more!
Simply enter your company's name, attach a company logo, and distribute the spreadsheet to your team of Consultants. If you are using the template for your own consulting practice, this Excel template is a simple way to track your expenses on any project, organize them for tax and accounting purposes, and bill them back to your client. This is a time-proven template used by both global consulting firms and independent consultants worldwide. Includes easy currency conversion. Track by Consultant or Project. Enter ANY type of expense in the spreadsheet by date, currency, description, and category and it sums right to the bottom line. No VBA or macros are included - only simple formulas are used! Add rows and columns, additional spreadsheets, etc. with ease. Can be used as a standard Consultant Expense Template for distribution to your team, then roll up with a summary workbook when they are returned to you. Works with any version of Excel!
|
|
|
|
|
|
