Software Tutorial
Office Software
Detailed method of drawing the CCI indicator of stocks in Excel
Detailed method of drawing the CCI indicator of stocks in Excel
php editor Strawberry will introduce today the detailed method of how to use the CCI indicator to draw stock trend charts in Excel. The CCI indicator is an important technical analysis tool that can help investors determine whether a stock is overbought or oversold and guide investment decisions. Using the CCI indicator to draw stock trend charts in Excel can observe stock price fluctuations more intuitively and provide more reference for investment. Next, we will introduce in detail how to implement this function in Excel, so that investors can easily grasp the stock trend.
1. From the description of the CCI indicator in the stock software, we can know that the formula of the CCI indicator is
TYP:=(HIGH LOW CLOSE)/3.
CCI:(TYP-MA(TYP,N))/(0.015*AVEDEV(TYP,N)).
The default N is 14 days. Next we will decompose the formula in EXCEL.
2. Prepare some stock data. In the example, it is the data of an index, which includes date, opening price, highest price, lowest price and closing price.
3. Add a column on the right to calculate the parameter TYP. The calculation method is (HIGH LOW CLOSE)/3, that is (highest price lowest price closing price)/3.
4. Add another column to calculate the parameter MA. The parameter formula is MA(TYP,N), where N is 14, that is, use the AVERAGE function to find the 14-day moving average of the parameter TYP. value.
5. Add a column of calculation parameters AD. The formula is AVEDEV(TYP,N), where N is 14, that is, use the AVEDEV function to find the 14-day average absolute deviation of TYP.
6. Use the formula to calculate (TYP-MA)/(0.015*AD) to get the CCI value. Put the calculated CCI value in the last column and you are done.
7. In order to intuitively reflect the CCI indicator, you can add a two-dimensional line chart and reference the CCI column as the data source, and use the date as the X-coordinate axis.
#8. After setting, the line chart of the CCI indicator will appear.
The above is the detailed content of Detailed method of drawing the CCI indicator of stocks in Excel. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1669
14
1428
52
1329
25
1273
29
1256
24
If You Don't Rename Tables in Excel, Today's the Day to Start
Apr 15, 2025 am 12:58 AM
Quick link Why should tables be named in Excel How to name a table in Excel Excel table naming rules and techniques By default, tables in Excel are named Table1, Table2, Table3, and so on. However, you don't have to stick to these tags. In fact, it would be better if you don't! In this quick guide, I will explain why you should always rename tables in Excel and show you how to do this. Why should tables be named in Excel While it may take some time to develop the habit of naming tables in Excel (if you don't usually do this), the following reasons illustrate today
How to change Excel table styles and remove table formatting
Apr 19, 2025 am 11:45 AM
This tutorial shows you how to quickly apply, modify, and remove Excel table styles while preserving all table functionalities. Want to make your Excel tables look exactly how you want? Read on! After creating an Excel table, the first step is usual
Excel MATCH function with formula examples
Apr 15, 2025 am 11:21 AM
This tutorial explains how to use MATCH function in Excel with formula examples. It also shows how to improve your lookup formulas by a making dynamic formula with VLOOKUP and MATCH. In Microsoft Excel, there are many different lookup/ref
Excel: Compare strings in two cells for matches (case-insensitive or exact)
Apr 16, 2025 am 11:26 AM
The tutorial shows how to compare text strings in Excel for case-insensitive and exact match. You will learn a number of formulas to compare two cells by their values, string length, or the number of occurrences of a specific character, a
How to Make Your Excel Spreadsheet Accessible to All
Apr 18, 2025 am 01:06 AM
Improve the accessibility of Excel tables: A practical guide When creating a Microsoft Excel workbook, be sure to take the necessary steps to make sure everyone has access to it, especially if you plan to share the workbook with others. This guide will share some practical tips to help you achieve this. Use a descriptive worksheet name One way to improve accessibility of Excel workbooks is to change the name of the worksheet. By default, Excel worksheets are named Sheet1, Sheet2, Sheet3, etc. This non-descriptive numbering system will continue when you click " " to add a new worksheet. There are multiple benefits to changing the worksheet name to make it more accurate to describe the worksheet content: carry
Don't Ignore the Power of F4 in Microsoft Excel
Apr 24, 2025 am 06:07 AM
A must-have for Excel experts: the wonderful use of the F4 key, a secret weapon to improve efficiency! This article will reveal the powerful functions of the F4 key in Microsoft Excel under Windows system, helping you quickly master this shortcut key to improve productivity. 1. Switching formula reference type Reference types in Excel include relative references, absolute references, and mixed references. The F4 keys can be conveniently switched between these types, especially when creating formulas. Suppose you need to calculate the price of seven products and add a 20% tax. In cell E2, you may enter the following formula: =SUM(D2 (D2*A2)) After pressing Enter, the price containing 20% tax can be calculated. But,
5 Open-Source Alternatives to Microsoft Excel
Apr 16, 2025 am 12:56 AM
Excel remains popular in the business world, thanks to its familiar interfaces, data tools and a wide range of feature sets. Open source alternatives such as LibreOffice Calc and Gnumeric are compatible with Excel files. OnlyOffice and Grist provide cloud-based spreadsheet editors with collaboration capabilities. Looking for open source alternatives to Microsoft Excel depends on what you want to achieve: Are you tracking your monthly grocery list, or are you looking for tools that can support your business processes? Here are some spreadsheet editors for a variety of use cases. Excel remains a giant in the business world Microsoft Ex
I Always Name Ranges in Excel, and You Should Too
Apr 19, 2025 am 12:56 AM
Improve Excel efficiency: Make good use of named regions By default, Microsoft Excel cells are named after column-row coordinates, such as A1 or B2. However, you can assign more specific names to a cell or cell range, improving navigation, making formulas clearer, and ultimately saving time. Why always name regions in Excel? You may be familiar with bookmarks in Microsoft Word, which are invisible signposts for the specified locations in your document, and you can jump to where you want at any time. Microsoft Excel has a bit of a unimaginative alternative to this time-saving tool called "names" and is accessible via the name box in the upper left corner of the workbook. Related content #
