Is there a way to calculate Variance and standard deviation of stocks in tableau itself from Historical stock data of past three years
I have high, low, open, close, volume of each stock for past 3 years
i need yearly/monthly Return, variance and Std deviation of the same using calculated fields
Any help would be appreciated!
thanks in advance.
1 answer
good mornings @Sumeet Chandwani
without a workbook can't be specific - but see the last use case on https://jimdehner.com/2022/01/11/table-calculations-when-where-and-how/ where I touch on when to use window stat functions and when to use the disaggregated versions
Jim
