Exploring the Code of “Hands-On Financial Trading with Python”with JetBrains DataSpell

JetBrains DataSpell is JetBrains new IntelliJ-based (the same engine as in JetBrains PyCharm) IDE for Jupyter Notebooks. The principal difference between PyCharm and DataSpell is the focus – PyCharm is an IDE for general Python development and DataSpell is an…
Read More

Jiri Pik’s New Book “Hands-On Financial Trading with Python”

I am very proud to announce the book “Hands-On Financial Trading with Python” written with Sourav Ghosh and published by Packt Publishing on April 29, 2021. The book is available for purchase at amazon.com and at packtpub.com. Front Cover Back…
Read More

Excel vs. Python – when to use Excel and when to use Python?

1. Summary While some authors claim that “Python is the new Excel”, we believe that Excel is the right tool for handling not large amounts of structured information and performing basic interactive data analysis. Excel workbooks serve the role of…
Read More

The Best Libraries and Tools for Development of MS Office Add-ins in 2020

MS Office is one of the most used software solutions in the world – it is installed on virtually all computers and everybody knows how to use it, at least to a certain degree. One of the reasons for its…
Read More

PostSharp and Excel-DNA

Introduction Writing readable and concise source code is one of the key objectives of software development as majority of the total costs of ownership of a software solution is usually spent on code maintenance. Aspect Oriented Programming enables, inter alia, to reduce the amount…
Read More

How to use Advanced Installer for an Excel-DNA Project

1. Introduction Excel-DNA is a game-changing solution for development of XLL Excel add-ons in C# without VSTO abstracting away majority of the C++ implementation details. While a simple XLL add-on requires no registration or installation, the more advanced XLL add-ons…
Read More

Optimal Database Architecture for Super-Fast Access to Historical Currency Market Data in MySQL

folder_openComputing, Computing - Databases, Finance, Finance - Market Data
Introduction The optimal database architecture depends on the structure of the data, the number of the records to be stored, their intended updates (if any), the typical queries and their frequency, and the database engine itself. Each database engine is…
Read More