Computing

A black square with white DS and an underscore, overlaid on overlapping geometric shapes in blue, green, and yellow.

Exploring Code of Hands-On Financial Trading w/ Python with 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…
Book cover titled Hands-On Financial Trading with Python by Jiri Pik and Sourav Ghosh, featuring a chart with red and blue candlestick patterns on a dark background—ideal for those interested in Algorithmic Trading with Python.

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…
A close-up of financial spreadsheets with charts and graphs. A black pen points to a figure in red, and various numbers and colored segments are visible, indicating financial analysis or business data review.

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…
A stylized blue outline drawing of an elephants head, with thick white and black borders. The design is simple and icon-like, commonly used as the logo for PostgreSQL, an open-source database system.

How to Set Up the Latest Version of PostgreSQL on AWS Linux 2

Although AWS does provide their own RDS service for running PostgreSQL I recommend it only (1) if you frequently require restoring the database up to a particular minute’s snapshot and (2) if the CPU usage of the database server would…

PostSharp and Excel-DNA

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 of…
A blue CD with a puzzle piece pattern and an orange puzzle piece partially fitting into the empty spot on the disc.

How to use Advanced Installer for an Excel-DNA Project

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 with rich…
A close-up of an electronic forex board displays various currency pairs and exchange rates, with green arrows indicating positive changes in value.

Optimal DB Architecture for Fast Access to Historical FX Data in MySQL

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 optimized…
keyboard_arrow_up