Python can be used for various tasks. One of these is Monte Carlo simulation for future stock analysis. In the video below this is exactly what is happening. 🙂 Instead of explaining the video and its code (available also in…
Category: Just Tricks
All the other languages.
Python – Data Wrangling with Excel and Pandas
Data wrangling with Excel and Pandas is actually quite useful tool in the belt of any Excel professional, financial professional, data analyst or a developer. Really, everyonecan benefit from the well defined libraries that ease people’s lifes. These are the…
Tagged with: combine reports, dataframes, Excel, export, filtering, fix, import, mergining, missing values, Pandas, Python
Sine and Cosine – A friendly guide to the unit circle
Welcome to the world of sine and cosine! These two functions are the backbone of trigonometry, and they’re much simpler than they seem. In this article, we will explore the unit circle, the home of sine and cosine, and learn…
Rule of 72
Ever heard of the Rule of 72? It’s a classic finance shortcut that tells you how many years it takes for an investment to double at a given interest rate—without reaching for a calculator! Pretty much, if you want to…
Automated Stock Diagrams with Python
Automated stock diagrams with Python is actually a rather useful idea, if you want to see how your portfolio is distributed. Just by using 2 columnes – “Ticker” and “Shares” in a CSV file, you can obtain a lot of…
From Pythagoras to Law of Cosines
The field of geometry offers tools that have withstood the test of time, empowering us to understand and solve a variety of triangular problems. Among these, the Pythagorean Theorem and the Law of Cosines are cornerstone concepts. This article provides…
Tagged with: explanation, law of cosines, plotting triangle, pythagorean theorem, Python, Video, youtube
Solving Triangle Medians and Cevians with Python
If you remember some advanced math problems with triangles, where you have some cevians and medians, that split a triangle’s side into a 4:3 ration and you have to find the ratio of the split of the two cevian itself,…
Solving Inequalities with Interval Method
Have you ever had a feeling you need to solve an inequality like this one ((x+6)^3)/(7-x)^5>0 and you did not know how to start? In the video at the bottom of the page I am showing the few steps needed,…
Python – Getting an Excel List of all Folders and Files in them
Getting a list of all folders within a given folder is actually a single line command. Writing it to Excel is usually another line. Getting all files, within these folders is not a lot as well. However, having a tool…
Linear Algebra – Drawing with Vectors – 3d and 2d
Plotting 2d and 3d vectors into a 3d space can be actually fun. Using mainly the code from Math for Programmers, I am presenting in this video an example of plotting 2d into 3d and back, using identity matrix and…
Python – Cramer’s Rule for Linear Equations – With YouTube Video
Creamer’s rule for a solution of linear equations states pretty much the following: Using this interesting picture from the German Wikipedia, I have created the following video, explaining a bit the Rule of Mr. Cramer: The video goes through the…
Tagged with: cramers rule, Excel, Jupyter, Jupyter Notebook, linear equations, Python, solution of a system
Go – “While Do” and “Do While” loops in go
Ok, so the golang language does not exactly have the word “while” in it. Anyway, the do-while and while-do loops can be easily implemented with a for loop. The main difference between the do-while and while-do is that in the…
Git Log tricks
The idea here would be to show some git log tricks and to develop the article, whenever I find something more and more worthy. Before starting this one, please remember that exiting vim editors in the command prompt is with…
VBA – Get Substring Between 2 Substrings – Locate value of Nth XML
Getting N-th string between two substrings might sound a bad idea, until you do not need it. And with VBA, you better have something prepared. So, imagine the following XML (from this article here):
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
<FootballInfo> <row> <ID>1</ID> <FirstName>Peter</FirstName> <LastName>The Keeper</LastName> <Club name ="NorthClub"> <ClubCoach>Pesho</ClubCoach> <ClubManager>Partan</ClubManager> <ClubEstablishedOn>1994</ClubEstablishedOn> </Club> <CityID>1</CityID> </row> <row name="Row2"> <ID>2</ID> <FirstName>Ivan</FirstName> <LastName>Mitov</LastName> <Club name = "EastClub"> <ClubCoach>Gosho</ClubCoach> <ClubManager>Goshan</ClubManager> <ClubEstablishedOn>1889</ClubEstablishedOn> </Club> <CityID>2</CityID> </row> </FootballInfo> |
Your task is to get…
Tagged with: between substrings, locate, mid, str, string, string between 2 strings, Substring Between 2 Substrings, VBA, xml
Python – Virtual Environment
This is a short step-by-step introduction on how to build virtual environment in Python and how to use it. Virtual envirnments keep dependencies, required by the specific project separated. Thus, it is the “clean and clear” place of the project,…
Creating a visualization – Messi vs Ronaldo
They say practice makes perfect and in order to improve my data visualization skills I recently took up a weekly challenge. There are multiple ones depending on your interest and tool of choice, most of them advertised on Twitter. Whether…
Excel – Get Top Row of a Multi Row / Mult Column Range
=VLOOKUP and =INDEX(MATCH(),MATCH())Â are well known formulas, if you need to get some value corresponding to another value from a specific column. The problem comes, when you are having more than one column or row, and you need to locate the…
Format and Color Text in Excel Cell with VBA
Formatting a substring of a string in an Excel Cell is actually quite a challenging task. There are two ways to do it – select part of the substring that you wish to format and change its color. Then make…
SQL – Make XML from a SQL database
Some time ago I have decided to go a little deeper into SQL. And by some time ago I probably mean some years. Anyhow, in this article I will present the ways I know to make XML out of SQL…
Google Chrome Extension – Building a simple extension for VitoshAcademy.Com
In this article I will simply let you know, that vitoshacademy.com has its own google extension now – it simply shows you  the last 10 articles in the site and it lets you know if there is a new one.…
Tagged with: Creating Google Chrome Extensions
JavaScript – Make a RegEx Text Tool
Plenty of Regular Expressions tools are available in the net. Most of them are free and quite quick. I have actually never thought that building such a tool can be done rather quickly, as far as the RegEx is part…
JavaScript – A function returning a function returning a function
Working with JS may be difficult for a beginner. Or for someone like me, who dares to think of himself as a … let’s call it not a beginner. 🙂 One of the strangest staff there, if you are coming from the…
jQuery – Forms And Automatic Selectors
Although VitoshAcademy is not an  Academy, there should be some educational stuff. Thus, in this article I have decided to put something educational. 🙂 Let’s see how to make a simple selector in jQuery, which updates below some text, based…
jQuery, JS – Build a Probability Simulator
Some time ago a king needed money. So he gathered his advisors and told them to think of a new task. One of them offered to tax stupidity. The king asked one question – how. The guy came up with a…
jQuery Events – Trigger vs TriggerHandler
Let’s start from the very beginning in jQuery. Somewhere in the beginning there are events and buttons. So, I will start from there, explaining how to Trigger events and what is the difference between trigger and triggerHandler. Trigger triggers the event completely…
jQuery Mobile – Make a simple mobile web site
Building web sites is for at least 20 years a thing. Even I am able to build one, using WordPress without some advanced IT skills. Lately, I was into jQuery and thus I found something really meaningful and well written…
JavaScript – Create Ul and LI elements with JS (With chained function)
When you code in JS, there is always some time that you need to create some html list with JS from array or list or something else. I knew the trivial way with a simple for loop, but when I put myself…
Tagged with: Create Ul and LI elements with JS
JavaScript – Some code for inheritance in JavaScript
The last month I am writing mainly small pieces of code for JavaScript, because I think I start to like the language somehow (and I took 3 books for review in JS and so far I have only reviewed one).…
JavaScript – How to make a module in JS
Making a module in JS is kind of interesting. Especially, if you expect something like a class like in VBA or C#. Well, it has nothing to do with it, it is just a function, assigned to a variable. In…
Tagged with: module in JS
JavaScript – Some ways to build functions in JavaScript
There are plenty of ways to make functions in JS. However, the nicest ones are to assign the function to a variable and to call the variable. Why this is the nicest one? Well, probably because I cannot make something…
Tagged with: functions in javascript
Top