Using Python’s PyAutoGUI and PySimpleGUI

Image for post
Image for post
Photo by CHUTTERSNAP on Unsplash

Every now and again you may require to keep your windows from sleeping or hibernating in its usual timelines. You can, of course, change the settings, but that sounds like too much work for a one-off activity. As such, I built a simple python script to enable me to do just that.

To make it easier to use and of course shareable, I built a UI on top of the underlying script that keeps windows active. The UI is extremely simple, and you can simply close it when you’d like the script to stop running.

The underlying script is again extremely simple, and it uses pyautogui to decrease and then increase the computer’s volume every five minutes (60seconds * 5 minutes = 300 seconds). …


The 10 top commands, to help get you started in your Excel journey

Image for post
Image for post
Photo by Jared Brashier on Unsplash

For the uninitiated, learning some of the “advanced basic” features of Microsoft Excel can have a dramatic impact on their life. It can help save countless hours of manual work, and can even automate certain aspects of it. Depending on the industry and office makeup, it can even help establish you as the office’s computer guru!

Excel is very powerful, and there are very few things that it cannot do. Working in investment banking, I have to use Excel daily, and I am surprised by how little of Excel new graduates know. I am not talking about VBA either; I’m talking about good old in-built formulas. …


The top 5 qualities that supercharge team performance

Image for post
Image for post
Photo by Marvin Meyer on Unsplash.

Time and time again, it has been proven that there exist certain behavioural patterns that lead to high performance. These qualities are further required when individuals are expected to perform as part of a team. Regardless of which stage of your career you are at, overperformance will unequivocally be of interest.

You can undoubtedly think of overperformance at the individual level (i.e. how you personally exceed performance expectations). At the same time, you can also think of it at a collective level (i.e. how a team, department, or organisation can exceed performance expectations). …


Learn the basics in under 5 minutes

Image for post
Image for post
Photo by Denis Pavlovic on Unsplash

In this blog post, we are going to learn about JSON. We are going to learn what JSON is, why it exists, why people use it and finally how to utilise the power of python to help us process it.

As a data scientist, programmer or simply an avid learner of technology, it is important that you understand what JSON is and how to use it. I am certain that you will find numerous applications for it once you understand it.

What is JSON?

JSON stands for JavaScript Object notation and it is essentially a way to represent data. JSON follows a format that humans can naturally understand, and its true power comes from its ability to capture complex data relationships. …


Learn the basics of this derivative product in no time!

TRS is a derivative product that is used widely in the investment banking world. In this article, we are going to cover the main features of a TRS. We are going to cover the following four topics:

  • What is a TRS?
  • What are the different types of TRS?
  • Why would anyone want to trade a TRS?
  • What are the Risk Management considerations of a TRS?

Without any further ado, let’s get started!

Image for post
Image for post
Photo by Lok Yiu Cheung on Unsplash

What is a TRS?

A TRS is an OTC contract, which captures the agreement between two parties to exchange the total return of an asset. Usually, one party agrees to pay the total return of a security (think debt or equity) or a portfolio of securities in exchange for the returns of a reference rate (think LIBOR). …


Image for post
Image for post
LP. ’Photo by Wonderlane on Unsplash

Top 3 integration methods and what you can do with them

Microsoft Excel — you either love it or hate it! If you are like most people, you have probably gone through early life without even hearing about Excel. You may even have gone to college or university, graduated with top marks and still had minimal experience with Excel.

That was until you made it to industry and got yourself a job. You then found out that if Excel were to disappear for an hour, the whole world would come to a halt!

Now, you probably know that there is very little that Excel cannot do! Having spent many years in investment banking, I can tell you that every time I think I’ve seen it all, I come across another spreadsheet someone’s put together! …


Finally a library you can pick up in under 5 minutes

Image for post
Image for post

The beauty of learning python lays within its simplicity and intuitive expression structure. Once you learn the basics, you’re well on your way of building useful and highly functional apps. What supercharges the whole process and puts python ahead of the competition is the abundance of free libraries.

Now and again, a new library will emerge, which changes the game! I think this may be the case in this instance for building web data apps.

Python libraries for building web (data) apps

The most popular web development Python frameworks include Django, Tornado and Flask. They are all very powerful, but they are somewhat technical. They require that you invest a significant amount of time in learning to use them. …


Introduction to Plotly express

Image for post
Image for post

In this blog, we are going to learn how to create interactive visualisations in Python. We are going to start by merely plotting our data in different formats, before exploring adding more interactive controls.

If you have been following me for a while, you would have noticed that this is the third article in the series of data visualisations. We first introduced data visualisations using the default python visualisation library matplotlib. We then learnt how to create animated visualisations over a time-series using the same library.

Today, we are going to learn how to use Plotly express. Plotly allows for user interaction on the visualisations out of the box, and it is much easier to integrate with web content. …


What negativity bias is and how to handle it

Image for post
Image for post
Photo by Xan Griffin on Unsplash

Ever feel that your hard work goes unnoticed? Or that your odd misstep seems to undo all your continuous overperformance? Is it all in your head, or do people, yourself included, focus more intently on the negative? Well, I’m here to tell you that it is not in your head.

In fact, I’m here to tell you that this is so common it has got a name! It is what social psychologists call negativity bias. People are hardwired to focus on the bad rather than the good.

In this article, we are going to explore this effect in detail and discuss specific strategies for ensuring this bias doesn’t hinder your progress both personally and professionally. …


Learn how Market Risk Managers and Traders manage their Risk

Image for post
Image for post
Photo by Benjamin Davies on Unsplash

The Greeks, as they are known in the finance world, are certain market risk measures which allow you to understand how your portfolio would behave under certain conditions.

Market Risk is the risk a market participant is exposed to, due to market factors that cannot be diversified away. Examples of such market factors include Interest Rates, FX, Stock and Commodity Prices.

In essence, the Greeks allow you to know how much exposure (how much money you stand to lose or make) if the market was to move in a particular direction and magnitude.

In this article, we are going to cover the most commonly used Greeks. There are, however, more which we may cover in the future. …

About

Costas Andreou

A technologist with domain expertise in Investment Banking

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store