18|ALTERYX – Stock Money?


Great challenge! Here is my work.

1 Like

Challenge_18.yxmd (10.4 KB)
This was so cool I wonder if there is a way to do this quicker for stocks that I have on my watch list

Had fun doing this! This is what I got.
TechHubStonkStocks.yxmd (12.1 KB)

1 Like


Fun using the formula tool and the unique tool!

Cool problem. Didn’t figure out how to put open and 52-week-low prices at 2 decimal places for all of them but the results are essentially the same.


stock_money_18_workflow.yxmd (13.8 KB)

Great one! I didn’t get it perfect but close enough!

Answer


Fun Case. I used text to columns instead.

I enjoyed doing this one!


i

I found it easier to just do a text to column.
Alteryx 1.yxmd (12.1 KB)

This was a fun one!

1 Like

HW16_2.yxmd (11.3 KB)


Finding a solution to this problem really helped me solidify my understanding of the Formula tool. Great practice!

1 Like


Homework 11.3 Pt. 3.yxmd (13.1 KB)
Great practice, always cool to see RegEx in action.

1 Like

Nice work Zach, big fan of your work!!!

I also think that the Unique tool is rather interesting. I love how Alteryx shows the values in the dataset that are either unique and duplicate depending on the output you choose.


Stock Money.yxmd (12.4 KB)

I had trouble figuring out the string functions at first but all in all not too bad of a challenge!

1 Like


Here is my solution.

Challenge18.yxmd (13.6 KB)

1 Like


Stock Money.yxmd (14.3 KB)

This was challenging! Here is my solution!


Challenge 18 Stock Money.yxmd (15.2 KB)
This exercise provided me with some good training on RegEx, rounding decimals, and converting digits to string values. Thanks so much!


TechHub18.yxmd (14.5 KB)

I loved learning about the fixed decimal and how to add symbols.


TechHub Nov3.yxmd (40.1 KB)