You are a stock analyst who was recently hired at a stockbroker called Stonks Stocks. The company does stock performance reports on the 11th of every month and compares the open price to the 52-week low of each stock. It’s February 11th and your boss would like you to analyze some of the most popular stocks that the company’s clients hold for the report. He gave you some instructions and you got right to work. Thankfully, you still remember what you learned in your Data Analytics class and decided to use Alteryx for this job.
The “Stock” column includes the ticker & open price for the stock.
Separate the “Stock” column into a “Ticker” column and “Open" column.
Calculate the % in which the 52-week low increased by to get to the open price and put it into a new column. (Show 4 decimal places)
Add a $ to the numbers in the “Open” & “52-week low” columns by making new columns and naming them “Open Price” & “52-Week Low”.
Add a % to the column that has your % you calculated from 3. by making a new column and naming it “Increase %”. (Should look like: 45.21%)
Filter the data to only show stocks that had a 25% or more increase in their 52-week low.
You noticed that the data has some duplicates, so make sure to get rid of them.
Sort the data with the “Increase %” column in descending order.
These should be your column headers in order: Ticker, 52-week low, Open Price, Increase %
I opted to use regex and I kept the original “Open”, “52-Week Low”, “Increase” columns to see the effect of different data types on sorting. This one, I sorted by “increase” DESC which is a “double” data type. I tried sorting by “increase %” which is a “V_WString” data type and seems like the results are the same.
Great Challenge! Super quick and fairly simple with a few catches to look out for. I opted to parse the data with RegEx because that’s what I’m most comfortable with. I’ve attached a screen shot of my solution as I am unable to attach my Alteryx file.
I liked using the remove duplicate tool in this practice. I probably wouldn’t have considered checking for duplicates, but is something I will do going forward! It is helpful having a tool that can check for and remove duplicates quickly.