-
Important update on 16. February 2019: Some links, and especially downloads links on this personal website may not be uptodate, as I recently transferred the whole site from www.finaquant.com to software.tuncalik.com.
Give me some time; I will check and correct them one by one.
I decided to offer all the software introduced on this website open-source and free.
Check my shared folder for most uptodate downloads. Open-Source downloads of the C#/.NET libraries Finaquant Calcs and Finaquant Protos are also included in this shared download folder as zipped Visual Studio 2012 files.
You may contact me if you need any help or consulting for my analytical software.
Follow me
-
Recent Posts
- Minimum Total Loss Rounding in Python
- Travel and Assignment Planning Software in Python
- Top-Down Distribution of Quality Measurement Requirements using Table Functions in Python
- A Simple Notation for Data Tables
- Calculating Sales Commissions in Excel
- How to Add a User-Defined Table Function to Excel
- How to Apply a User-Defined Function on Rows of a Table in Excel
- Empowering Excel with Table Valued Functions
- Testing Table Valued Functions with LINQPad
- Building a Web Service that Receives and Returns Data Tables
- Optimizing Marketing Investment
- Reporting with ReportViewer in Visual Studio
- Simulation of Dealer Commissions with Matlab
- Finaquant’s Matrix and Vector Functions
- Table Function Demo with Microsoft Excel
Recent Comments
No comments to display
Tag Archives: excel
Table Function Demo with Microsoft Excel
As mentioned earlier in a related article Table Functions of the .NET libraries finaquant® calcs (commercial) or finaquant® protos (non-commercial) can be called from an excel sheet. Following example demonstrates: How Table Functions can be called from excel macros (VBA) … Continue reading
Table Functions in Visual Basic (VB.net)
Table Functions of our .NET (dot net) libraries finaquant® protos (non-commercial) or finaquant® calcs (commercial) can be called in other .NET languages including Visual Basic. The ability to call Table Functions in Visual Basic can make the transition from VBA … Continue reading
Calling table functions from Microsoft Excel
This article explains how the table functions of the non-commercial .net library finaquant® protos can be called from within Microsoft Excel using VBA macros. Two possible integration options are presented here: 1) Calling a .net method from an Excel macro … Continue reading
Importing and Exporting a DataTable from/to an Excel file
As explained in the related article, a MatrixTable of finaquant can easily be converted to or from a DataTable of the .net framework (ADO.net). That is, importing or exporting a MatrixTable from/to an excel sheet can be accomplished in two … Continue reading