Member Avatar for yagapapa

Hey Guys...

My final year project is a dedicated financial indicator system. It calculates the most frequently used financial ratios for users (companies), provides them analysis(compares their results to previous years' results and Industry average, and shows trend graphs

Considering that its a fairly easy project, im not sure whether to make it stand-alone, or web-based.

Now, I could make it stand alone (considering that financial statements companies prepare financial statements at the end of the financial year) but then companie have varying financial periods, Im still in a bit of tangle about this...

Needs some advice on the feasibility of this project, any software that I could possible use for trend graphs (other than excel) and just general opinion would be helpful...

Thanks in advance...
Adam

  • 4 Contributors
  • 6 Replies
  • 107 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by niaz pervez

Dani AI

Generated

A practical path for 's FYP that keeps the work focused and different from a spreadsheet-only solution.

A clear decision criterion is whether industry-wide aggregation (many companies, central averages, percentile comparisons) is required. If yes, a web-based backend makes sense: it centralizes data, simplifies computing industry averages, and supports multi-user access. If the target is per-company offline analysis only, a desktop app with local storage is faster to build and easier to justify for a single-semester project. and rightly pointed out spreadsheets are quick for prototyping; use them to generate sample CSVs and to validate calculations, but not necessarily as the final UI.

Handle varying fiscal periods by treating every statement as date-stamped raw input. Persist start/end dates and a company-specific fiscal-year mapping. Normalize with a small ETL step: map statements into consistent 12-month windows or compute trailing-twelve-month (TTM) values before ratio calculation. Document every normalization choice (calendar year vs TTM) so comparisons and industry averages remain defensible. Public filings (for testing) can be pulled from EDGAR to build a small sample dataset for industry benchmarks (EDGAR).

For charts and tech: web-interactive charts are easiest with Chart.js or D3.js. A desktop prototype can be done quickly with Python + Matplotlib and SQLite (SQLite) for storage. Keep the UI simple: CSV import, fiscal mapping screen, dashboard of 10–15 core ratios, trend charts, and an exportable report.

Scope the MVP tightly: import/normalize, compute verified ratios, show trends, and a basic industry-average compare. Validate every ratio against source filings or a spreadsheet. Include basic data protection (local encryption or HTTPS/auth for web). For and others interested in reuse: provide CSV templates and a small ER diagram so collaborators can reproduce results.

Recommended Answers

All 6 Replies

Member Avatar for yagapapa

thanks ill try to explore it and how i can use it to aid myself

Member Avatar for jwenting

hmm, you could create all of that in a spreadsheet...
In fact that's what most companies have for such systems :)

there is of course no urgency in it for anyone. Most CEOs won't mind waiting a few more days for such longterm historical data.

Member Avatar for yagapapa

hmm, you could create all of that in a spreadsheet...
In fact that's what most companies have for such systems :)

there is of course no urgency in it for anyone. Most CEOs won't mind waiting a few more days for such longterm historical data.

thanks for you reply...

thats exactly the reason why i wanted to do something different, most if not all companies use excel for this type of system, i didnt wanna follow in that trend...Im very hard pressed to do it using something else other than excel because its a final year project...

Member Avatar for jwenting

well, there's a choice of programming languages out there.
Pretty much everything from A to ZZZZZZZ...
Take your pick and start designing.

Member Avatar for niaz pervez

hai......just now i go through your project description as per you given....its really intersting one you pls be give more information about that ...i too want to do the same for my final project if you permit.....pls share the concepts and meterial of that i too gain knowlege on that and share my ideas with you ........

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.