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:

Ticker_Info.jpg

Sentiments:

Ticker_Sentiments.jpg


Watchlist Earnings:

WL_Earnings.jpg


Tickers belong to Watchlist:

WL_Ticker.jpg

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


Import.JPG


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


Imported_TickerInfo.jpg

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

Add_1.jpg

Ticker_Sentiment_Import.JPG

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

Merge_TickerInfo_Sentiments.JPG

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

MergedDate_TickerInfo_Sentiments.JPG

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

WL_Earnings_Imported.JPG

WL_Ticker_Imported.jpg

Merge both data

Merge_WL_WL_Ticker.JPG

After Merge…

MergedWL_WL_Ticker.JPG

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

Merge_TickerInfo_WithWLMerge.JPG

Apply filters:

Apply_Filter.jpg

Now analyse the Net Earnings by Watchlist

NetEarningsByWL.JPG

Sort by Earnings:

NetEarningsByWL_Sort.JPG


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

WL_Focused.JPG


Finding the Stocks belongs to:

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

WL_Focused_Stocks.JPG

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

Feeds_Analysed.jpg

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

Pos_Neg_Sentiments.JPG

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

Positive_Sentiments.JPG


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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply