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
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
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
Now merge the merged watchlist data with Ticker_Info to bring Tickers additional Info(Industry,Sector,Name,etc) as well
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