bonjour
à ma connaissance, il n'y a pas de compétences boursières ici (mais on ne sait jamais)
on peut t'aider à faire un Excel, mais c''est à toi de nous dire les formules
en langage math ou en français, peu importe
Bonjour jmd,
Dans le tableur il faudra juste indiquer des valeurs dans les cases : Open, High, Low, Close. Et en fonction des choix utilisés dans les cellules "Formula" suivant une liste déroulante cela donne le résultat.
Par contre, le format des données à entrer dans les cellules : "Open, High, Low, Close" est fonction du choix sélectionné "Imput Formats".
En espérant avoir été claire dans les explications.
Merci
Ci-dessous l'help sur le site:
https://www.pivotpointcalculator.com/help.html
The input format dictates what type of numbers are valid inputs. If you selected Decimal as your Input Format then you can use a decimal point when entering the Open, High, Low, Close. If you have selected 32nds, 32nds+halves, or 64ths then you should NOT use a decimal point or any other character such as - or ' to separate the big number from the fraction.
To enter the bond value of 101'23 or 101-23 you should enter 10123 and make sure that you've selected the 32nds radio button. The rightmost 2 digits will be considered as 32nds or 64ths. If you want to enter bond numbers that include halves then enter 3 digits in the fractional part. For example for 101'235 (fraction is 235/320) then you should enter 101235 and select the 32nds+halves radio button. Remember that all the numbers should be entered in this format if you select this format. So if you have a number that doesn't have a half then just at a 0 instead of a 5.
If you have selected Input Format as 32nds or 64ths then you will see a dash (-) separating the fractional part of the result from the big number after the calculation has been done.
Decimal Places
Enter the number of significant digits you want the result to be displayed in. The results are rounded to this many decimal places. This obviously only works if the Input Format selected is Decimal. The Decimal Places selection must be in the range from 0 to 9.
Quick Change Formula Set
Select one of the formula sets (Classic, Woodie, Camarilla). If you already have values entered in the Open, High, Low, Close boxes then the calculator will recalculate these values according to your new selection and change the formulas in the drop downs to match that type of calculation. If you do not have any values set then it will just change the formulas in the drop downs and will use those formulas when you enter values and click the Calculate button.
Custom Formula
The formula used for each resistance, support and pivot level can be custom selected by you. Just click on the drop down and select the formula. The letters used in the formula are as follows:
O: Open
H: High
L: Low
C: Close
PP: Pivot Point
RANGE: High - Low
Restated Formula
Some of the formula may not look like the formula that you have seen before or are used to for a certain set of pivot points. This is probably because they have been restated. In algebra you can restate the same formula in a number of different ways but you should always get the same result. Work through the formula and try and restate it in the way it is in this calculator. If you cannot do that then ask for help on the day trading forum.
Error Message
If there was a problem with the calculation (for example, you entered a high lower than the low) then that error message will appear next to the Calculate button in red letting you know what the problem was so that you can correct it.