MarketAnalytics

Stock Strategy implementation - using ASP.Net Core, .Net Core, Entity Framework, Linq with SQLite as database

Technologies Used

1. ASP.Net Core 3.0 (Code first) with Razor
2. Entity framework core (EF core) 6.0
3. linq
4. Google charts
5. Java script
6. SQLite

Nuget Packages Used

1. microsoft.aspnetcore.diagnostics.entityframeworkcore 7.0.3
2. microsoft.aspnetcore.identity 2.2.0
3. Microsoft.AspNetCore.Identity.EntityFrameworkCore 7.0.3
4. microsoft.aspnetcore.identity.ui 7.0.3
5. microsoft.aspnetcore.mvc.newtonsoftjson 7.0.3
6. microsoft.entityframeworkcore 7.0.3
7. microsoft.entityframeworkcore.design 7.0.3
8. microsoft.entityframeworkcore.sqlite 7.0.3
9. microsoft.entityframeworkcore.sqlserver 7.0.3
10. microsoft.entityframeworkcore.tools 7.0.3
11. microsoft.visualstudio.web.codegeneration.design 7.0.3

Summary

This Project allows user to search any global investment entity (Stocks, ETF, Futures, Index and Mutual Fund) and provides following functionality:

1. Store all companies along with their CMP
2. Store historical price data
3. Show SMA chart for 200, 50 & 20 periods
4. Show RSI chart for period value 14
5. Show Stochastics chart for fastk = 20 and slowd = 20
6. Backtest for buy sell algorithms (data table & chart)
   • Show buy indicator when price is below SMA(200/50/20)
   • Show sell indicator when price is above SMA (20/50/200)
   • Identify bullish engulfing pattern (uptrend) and indicate buy & sell opportunities
   • Identify bearish engulfing pattern (downtrend) and indicate buy & sell opportunities
   • Identify uptrend with continuous green candle of at least 20% and show buy & sell opportunities
   • Identify a price date when stock price hit below 67% than lifetime highest close & for that stock check if the CMP is about 50% lower than 52 week highese close for buy opportunity
7. Portfolio
   • Create portfolios
   • Add transactions
   • Consolidate portfolio valuation
   • Individual transaction valuation