# Create a Correlation Table with financial data

Posted 9 years ago
3765 Views
|
2 Replies
|
0 Total Likes
|
 Hello,I am just discovering wolfram alpha and i do not know how to programme so this will be basic but I have not seen the question so I decided to ask it myself. I think that the creation table could be useful for finance. There is an exemple of a correlation table with wolfram programming: http://reference.wolfram.com/language/example/CreateACorrelationTable.html. Firstly, there is a need to choose financial members usch as the members of a stock index (nasdaq,...). This could be similar to the exemple (Get the members of the G8: In Click for copyable input Out[1]= ) but with the companies of a financial index. Is it possible to select the members of the DJIA or the NASAD? Then the second step is to play with the characteritics of these members (capitalisation, PERRatio,...). Has someone tried this already? Otherwise, is there a way to produce an automatical financial analysis of a stock with wolfram alpha?Thanks. I hope that it will also be useful to others people.
2 Replies
Sort By:
Posted 9 years ago
 Well I thoght that I was using wolfram/alpha but I must have switched to mathematica. Thank you for your answer regarding the index. I thought that it would be interesting to find covariances and correlations between characteristics of stocks ( sector, PERatio, margins,...). I was wondering if there is a embryo of big data ai or of artificial intelligence such as grok that looks for patterns in datas. But I admit that I am a tourist and I do not know much. Because from my understanding, the end goal of all these wolfram products is to find patterns in datas and play in an intuitive way with all the patterns that could be useful for business and for science. For exemple in finance, if i ask to look for correlations for the NASDAQ between 1990 and 2000 then it would find a correlation of 0.99 between energy stocks and inflation,... In science, it could find newton's law because all objects that fall have an acceleration of a. Therefore you need to record as much data as possible and then to find patterns in all the datas. Obviously this does not exist yet but as I am just discovering the wolfram products and having read on wikipedia that stephen wolfram wrote " a new kind of science", I was wondering if the embryo of such a general pattern recognition exists so that you only have to give it some data input for patterns outputs. If there is a section that deals more specifically with this, pelase send me the link. Otherwise, thank you for the nasdaq tip, I will use it and play with it. Thank you again, that is helpful.
Posted 9 years ago
 Are you using Wolfram|Alpha or Mathematica? I can't tell. The example at reference.wolfram.com is for Mathematica. You can't exactly program with Wolfram|Alpha. There are a number of different ways to get the members of an index. FinancialData can pull this information from Yahoo Finance in many cases. For example the members of NASAQ can be obtained with FinancialData["NASDAQ", "Members"]. Sometimes you can get this list from a wolframalpha query.