I'm trying to build an overlay chart with two lines. One line tracks the number of Robin Hood users holding shares of AAL stock. The other line tracks the price of AAL stock.
I downloaded user data from RobinTrack but it's poorly organized. I'm trying to chart the number of daily users (weekdays only) over two years. RobinTrack provides hourly data and includes weekends.
RobinTrack's table has two columns: Date/Time and Number of Users. There are 24 rows for each day time stamped at hourly intervals. I only need one row for each weekday time stamped at 20:45 UTC. So I only need one hour per day and I don't need weekends at all.
The price data is downloaded from Yahoo Finance and is fine. But I need the data from RobinTrack and the data from Yahoo to line up in terms of the date. The date column has to match for both time series I'm plotting (number of users and price).
I've attached a copy of the spreadsheet and an image of what I would like the chart to look like.
Bookmarks