
Ditutup
Disiarkan
Dibayar semasa penghantaran
I need a professional Net Worth Tracker in Google Sheets with a clean, easy-to-understand dashboard and separate tracking sheets for each asset class. Key Requirements 1. Dashboard showing: Total Net Worth (Assets – Liabilities) Asset Allocation (Pie Chart) Net Worth Growth Chart (monthly tracking) Monthly Net Worth Change (MoM) Total Assets & Total Liabilities summary 2. Separate Sheets Needed - Indian Stocks (with P&L tracking + live prices) with the holding details as well as XIRR - US Stocks (USD + INR values + P&L + live prices + USD-INR conversion) with the holding details as well as XIRR - Mutual Funds (with P&L & live NAV tracking) - Crypto (live prices) - Bank Accounts + FDs (manual entry) - NPS (manual entry) - EPF (manual entry) - Insurance (manual entry) - Gold (ETF/SGB/Physical – ETF & SGB price automated if possible) - Liabilities (Home Loan + Credit Card Outstanding – manual entry) 3. Automation Needed - Live updates using formulas for: - Indian Stocks (GOOGLEFINANCE) - US Stocks (GOOGLEFINANCE) - Mutual Funds NAV (auto pull) - Crypto prices (auto pull) 4. Ledger Requirement - Separate transaction ledger sheets for: - Indian Stocks Ledger - US Stocks Ledger - Mutual Funds Ledger Ledger must capture: Date, Ticker, Buy/Sell, Qty, Price, Amount, charges 5. Expected Output Fully functional Google Sheet with correct formulas, formatting and error handling Scalable structure (easy to add new holdings)
ID Projek: 40315328
7 cadangan
Projek jarak jauh
Aktif 23 hari yang lalu
Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
7 pekerja bebas membida secara purata ₹1,363 INR untuk pekerjaan ini

Being a top-rated freelancer with a proven track record in data analysis and automation, I am the perfect fit for your project. I am highly skilled at using Excel and Google Sheets, enabling me to create robust systems such as your Net Worth Tracker with Live Investment Dashboard. My proficiency in both analyzing and scrapping data will make sure that your portfolio's real-time information is accurate and up-to-date, which is crucial for investment decisions. One of my strong suits is my ability to create organized and scalable structures. This means not only will your current holdings be easily manageable but also adding new assets in the future will be a breeze. Along with this, my experience working with formulas, formatting, timelines, pivot tables, charts, and graphs makes me adept at meeting all the requirements mentioned in your project description. Lastly, as your potential freelancer, you will have 24/7 access to professional support, unlimited revisions if needed, and a commitment to meet every deadline while ensuring the highest level of quality. I am confident that my abilities align perfectly with your needs and choosing me would ensure a successful realization of your project vision. Let's create a powerful net worth tracking system that gives you complete control over your investments!
₹1,550 INR dalam 1 hari
4.4
4.4

I already made a share tracker in Google Sheet. What you expect is possible, but, not at your budget. It may cost you around 10k
₹1,550 INR dalam 7 hari
4.2
4.2

This is a well-structured requirement and I can build exactly this. I work extensively with Google Sheets + Google Finance + Apps Script for financial dashboards. Here's my plan: - Dashboard: Net Worth (Assets – Liabilities), Pie chart for allocation, MoM growth chart — all auto-updating - Indian Stocks: GOOGLEFINANCE() for live prices + XIRR calculations - US Stocks: GOOGLEFINANCE with USD-INR live conversion, P&L, XIRR - Mutual Funds: Live NAV via IMPORTXML or a public API endpoint - Crypto: Live prices via IMPORTDATA or API formula - Gold ETF/SGB: GOOGLEFINANCE for ETF prices - Manual entry sheets: FDs, Bank Accounts, NPS, EPF, Insurance, Liabilities — clean input forms Output will be a scalable, error-handled sheet with clear formatting that you can easily update. Happy to start immediately. Let's connect!
₹1,500 INR dalam 7 hari
3.4
3.4

Hello, I can build this as a fully structured Google Sheets Net Worth Tracker with a clean dashboard, separate asset-class tabs, ledgers, live pricing where feasible, and scalable logic. Relevant certifications: FMVA, CFM. 1. What I will deliver 1.1) Dashboard: Total Net Worth, Total Assets/Liabilities, Asset Allocation pie chart, monthly growth chart, and MoM change 1.2) Separate sheets for Indian Stocks, US Stocks, Mutual Funds, Crypto, Bank/FDs, NPS, EPF, Insurance, Gold, and Liabilities 1.3) Dedicated ledgers for Indian Stocks, US Stocks, and Mutual Funds with Date, Ticker, Buy/Sell, Qty, Price, Amount, Charges 1.4) P&L, holdings details, and XIRR for investment tabs 1.5) USD-INR conversion for US holdings and scalable structure for adding new assets easily 2. Automation 2.1) GOOGLEFINANCE for Indian/US stocks where supported 2.2) Mutual Fund NAV / Crypto / Gold automation using available sheet-compatible sources or fallback logic where Google Sheets limits apply 2.3) Error handling, validation, and clean formulas throughout 3. My approach 3.1) Build the structure first 3.2) Connect live pricing and calculations 3.3) Finalize dashboard and testing 3.4) Add a short guide so you can maintain it easily Share your preferred layout/colors and I can start immediately.
₹1,000 INR dalam 7 hari
2.4
2.4

Hello, I can create a comprehensive Net Worth Tracker in Google Sheets with a clean dashboard for you. I am Mubashir Ahmed, a Full-Stack Developer, Engineer, and UI/UX Specialist with 6+ years of experience in building data visualization tools. I understand you need a dashboard that displays total net worth, asset allocation, and growth tracking. - I will design a user-friendly dashboard in Google Sheets showing total net worth, asset allocation pie chart, and monthly net worth growth chart. - I will create separate sheets for each asset class, including Indian and US stocks, mutual funds, and crypto, with live price updates using GOOGLEFINANCE and other APIs. - I will set up automated calculations for P&L tracking and XIRR across all asset classes, ensuring real-time data updates. - I will build transaction ledger sheets for each asset category to record detailed transactions. - I will ensure the Google Sheet is scalable, well-formatted, and includes error handling. I can provide a FREE detailed quotation and project proposal with a suggested roadmap. My Portfolio: https://www.freelancer.com/u/mubashir021 Mubashir Ahmed
₹1,339 INR dalam 7 hari
0.6
0.6

I have done a similar project a week ago. I am sure you will give me more projects after this. I am interested to do this project too and ready to complete this within the timeline. Kindly check my profile to see all rating and reviews given by clients. Hoping to hear from you soon. Payment after completion.
₹1,550 INR dalam 1 hari
0.0
0.0

I understand you need a clean and structured net worth tracker with separate asset sheets and a clear dashboard showing growth, allocation, and monthly changes. I will build a scalable Google Sheets system with automated price updates (via Google Finance), organized ledgers for each asset class, and a simple dashboard for easy tracking. Everything will be designed for accuracy, easy updates, and long-term usability.
₹1,050 INR dalam 5 hari
0.0
0.0

Ahmedabad, India
Kaedah pembayaran disahkan
Ahli sejak Sep 18, 2021
₹1000-4000 INR
₹100-400 INR / jam
$15-25 USD / jam
₹1500-12500 INR
£20-250 GBP
$30-250 USD
$250-750 AUD
$250-750 USD
€250 EUR
₹12500-37500 INR
$8-15 AUD / jam
$15-25 USD / jam
₹600-1500 INR
$250-750 CAD
₹12500-37500 INR
₹400-750 INR / jam
$15-25 CAD / jam
₹100-400 INR / jam
$750-1500 AUD
$1500-3000 USD
$25 AUD