This user group is for anyone who works with money in their data. Maybe you're in the finance or accounting department at your organization, or maybe you use Alteryx to analyze tax and audit data. Perhaps you work at a bank or are a consultant in the financial sector. No matter who you work for or what your title is - if there's money in your data, this user group is for you.
Please join us in sharing experiences, best practices and knowledge.
User Group Leaders:
Has anyone used Alteryx to calculate portfolio standard deviation and beta? Any ideas on how to make these computations given a historical data set.
Solved! Go to Solution.
I noticed that no one has responded to you on this. Is the standard deviation to be calculated on the population? If so, check this macro out:
Also, there is a very interesting Portfolio Optimization workflow (at the bottom of the Community Article below) you must check out related to Portfolio Management, etc:
Thanks following help from you, I have been able to connect the workflow to download data from Quandl through API and find optimal weights as per MPT. Will try to back test this with historical data and see how these recommended weights perform historically.
If you have followed the earlier messages on this thread, I had started out with an initial problem statement of calculating portfolio standard deviation. Over last couple of weeks my problem statement evolved to identifying optimal weights for a given set of stocks when provided for information about their returns and volatility. With help from the community I was able to build two workflows which solved this problem.
I am attaching the first workflow here "Workflow_01_Weekly Stock Price_Quandl.yxmd" with an embedded macro "Macro_01_Stock Price_Quandl.yxmc". This workflow downloads weekly stock price data from Quandl. You can specify the Quandl codes and will also need to enter your API key for Quandl to be able to make this work for yourselves.
Once you download this weekly stock price data, you need to convert this into weekly returns and input this in the second workflow (Workflow_00_MPT_24Nov18_Upload.yxmd"). Following this you need to enter your constraints in the (ub, lb), in the stream which is connecting to Anchor O of the optimization icon in the workflow. The outputs on the browse tool should give you the optimal stock weights.
This is my first post, so please accept my apologies if my explanation is lacking somewhere. Also credits to the community where these workflows already existed and I merely have deployed it for my personal wealth management usage. Some other conceptual limitations from a finance perspective which Immediately come to my mind are that I have not adjusted for dividends / stock splits and to that extent my analysis will be deficient. Yet to figure out a way / database which gives data corrected for dividends / stock splits. Hopefully this will evolve over time.
Thank you so much for these resources! May I ask whether you can post the workflow as a packaged Alteryx file (in .yxzp format)?
So that we can ingest the data and run the workflow. Looks impressive!