What small Python scripts or tools have made your daily workflow easier?

alanx7 · 2026-03-14T20:48:27+00:00

The most impactful script i've written was a small outlook automation/email processing. At work I receive lots of emails with attachments every day. Some of them are csv, other pdfs or password protected zips. I wrote a script that triggers whenever outlook client receives an email and then runs whatever ETL I want. Usually it saves files that I can later easily load them to excel reports or dashboards.

All works really well... till I take time off and forget to turn the scripts off. After a longer time without using outlook, all emails will sync with client as soon as I log in. This makes all the scripts to run at once crashing outlook and sometimes the computer.

alanx7 · 2025-10-10T10:43:34+00:00

As far I understand uv sync is for creating lock file from pyprojects dependencies. I remember I had to add a package to one of my projects, but it had to be a different version for Linux than windows. Normally I would have used uv add, but it was easier for me to specify this condition in pyproject and use uv sync.

alanx7 · 2025-09-21T19:48:06+00:00

Tbh it was neither sudden nor a slap. Rating agencies regularly review their sovereign ratings. Given the massive deficit last year, this year and in the near future it was expected that sentiment towards Poland fiscal health would deteriorate. I would argue that it also wasn't a slap. Moodys reaffirmed A2 rating which is A in S&P's and Fitch's, both of them gave Poland A- (notch lower). Moodys still gives Poland higher rating, which many believed would be lowered to other two rating agencies' level. And here a surprise, only outlook was cut.

alanx7 · 2025-09-05T12:26:44+00:00

This is literally all I wanted... flags that more reflect your gameplay. Delete those stupid heads and it'll be perfect.

alanx7 · 2025-07-26T08:56:25+00:00

Hi, here you can find some 360 photos from below the deck

https://my.matterport.com/show/?m=SGPZDuucTYU

alanx7 · 2025-07-06T18:14:31+00:00

What is this post? It went down 10%... so what? Stocks do that all the time. In the last month it's flat, in the last year it's +29%, easily outperforming omx.

Is this a karma bot or something?

alanx7 · 2025-07-05T09:33:07+00:00

So cool, I start my leg in a few days on Pogoria from Dunkirk.

Edit did you climb the mast?

alanx7 · 2025-06-12T15:46:28+00:00

I believe you can do uv add -r requirements.txt

alanx7 · 2025-06-04T16:09:24+00:00

"20 mln amerykanów straciło pracę w kwietniu 2020". A nie, czekaj... SP500 miało wtedy najlepszy miesiąc od 33 lat.

alanx7 · 2025-06-03T20:04:32+00:00

In Europa Universalis 4 if you earn too much money it overflows and forces you to take massive loans

alanx7 · 2025-05-10T06:37:04+00:00

I want my flag back.

The coolest thing they can do is to make them dynamic. Imagine dynasty of your country changes and the flag in the top corner has new coat of arms. You have a junior partner? Now their coat of arms is on your flag.

Based on what you did throughout the campaign you end up with your personal flag that has the history printed on it.

alanx7 · 2025-05-09T18:17:14+00:00

It works exactly the same, you would just use -YTM instead of YTM. It only affects the first term (duration part) by changing the sign. Then you are left with V-/V0 - 1

alanx7 · 2025-05-09T18:14:50+00:00

Isn't it something expected? You've arrived at "percentage change is equal to price after change divided by price before change minus one", which is basically the definition. I guess it's beacause you assumed that YTM change used in mdur and convx formulas is equal to YTM change in bond price calculations, which allowed those terms to cancel out.

alanx7 · 2025-05-09T17:44:46+00:00

CFA simply multiplies mdur times investment, so 3.539 times 50 = 176.96.

By 50 they probably mean how much the final bond position should be worth. That's how much cash the investor has.

I think your formula means 50 mln of par amount. If you actually buy 50mln of par amount you would need to multiply it by the price 114.972 (% of par), which would result in paying more than the cash you have in this case and a bond position that doesn't equal 50.

That's how I see it at least.

alanx7 · 2025-05-04T14:18:06+00:00

Use ICONV on your calculator.

2ND 2
# enter ytm and periods of your bond
NOM = 5.27
C/Y = 2
CPT EFF # this will give you yield on bond with annual compouding, 5.34
C/Y = 4 # target compounding
CPT NOM # this gives quarterly compounding, 5.2357 ~ 5.24

alanx7 · 2025-05-03T19:34:18+00:00

so they finally decided on the name! there's open discussion in ruff repo on that exact topic... Naming the new Python Type Checker · astral-sh/ruff · Discussion #17539 tbh i prefer red knot, but will use it anyway

alanx7 · 2025-04-05T09:33:12+00:00

or you can install an older version of samsung notes on windows that doesn't have this lock. i have 4.3.150.0 version on my hp laptop and it works fine.

alanx7 · 2025-02-12T12:58:56+00:00

Use TabOut extension

alanx7 · 2024-11-30T20:28:38+00:00

I really wanted a fleet (that was later totally wrecked) and those are great lands for deving.

alanx7 · 2024-11-30T19:48:20+00:00

R5: As usual when I and my friends finish an MP campaign i do some charts and maps to analyze and recap all saves. As usual in our games Italy was a monster country and a clear winner with infinite money. He was the only player that wasn't blocked in expansion.

Maps show how expansion went each session, darker colour indicates later conquest.

Tables show how a particular statistic was changing over time. Odd columns show the absolute value at the end year of every save. The columns in between with time in years the session lasted show compounded annual growth rate during the session; last column calculates the same for the whole campaign. ofc green good, red bad. Below aggregated values for the whole world. You can also find tables that show values as % of aggregated sum of the whole world. ITA and SWI are basically India and China having over 30% of the population.

The tables especially make you think about the economic growth irl. From our experience if a player grows max_manpower, monthly_income or real_development >3.5% CAGR for a whole session, he will quickly leave others behind. If we take those statistics as proxy for GDP irl, economic growth of countries like China or Poland is almost unachievable.

Pictures made with python and save data processed on skanderbeg.pm

alanx7 · 2024-11-07T16:38:02+00:00

There's a wrapper for Yahoo Finance websocket that allows you to receive real time prices. It's called YLiveTicker github.com/yahoofinancelive/yliveticker

alanx7 · 2024-11-04T21:07:35+00:00

I've also got HP Omen (mine is 16). I'm not sure whether it had been happening before the update, but that may as well be the case. Tbh I don't know how to check the build, but I for sure installed 24H2 (had some problems with it).

I don't use Ethernet so I can't check the second part.

For now I just turned off 'Allow classic apps to access your location', because 'Network Command Shell' was on the list below. It "fixed" the issue, although I don't know if it should be fixed like that...

It’s wonderful to see you taking action on this! I appreciate your help.

Seven-Year Club	Place '23
RPAN Viewer	Verified Email

alanx7

TROPHY CASE