Median prices
There are times when the median is a better tool than the mean. Lets imagine that you are analyzing the stock data in the DataFrame prices again. You want to know if the stock's price is trending down by comparing the opening and closing prices. Remember the DataFrame has the columns OPEN, HI, LOW, and CLOSE.
This exercise is part of the course
Intermediate Python for Finance
Exercise instructions
- Calculate the median of the opening prices.
- Calculate the median of the closing prices.
- Compare the opening and closing medians to get the trend.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Get the median of the opening prices
med_open = ____.loc[:, '____'].____()
# Get the median of the closing prices
med_close = ____.____[:, '____'].____()
if ____ > ____:
print("Trending down.")