ONLYOFFICE / DesktopEditors

An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents
https://www.onlyoffice.com
Other
2.64k stars 311 forks source link

Proposal to Add New Financial Formulas to Spreadsheet Editor #1588

Closed eSkry closed 3 weeks ago

eSkry commented 3 weeks ago

This issue is unique.

Your idea.

Issue: The spreadsheet editor lacks sufficient formulas or the existing ones do not consider all necessary parameters for yield calculation.

Description: Manually writing simple yield formulas is required to calculate investment returns, especially for bonds. Additionally, there is a need to calculate compound yield, which involves iterating over dates, date ranges, etc.

Proposal: Add additional yield calculation formulas to the financial formulas category. Required formulas are described here: (PDF File)

rsnegirev commented 3 weeks ago

Hi @eSkry

Can you please specify any of this formulas? I mean maybe some examples from other editors.

Because we usually don't create unique functions to make each file more compatible between different editors.

Also in the next major version will be release a new feature with creating users custom formulas.