Real-Time Investment Portfolio Tracker

I require the development of a potent portfolio that operates on Excel, sheets, or is web-based. Ideal candidates should have significant experience in API integration as this feature will be heavily relied upon for fetching live market quotes. Expertise in programming languages like Python, Java, or similar is essential.

Key Features:
- The portfolio should fetch live quotes from the market in real-time, ensuring uninterrupted access to the latest trading information.
- It should be capable of tracking several parameters including promoter holdings, market capitalization, and periodic returns like 1D, 3D, 1M,....10Y, Daily volume, RSI, dividend
- For example, I must be able to use a formula like =getquote("ticker") and the latest price should appear and must refresh automatically
- The tool must calculate profit and loss, letting me promptly assess its financial performance.

Despite trading is not a part of this project, the watchlist feature should be there for market tracking. Freelancers with prior experience developing financial tracking tools stand a better chance of winning the project.