Current location - Music Encyclopedia - Today in History - Formula or method for calculating the lowest price in each period (flush)
Formula or method for calculating the lowest price in each period (flush)
Just set your own cycle. If you need to select 5 days, 10 days and 15 days, the lowest price can be obtained if the closing price is less than this period.

Recommendation: A 1:=LLV(L, 5); A2:=LLV(L, 10); A3:=LLV(L, 15); LLV(A 1,A2,A3);

Click Tools-Formula Management to enter, or press CTRL+F and click New to enter formula editing. At the same time, you can easily import or export formula data. At the same time, we provide a formula discussion forum, and you can also enter the forum to communicate with the majority of formula lovers.

1. Create a new user-defined formula. Click the "New" command in the "System" menu and select "Custom Formula" to confirm. Enter the formula editing dialog box.

Name: Enter the name of the formula here (usually in English). So that the name can be used when other formulas call the formula. For example, the function of the OPENing price of a data item is called "open". When other formulas want to call the opening price for calculation, just enter "open" in the formula editing area.

Description: Give this formula a simple name (usually in Chinese). This name will be displayed when this formula is output as a data item. For example, if the description of the opening price of a data item is "opening price", the name displayed in the title of the column displaying the opening price in the table is "opening price".

Password: If a password is selected, the formula will be encrypted. After entering the password, you must enter the password before modifying and viewing this formula in the future. However, you are still free to import, export and use this formula.

Usage Description: You can write a text description of the usage of this formula. Click to read or modify. And it can be called in many other interfaces, such as stock selection interface.

Parameter Editing: You can easily adjust the values that need to be modified in the process by using parameters. Parameter name, minimum value, maximum value and default value need to be set for each parameter. Fill in the parameter name, maximum value, minimum value and default value in turn. If you want to delete, press delete.

Parameter Wizard: Users often need to adjust parameters when using analysis tools, but many users can't understand the practical significance of parameter adjustment. Using the Parameter Wizard under the Description button, you can put the parameter adjustment and the parameter meaning in the same paragraph, which is convenient for users to use. When the user uses the formula, the contents of the parameter wizard will be displayed next to it. The content of the parameter wizard is a paragraph of text input by the formula editor, which describes the use of parameters and can be edited by mixing parameter settings with text. The method is to replace the parameter with "Param# 1" (note: put spaces before and after). For example, there are two parameters M and N in the formula, which need to describe buying when the M moving average crosses the N moving average. The parameter wizard can be written as follows: "Param# 1 EMA crosses the Param#2 EMA and sends a buy signal." In the actual use of this analysis method, the system will show that there is a golden cross between the 5-day moving average and the 10 moving average, and the system will send out a buy signal. Among them, 5 and 10 in the input box are parameters, and users can modify these parameters directly, but they will be used for calculation in actual operation. Using the parameter wizard greatly reduces the difficulty of using the formula.

Formula editing area: used to write the algorithm of analysis method, which is the core part of formula editor. Users can write their own algorithms with formula syntax in the editing window. For formula syntax, please refer to Appendix 5: Formula Description. The formula editor supports color display, with function names displayed in uppercase blue and constants displayed in pink. When the mouse moves over any function name, an interpreter will pop up to explain the meaning and usage of this function.

"Test formula": After writing, click here to test whether the formula is written correctly.

"Prompt" box: After the test is completed, the test results will be prompted here. If it fails, the specific location of the error will be displayed.

Import Formula: you can import the contents of other formulas to facilitate mutual copying between formulas. After clicking, a window will pop up, displaying the formulas in three directories: Technical Indicators, Trading System and Multicolored K-line. Enter the first letter of the formula name in the formula list on the right side of the window for quick search. Below is the "Instructions for Use" of the selected formula. Selecting "OK" button to import formula will add all parameters, formula content, usage and parameter description of the formula to the current formula editor and replace the existing content. Note: When using this function, the existing content will be replaced!

Insert Function: Displays the Select Function dialog box to help you find the required function in the Skynet function set. You can quickly search by entering the first letter of the function name in the function list on the right side of the pop-up window. Below is the "Instructions for Use" of the selected function. After selecting the "OK" key of the function point, add the corresponding function name in the Formula Editing Window, so that the current formula can call the function. This function can save you time when you are not familiar with the standard functions provided by the system.

"Applicable Period": Since the data in the stock market are closely related to the period, the period used by the current formula should be selected when writing the formula. For the meaning and usage of loop, please refer to Appendix 5: Formula Description-Code and Loop. When selecting the "Technical Analysis" cycle, the sub-cycle generally selects "All Applicable Periods". If you want to realize the same formula for different parameters of minute K-line, daily line and weekly line, for example, you want to look at the 5-day K-line, but when you switch to the 5-minute K-line, you can look at the moving average of 6 K-line periods (that is, the half-hour moving average). You can select "Technical Analysis" cycle and sub-cycle "5 minutes". Set the parameter default value of "5 minutes" K line to "6". Then change the sub-period to "daily line" and change the parameter default value to "5". Finally, press "OK" button to save.

2. Modify the function. Select the formula to be modified in the User-defined Formula column of the function tree, right-click and select Modify. The following operations are similar to those when creating, except that the formula name cannot be modified.