Find minimum and maximum prices
Your goal now is to extract some relevant information from the time series to better understand the price dynamics during the period under analysis.
To that purpose, the first thing is to identify the extremes: what are the minimum and maximum prices reached by ABC during this period? Use the functions MIN() and MAX() to answer these questions.
Recall that these functions work the same way: they receive as the main argument the range of cells from which you want to extract information and return respectively the minimum and maximum values in the range of cells.
Bu egzersiz
Financial Analytics in Google Sheets
kursunun bir parçasıdırEgzersiz talimatları
In
F3, use the functionMIN()to find the minimum value reached by ABC during the historical period.In
F5, use the functionMAX()to find the maximum value reached by ABC during the same period.
Uygulamalı interaktif egzersiz
İnteraktif egzersizlerimizden biriyle teoriyi pratiğe dökün
Egzersizi başlat