Spreadsheets

Technical Analysis in Microsoft Excel. 146 indicators and experts. Free download real and historical stock quotes from USA, Europe, and Canada into Excel spreadsheets. Mutual funds, corporate bonds, Major USA Market Indices, Major World Indices are downloadable into Microsoft Excel spreadsheets. Daily, weekly and monthly quotes into one Excel spreadsheets. Quotes refresh. The best way to start technical Analysis for the beginner.

try first buy now

NeuroXL

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.

try first buy now

IBXL is real-time streaming quotes interface for Interactive Brokers Trader Workstation and Microsoft Excel.

Standalone installation of Interactive Brokers Trader Workstation (TWS) provides IBXL with online access to all market data feeds available at Interactive Brokers within the users subscription rights. Interactive Brokers is the professionals choice for online trading of options, futures, forex, stocks, and bonds on over 60 markets worldwide.

IBXL downloads real-time streaming TWS quotes into Excel and thus it is possible to build charts, calculate technical analysis functions, create trading systems without the interruption of the data feed as tick-by-tick data is accumulated in Excel. I.e. IBXL allows to use wide range of features available in Excel environment to perform real-time quotes analysis and data visualization.

try first buy now

TraderXL Pro Package

try first buy now

Excel VBA Models Combo Set (Set 1, 2, and 3)

Are you having difficulty understanding how to do option pricing modesl and numerical procedures within Excel? Do you want to see practical examples? The The Excel VBA Models Combo Set solves these problems. It contains practical and well explained examples of:
1. Standard Deviation and Mean
2. Lotto Number Generator
3. Playing Card Probability
4. Normal Distribution Random Number Generator
5. Monte Carlo Integration
6. Black-Scholes Option Pricing Model - European Call and Put
7. Binomial Option Pricing Model
8. Portfolio Optimization
9. Multiple Regression
10. Bootstrap - A Non-Parametric Approach
11. Multivariate Standard Normal Probability Distribution
12. Monte Carlo Simulation
13. Option Greeks Based on Black-Scholes Option Pricing Model
Random Numbers Generator and Statistics Set
14. Log Normal Distribution
15. Log Pearson Type III Distribution
16. Normal Distribution
17. Chi-Square Distribution
18. F-Distribution
19. Student-T Distribution
20. Multivariate Standard Normal Distribution
21. Gamma Distribution
22. Beta Distribution
23. Hypergeometric Distribution
24. Triangular Distribution
25. Binomial Distribution
Numerical Searching Methods and Option Pricing Set
26. Numerical Searching Method - Newton-Ralphson
27. Numerical Searching Method - Secant Method
28. Implied Standard Deviation For Black/Scholes Call - Newton Approach
29. Implied Standard Deviation For Black/Scholes Call - Secant Approach
30. Implied Standard Deviation For Black/Scholes Call - Bisection Approach
31. Implied Standard Deviation For Black/Scholes Put - Newton Approach
32. Implied Standard Deviation For Black/Scholes Put - Secant Approach
33. Implied Standard Deviation For Black/Scholes Put - Bisection Approach
34. European Option Model on Asset with Known Cash Payouts
35. European Option Model on Asset with Continuous Cash Payouts (Index Option)
36. European Option Model on Currency
37. European Option Model on Futures

buy now

Excel Level 1, 2 and 3 Training

CURRENT SPECIAL Was $99.00 Now $49.95

Buying the lessons in this bundle saves you over 50% off the normal price!

These lessons have been written by OzGrid Business Applications who develop Excel spreadsheets on a professional basis. Each lesson is drawn from 'real world' experience and not made up class room scenarios. There are 30 lessons, each between 5 and 10 Word Document pages long, and 15 Workbook examples. There is also online Microsoft Pivot Table tutorial.

BASIC COURSE OUTLINE:

The Fundamentals of Excel, Cut, Copy, Insert, Delete, Paste Special, Custom Formatting, Undo, Redo, Excel Formulas - The least you should know, Useful functions and Paste Function, Calc, Comments, Drawing toolbar, Edit Replace, Delete Clear, Essential Printing, Data Sorting, Hiding, AutoFormats, Protection, Basic Charts, Basic Formatting, If Function

Excel Fundamentals, Worksheet Formulas, Specific Worksheet Formulas, Extract Data and Decision Making, Data Validation and External References, Advanced Filters, AutoFilters, Names Charts, Under Utilised Features, Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks, Custom Views, Report Manager, Hyperlinks, Outlining

Advanced Formulas, Advanced Filters, Text To Columns, Importing Text Files Pivot Tables 1, Pivot Tables 2, Pivot Tables 3, Scenarios, Goal Seek, Data Tables and Consolidation, Excel on the WeB, Macros 1, Macros 2

WHY USE US FOR EXCEL TRAINING?

1.Like all our products and services, OzGrid training will cater to your specific needs. OzGrid specializes in Microsoft Excel, this is all we do! 2.Over time we have focused our business directly towards Excel. Other training companies will offer training in many different Applications, and while they may supply information from good trainers it is very unlikely the trainers will know 3.Excel to the extent we do! Remember we develop 4.Excel spreadsheets in our day-to-day business so we know what you will encounter in your day-to-day use of Excel. We are not just Excel teachers, but also Excel developers!

buy now

Excel Templates For Net Present Value and IRR

Investment-Calc 7.5 provides three Excel workbooks for investment analysis. Used by thousands of businesses from all over the world it incorporates new quick short cuts including instant annuity factor method for Net Present Value and Internal Rate of Return and ready made NPV & IRR cash flow solutions for up to 35 project comparisons. Plus 30 page Guide explaining net present value calculations and internal rate of return, tutorial and demonstrations of project analysis.
Capital budgeting NPV & IRR templates.
Company valuation template.
EBIT/ROIC forecasting spreadsheet.
Present Value Calculators (6 tables)
Project Analysis NPV & IRR templates.
Weighted cost of capital calculator.
Risk analysis explained.
Sensitivity analysis NPV & IRR templates.
Quick Cash flow NPV-IRR to 60 years spreadsheet.
Quick Cash flow NPV-IRR to 120 months spreadsheet.
Dynamic charting explained.
Portfolio Return and annual ROR table.
Constant bond yield amortization spreadsheets, yield to maturity and original issue discount calculations.
Annuity factors short cut to investment return analysis templates.
ANY CURRENCY > Click Currency and then choose the currency you want to work with from the Symbol panel.
Zip file download:
The download contains four files, Investment-Calc 7.5, bond yield templates, the demo tutorial and the Quick Guide.

buy now

Excel VBA Level 1 and Excel UserForms

CURRENT SPECIAL Was $75.00 Now $39.95

These lessons have been written by OzGrid Business Applications, who develop Excel spreadsheets on a professional basis. All information within these lessons are drawn from 'real world' experience and not fictitious class room scenarios. There are five Workbook examples with the 20 lessons. Each lessson is between 5 and 10 Word Document pages long. There are also 10 Excel Workbook Examples.

Lesson 10 has Time Saving Microsoft Excel Solutions. It is a downloadable book in Windows help file format that contains hundreds of solutions to Microsoft Excel problems. You do not need to purchase and it does not expire - it is freeware. Download and use whenever you have the time or need. It is a great way to improve your Excel skills and find time saving Excel solutions.

No special software is needed to use - just download, run ,and open Excel. Access from the Excel Tools menu by clicking on the new menu item. Time savings Excel solutions are always just a click away - you even save time by avoiding fruitless Internet searches!

BASIC COURSE OUTLINE:

The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties, Excel Objects , Object Hierarchy, Application, Workbook, Worksheet, Range, CommandBars, Variables and Constants, Data types, Variable Levels, Declaring Variables, Constants, Loops, Types of Loops, Loop Pitfalls, Effective Decision Making, If/And/Or, Select Case, Dates and Times, Workbook and Worksheet Events, Debugging and Error Handling, Prevention, Good Habits, Runtime Errors, Excel WorksheetFunctions in VBA, Specific Examples, Excels Built-In Features, User Defined Functions, Good vs Bad, Arguments, Calculation, Controls, ActiveX, Control Toolbox, Control Properties, Control Parent.

UserForms Introduction, Filling UserForm Controls, Putting Data into our Controls, When to put Data into our Control, Filling a ListBox and/or ComboBox using Loops, Multi-Page Control, Creating a wizard using the Multi-Page Control, Validating the User Inputs, Some Useful Methods and Functions, When to apply Validation, Control Events, Which Controls to use and When, Parsing Control Values back to a Spreadsheet, Parsing range values to the UserForm Controls, Option Buttons and Checkboxes in Detail, True or False, Creating Template Controls, Using the RefEdit Control, Finding the Active Control, Creating Controls at Runtime.

WHY USE US FOR EXCEL TRAINING?

Like all our products and services, OzGrid training will cater to your specific needs. OzGrid specializes in Microsoft Excel, this is all we do! Over time we have focused our business directly towards Excel. Other training companies will offer training in many different Applications, and while they may supply information from good trainers it is very unlikely the trainers will know Excel to the extent we do! Remember we develop Excel spreadsheets in our day-to-day business so we know what you will encounter in your day-to-day use of Excel. We are not just Excel teachers, but also Excel developers!

buy now

SQL Tester

MS Excel add-in for retrieving data from all kind of databases

buy now

ABC Amber QuattroPro Converter

ABC Amber QuattroPro Converter is an advanced tool to convert your QuattroPro spreadsheets into any format you wish (PDF, DBF, CSV, XML, XLS, CHM, HTML, RTF, HLP, DOC, TXT, etc.) easily and quickly.

buy now

ABC Amber Paradox Converter

ABC Amber Paradox Converter is an advanced tool to convert your Paradox databases into any format you wish (PDF, DBF, CSV, XML, XLS, CHM, HTML, RTF, HLP, DOC, TXT, etc.) easily and quickly.

buy now

ABC Amber Lotus 1-2-3 Converter

ABC Amber Lotus 1-2-3 Converter is an advanced tool to convert your Lotus 1-2-3 spreadsheets into any format you wish (PDF, DBF, CSV, XML, XLS, CHM, HTML, RTF, HLP, DOC, TXT, etc.) easily and quickly.

buy now