Make more money with SAP Lumira (Stocks Analysis Story)

Here we go….

I have some money and i want to make some more (which everyone wants to)….investing in stocks is a good option but it may end up in losing as well. So picking the right stocks by maintaining a good portfolio is the key to get a profit. Let see how SAP Lumira can help to capitalize the money making business

Let’s say I have created my portfolio(Watchlist) by picking some of the stocks and want to analyze how they are doing in a current market trend to invest more

Data Source:

I have four tables with the following data which can act as a source for analysis

• Information about Stocks (Tickers)
• How the market feels about the stocks (the Positive and Negative sentiments)
• Watchlist earnings
• Stocks belongs to watchlists

Ticker Info:

Sentiments:

Watchlist Earnings:

Tickers belong to Watchlist:

Bringing the Data into SAP Lumira and Merge:

Now let me bring these data into SAP Lumira by simply importing them by picking the required fields

After the import of Stocks information, this is how it looks like

The information about how the market feels about the stocks, basically we call it as Sentiments are stored as different data set. Let’s import them as well by clicking Add

Now Merge Ticker Info and Ticker Sentiments to get some additional info from both the source

After the Merge, the merged data would be like as follows…

The quick analsyis can be performed on top the above merged data.But lets bring Watchlist data also here.

Lets import “Watchlist earnings” and “Stocks belongs to watchlist” in a similar way and merge

Merge both data

After Merge…

Now merge the merged watchlist data with Ticker_Info to bring Tickers additional Info(Industry,Sector,Name,etc) as well

Apply filters:

Now analyse the Net Earnings by Watchlist

Sort by Earnings:

Filter(focus) the Watchlist with max Net Earnings(basically the first bar)

Finding the Stocks belongs to:

Lets find the stocks belongs this Watchlist so that we can invest more on that

The Stocks HLIT(Harmonic Inc.) and LXK(Lexmark International Inc) yielded a good profit.

From this I can arrive that the stocks Harmonic Inc.(HLIT) belongs to Communication Equipment sector and Lexmark International Inc.(LXK) belongs to Computer Based Systems sector yielded me good profit so that I can invest more on that.

Analyze the Sentiments:
Let’s analyze the sentiments about these two stocks

First focus on the no of feeds about these two stocks, from the social media

Bring the Positive and Negative Sentiments in the chart to have a look

The Positive Sentiments are more in case of HLIT compare to LXK

Similar analysis can be performed with other watchlists and stocks to make more money which everyone want to have, with the help of  SAP Lumira

Rgds,

Murali