StocksCoreApiSharp

This is the core C# library to manage stocks for our StocksWatch application built with .NET MAUI.

Support me

If you want to support me, you can order over following affilate links (I'll get a small share from your purchase from the corresponding store).

• Prusa: http://www.prusa3d.com/#a_aid=AndreasReitberger *
• Jake3D: https://tidd.ly/3x9JOBp *
• Amazon: https://amzn.to/2Z8PrDu *
• Coinbase: https://advanced.coinbase.com/join/KTKSEBP * (10€ in BTC for you if you open an account)
• TradeRepublic: https://refnocode.trade.re/wfnk80zm * (10€ in stocks for you if you open an account)

(*) Affiliate link Thank you very much for supporting me!

Nugets

Package	Nuget	Downloads
StocksCoreApiSharp
StocksCoreApiSharp.SQLite
StocksCoreApiSharp.Realm

Usage

Depots & Watchlists

Depot and WatchList objects can hold Stock items.

// Create a new depot
Depot myDepot = new("My depot")
{
    DateOfCreation = DateTime.Now,
    IsPrimaryDepot = true,
};
myDepot.Stocks.Add(new Stock("Daimler AG"));

// Create a new watchlist
WatchList myList = new("My watchlist")
{
    DateOfCreation = DateTime.Now,
};
myList.Stocks.Add(new Stock("Daimler AG"));

Stocks

The Stock object holds all necessary informaton about a stock or ETF.

// Create a new Stock item
Stock basf = new()
{
    Name = "BASF",
    ISIN = "DE000BASF111",
    CurrentRate = 41.05,
};

// Add transactions to it
basf.Transactions.Add(new()
{
    StockId = basf.Id,
    DateOfCreation = DateTime.Now,
    Amount = 100,
    Price = 64.10,
    Type = TransactionType.Buy,
});
basf.Transactions.Add(new()
{
    StockId = basf.Id,
    DateOfCreation = DateTime.Now,
    Amount = 25,
    Price = 60.10,
    Type = TransactionType.Sell,
});

// Add dividends to it
basf.Dividends.Add(new()
{
    StockId = basf.Id,
    DateOfDividend = DateTime.Now,
    AmountOfDividend = 3400.00,
    Quantity = 100,
    Tax = 300,
});
basf.Dividends.Add(new()
{
    StockId = basf.Id,
    DateOfDividend = DateTime.Now.AddYears(-1),
    AmountOfDividend = 3400.00,
    Quantity = 100,
    Tax = 300,
});

Based on the Transaction and Dividend items, the Stock class will automatically calculate the amount of stocks hold, the total worth and growth.

Database

The library supports SQLite by default. You either can create your own DatabaseHandler or use the provided one.

try
{
    string databasePath = "testdatabase.db";
    // Start with a clear database
    if (File.Exists(databasePath))
    {
        File.Delete(databasePath);
    }
    DatabaseHandler.Instance = new DatabaseHandler(databasePath);
    if (DatabaseHandler.Instance.IsInitialized)
    {
        await DatabaseHandler.Instance.InitTablesAsync();
        Depot myDepot = new("My depot")
        {
            DateOfCreation = DateTime.Now,
        };

        Stock basf = new()
        {
            DepotId = myDepot.Id,
            Name = "BASF",
            ISIN = "DE000BASF111",
            CurrentRate = 41.05,
        };
        basf.Transactions.Add(new()
        {
            StockId = basf.Id,
            DateOfCreation = DateTime.Now,
            Amount = 100,
            Price = 64.10,
            Type = TransactionType.Buy,
        });
        basf.Transactions.Add(new()
        {
            StockId = basf.Id,
            DateOfCreation = DateTime.Now,
            Amount = 25,
            Price = 60.10,
            Type = TransactionType.Sell,
        });
        basf.Dividends.Add(new()
        {
            StockId = basf.Id,
            DateOfDividend = DateTime.Now,
            AmountOfDividend = 3400.00,
            Quantity = 100,
            Tax = 300,
        });
        basf.Dividends.Add(new()
        {
            StockId = basf.Id,
            DateOfDividend = DateTime.Now.AddYears(-1),
            AmountOfDividend = 3400.00,
            Quantity = 100,
            Tax = 300,
        });

        var total = basf.TotalCosts;
        var entryPrice = basf.EntrancePrice;
        var dividend = basf.TotalDividends;
        var growth = basf.Growth;

        myDepot.Stocks.Add(basf);

        Stock daimler = new()
        {
            DepotId = myDepot.Id,
            Name = "Mercedes Benz AG",
            ISIN = "DE0007100000",
            CurrentRate = 55.60,
        };
        daimler.Transactions.Add(new()
        {
            StockId = daimler.Id,
            DateOfCreation = DateTime.Now,
            Amount = 100,
            Price = 58.10,
            Type = TransactionType.Buy,
        });
        daimler.Transactions.Add(new()
        {
            StockId = daimler.Id,
            DateOfCreation = DateTime.Now,
            Amount = 30,
            Price = 38.10,
            Type = TransactionType.Buy,
        });
        daimler.Dividends.Add(new()
        {
            StockId = daimler.Id,
            DateOfDividend = DateTime.Now,
            AmountOfDividend = 5000,
            Quantity = 100,
            Tax = 1200,
        });

        myDepot.Stocks.Add(daimler);
        var totalDepotWorth = myDepot.TotalWorth;
        var overallDividends = myDepot.OverallDividends;

        await DatabaseHandler.Instance.SetStocksWithChildrenAsync(myDepot.Stocks.ToList(), true);
        await DatabaseHandler.Instance.SetDepotWithChildrenAsync(myDepot);

        Depot? dbDepot = await DatabaseHandler.Instance.GetDepotWithChildrenAsync(myDepot.Id);
        Assert.IsNotNull(dbDepot);
        string jsonOriginal = JsonConvert.SerializeObject(myDepot, Formatting.Indented);
        string jsonDatabase = JsonConvert.SerializeObject(dbDepot, Formatting.Indented);

        //Assert.IsTrue(myDepot == dbDepot);
        // Test WatchList
        WatchList watchList = new("My Watchlist")
        {
            DateOfCreation = DateTime.Now,
        };
        basf.WatchListId = watchList.Id;
        watchList.Stocks.Add(basf);

        daimler.WatchListId = watchList.Id;
        watchList.Stocks.Add(daimler);

        await DatabaseHandler.Instance.SetStocksWithChildrenAsync(watchList.Stocks.ToList(), true);
        await DatabaseHandler.Instance.SetWatchListWithChildrenAsync(watchList);
        var loadedWatchLists = await DatabaseHandler.Instance.GetWatchListsWithChildrenAsync();
        Assert.IsTrue(loadedWatchLists?.Count > 0);
        WatchList list = loadedWatchLists?.FirstOrDefault(l => l.Id == watchList.Id);
        Assert.IsNotNull(list);
        Assert.IsTrue(list.Stocks?.Count == 2);

        // Check if the updating works
        var stocks = await DatabaseHandler.Instance.GetStocksWithChildrenAsync();
        Assert.IsTrue(stocks?.Count == 2);

        await DatabaseHandler.Instance.CloseDatabaseAsync();
    }
}
catch (Exception exc)
{
    Assert.Fail(exc.Message);
}