1. How to Calculate EMA in Excel - Invest Excel


    Learn how to calculate Exponential Moving Average (EMA) in Excel and VBA. Also get a free spreadsheet that downloads historical stock data and calculates & plots EMA.

  2. Stock Chart with Scroll and Zoom | Excel & VBADatabison


    Stock charts come in various shapes. There are candlestick stock charts, line and bar stock charts, “Kagi” stock charts, moving average stock charts and ...

  3. VBA Cheat sheet - The Analyst Cave | Excel, VBA ...


    VBA Cheat Sheet. VBA syntax, variables, loops, conditions, Classes, Types, Enumerations etc. The best VBA cheat sheet out there!

  4. Peak Detection using VBA - Experts-Exchange


    4/11/2011 · Iam trying to detect peaks using VBA and found someone has written a nice function to do this in MATLAB here http://www.billauer.co.il/peakdet.html Can ...

  5. VBA Conditional Formatting of Charts by Value - Peltier ...


    Jon shares a VBA approach to format datapoints based on values.

  6. Generate Excel spreadsheets. xlsgen - native Excel ...


    What : xlsgen lets you read, write, calculate, display and print Excel spreadsheets without using Excel. It beats Excel in speed by orders of magnitude.

  7. VBA Code for GetPivotData - Free Excel\VBA Help Forum


    11/2/2010 · Re: VBA Code for GetPivotData Hi Duggerz welcome to Ozgrid. I was not 100% sure what figure you wanted in BKLogSummary so …

  8. Excel VBA | Microsoft Excel VBA | Excel VBA Tutorials


    Interested in learning more about Excel VBA? MrExcel will teach you how to use Microsoft Excel VBA. Check out our site for more information about Excel VBA tutorials ...

  9. Table Formula in Excel (Something I didn’t Know Till ...


    Table formulas were something that I discovered recently. Actually our reader m-b commented that he prefers to convert a range to a table and then employ table ...

  10. Link Excel Chart Axis Scale to Values ... - Peltier Tech Blog


    This tutorial shows examples of code to update an Excel chart's axis scales on demand or on worksheet changes, using scale parameters from worksheet cells.