Support Board

Date/Time: Fri, 03 May 2024 19:18:33 +0000

Post From: all Financial Excel Functions

[2015-09-07 18:10:15] Link To Thread - Link To Post [Go To First Post]
User572003 - Posts: 1
Hello, I decided to evaluate SierraChart because I hit his structure with spreadsheets inside, which enables a bidirectional data flow, from SierraChart to the spreadsheet and from the spreadsheet to SierraChart. However, considering the functions provided by the spreadsheet, I noticed that they are only part of those found in Excel. In fact, I expect to find all the functions of Excel! In particular, all those financial. So the question I ask to the technical support is this: how can I take advantage of the beautiful idea of spreadsheets integrated without renounce to a part of the functions of Excel? For example if you wanted to calculate the yield to maturity of a bond with semi-annual coupons given the price (for example, the futures price), and redemption at maturity (typically 100) I can do this now with Excel easy,but with spreadsheets integrated in SierraChart, there isn't this function. So, the question is: The only solution is to jump integrated spreadsheets and pass the data to Excel, or is there a way to expand the functions of the spreadsheets in SierraChart integrated with those of Excel? Thanks for your attention Antonino