Cryptocurrency  

Portfolio tracking apps

Portfolio tracking applications help investors monitor the performance of their digital assets in real time. These systems track how much cryptocurrency a user owns, calculate the total portfolio value, and show profit or loss based on the latest market prices. Popular platforms such as CoinMarketCap and CoinGecko provide portfolio-tracking features that allow users to manage multiple assets, including Bitcoin, Ethereum, and Solana.

This article explains the logical concept, database structure, backend API, and frontend implementation required to build a cryptocurrency portfolio tracking application.

Understanding the Portfolio Tracking Concept

A portfolio tracker stores the number of coins owned by a user and calculates the current value using live market prices.

Example portfolio data

CoinQuantityCurrent PriceTotal Value
Bitcoin0.5$68421$34210.5
Ethereum2$3800$7600
Solana10$150$1500

Total Portfolio Value = Sum of all asset values.

Logical workflow of the system

User enters coin and quantity

↓

Application stores the portfolio in a database

↓

Backend fetches live prices from crypto API

↓

System calculates total value of each asset

↓

Portfolio dashboard displays updated values

This logic allows the portfolio value to update automatically whenever the market price changes.

Database Structure

A simple database table is used to store the portfolio.

SQL Table

CREATE TABLE CryptoPortfolio
(
Id INT IDENTITY(1,1) PRIMARY KEY,
CoinName VARCHAR(50),
Symbol VARCHAR(10),
Quantity DECIMAL(18,4)
)

Example data

IdCoinNameSymbolQuantity
1Bitcoinbtc0.5
2Ethereumeth2
3Solanasol10

Backend Implementation (ASP.NET Web API)

The backend performs three main tasks:

  • Store portfolio assets

  • Retrieve portfolio data

  • Fetch live prices and calculate total values

CryptoPortfolioController.cs

using System.Collections.Generic;
using System.Net.Http;
using System.Threading.Tasks;
using System.Web.Http;
using System.Data.SqlClient;
using System.Configuration;

namespace CryptoPortfolioAPI.Controllers
{
    public class PortfolioController : ApiController
    {
        string conn = ConfigurationManager.ConnectionStrings["db"].ConnectionString;

        [HttpGet]
        [Route("api/portfolio")]
        public async Task<IHttpActionResult> GetPortfolio()
        {
            List<object> portfolio = new List<object>();

            using (SqlConnection con = new SqlConnection(conn))
            {
                con.Open();

                SqlCommand cmd = new SqlCommand("SELECT CoinName,Symbol,Quantity FROM CryptoPortfolio", con);
                SqlDataReader dr = cmd.ExecuteReader();

                while (dr.Read())
                {
                    portfolio.Add(new
                    {
                        coin = dr["CoinName"].ToString(),
                        symbol = dr["Symbol"].ToString(),
                        quantity = dr["Quantity"]
                    });
                }
            }

            string api = "https://api.coingecko.com/api/v3/simple/price?ids=bitcoin,ethereum,solana&vs_currencies=usd";

            HttpClient client = new HttpClient();
            var response = await client.GetStringAsync(api);

            return Ok(new { portfolio, prices = response });
        }
    }
}

Backend Logic Explanation

The backend retrieves the user’s portfolio from the database. It then calls the crypto market API to obtain current prices. The portfolio data and price data are combined and returned to the frontend for calculation and display.

Frontend Implementation (Portfolio Dashboard)

The frontend displays the portfolio table and calculates asset values.

index.html

<!DOCTYPE html>
<html>
<head>

<title>Crypto Portfolio Tracker</title>

<style>

body{
font-family:Arial;
background:#f5f7fa;
text-align:center;
}

.container{
width:800px;
margin:auto;
margin-top:50px;
background:white;
padding:30px;
border-radius:10px;
box-shadow:0 0 10px #ccc;
}

table{
width:100%;
border-collapse:collapse;
}

th,td{
padding:12px;
border-bottom:1px solid #eee;
}

th{
background:#f2f2f2;
}

.total{
font-weight:bold;
font-size:20px;
margin-top:20px;
}

</style>

</head>

<body>

<div class="container">

<h1>My Crypto Portfolio</h1>

<table>

<thead>
<tr>
<th>Coin</th>
<th>Quantity</th>
<th>Price</th>
<th>Total Value</th>
</tr>
</thead>

<tbody id="portfolioTable"></tbody>

</table>

<div id="totalValue" class="total"></div>

</div>

<script>

function loadPortfolio()
{

fetch("/api/portfolio")
.then(res=>res.json())
.then(data=>{

let portfolio = data.portfolio;
let prices = JSON.parse(data.prices);

let table="";
let totalPortfolio=0;

for(let i=0;i<portfolio.length;i++)
{

let coin = portfolio[i];

let price = prices[coin.symbol]?.usd || 0;

let value = coin.quantity * price;

totalPortfolio += value;

table += `
<tr>
<td>${coin.coin}</td>
<td>${coin.quantity}</td>
<td>$${price}</td>
<td>$${value.toFixed(2)}</td>
</tr>
`;

}

document.getElementById("portfolioTable").innerHTML = table;

document.getElementById("totalValue").innerHTML = "Total Portfolio Value: $" + totalPortfolio.toFixed(2);

});

}

loadPortfolio();

setInterval(loadPortfolio,10000);

</script>

</body>
</html>

Portfolio Calculation Logic

The frontend calculates the total portfolio value using the following formula.

Total Asset Value = Quantity × Current Price

Example

Bitcoin quantity = 0.5
Bitcoin price = $68421

Portfolio value for Bitcoin

0.5 × 68421 = $34210.5

The application calculates this value for every asset and sums them to determine the overall portfolio value.

Key Features of a Portfolio Tracking App

  • Asset tracking for multiple cryptocurrencies

  • Real-time price updates

  • Total portfolio value calculation

  • Simple dashboard interface

  • Automatic refresh with live market data

Possible Advanced Features

Real portfolio tracking systems usually include more advanced capabilities.

  • Historical profit and loss charts

  • Asset allocation visualization

  • Multiple currency conversion

  • Portfolio performance analytics

  • Mobile-friendly dashboard

  • User authentication and account management

Use Cases

  • Crypto investment tracking

  • Personal financial management

  • Crypto trading analytics

  • Institutional asset monitoring

Conclusion

Portfolio tracking applications are essential tools for cryptocurrency investors. By combining database storage, backend APIs, and dynamic frontend dashboards, developers can build powerful portfolio management systems that automatically update asset values using live market data. With additional features such as charts, analytics, and user authentication, the system can evolve into a full-featured crypto investment platform.

Membership not found