Difference between revisions of "Manuals/calci/TOQUARTER"
Jump to navigation
Jump to search
(6 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
<div style="font-size:30px">'''TOQUARTER (QuarterIndex)'''</div><br/> | <div style="font-size:30px">'''TOQUARTER (QuarterIndex)'''</div><br/> | ||
− | *<math>QuarterIndex</math> is the | + | *<math>QuarterIndex</math> is the month number. |
+ | |||
==Description== | ==Description== | ||
− | *This function is showing the | + | *This function is showing the quarter of the given numbers. |
− | *In <math>TOQUARTER(QuaterIndex)</math>,<math>QuaterIndex</math> are the | + | *In <math>TOQUARTER(QuaterIndex)</math>,<math>QuaterIndex</math> are the numbers of the month. |
− | *There are four | + | *There are four quarter values. |
− | * | + | *A three-month period on a financial calendar that acts as a basis for the reporting of earnings. |
− | * | + | *A quarter refers to one-fourth of a year and is typically expressed as "Q." |
− | *The | + | *The four quarters that make up the year are |
− | + | Quarter 1:January,February and March. | |
− | + | Quarter 2:April,May and June | |
− | + | Quarter 3: July,August and September | |
− | + | Quarter 4:October,November and December. | |
− | + | ||
− | * | + | ==Examples== |
+ | #TOQUARTER(4) = Q2 | ||
+ | #TOQUARTER(10) = Q4 | ||
+ | #TOQUARTER([3,6,9,11]) | ||
+ | QuarterIndex TOQUARTER | ||
+ | 3 Q1 | ||
+ | 6 Q2 | ||
+ | 9 Q3 | ||
+ | 11 Q4 | ||
+ | |||
+ | ==Related Videos== | ||
+ | |||
+ | {{#ev:youtube|v=24jr3ZUbQS4|280|center|Quarter}} | ||
+ | |||
+ | ==See Also== | ||
+ | *[[Manuals/calci/QUARTILE | QUARTILE ]] | ||
+ | *[[Manuals/calci/SIN | SIN ]] | ||
+ | *[[Manuals/calci/COS | COS ]] | ||
+ | *[[Z_API_Functions | List of Main Z Functions]] | ||
+ | *[[ Z3 | Z3 home ]] | ||
+ | |||
+ | ==References== | ||
+ | *[http://www.investopedia.com/terms/q/quarter.asp?lgl=v-table Quarter] | ||
+ | |||
+ | *[[Z_API_Functions | List of Main Z Functions]] | ||
+ | *[[ Z3 | Z3 home ]] |
Latest revision as of 05:22, 26 May 2020
TOQUARTER (QuarterIndex)
- is the month number.
Description
- This function is showing the quarter of the given numbers.
- In , are the numbers of the month.
- There are four quarter values.
- A three-month period on a financial calendar that acts as a basis for the reporting of earnings.
- A quarter refers to one-fourth of a year and is typically expressed as "Q."
- The four quarters that make up the year are
Quarter 1:January,February and March. Quarter 2:April,May and June Quarter 3: July,August and September Quarter 4:October,November and December.
Examples
- TOQUARTER(4) = Q2
- TOQUARTER(10) = Q4
- TOQUARTER([3,6,9,11])
QuarterIndex TOQUARTER 3 Q1 6 Q2 9 Q3 11 Q4