Excel-VBA and Python Scripts for Business

Useful Python and VBA for applications scripts to automate routine. 

  • How to remove any custom tags from text (strings) using Python

    BS4 and other tools allow to remove HTML tags (.decompose(), .get_text() etc.) but there are situations when strings contain some other markup which cannot be filtered out by standard tools. This function in Python allows to set the tag mask which needs to be removed and removes all occurrences.

    Read more ...  
  • Unisender API functions in Python

    A few functions in Python for Unisender email marketing automation. Tested on Unisender. Probably works on Selzy too.

    Read more ...  
  • How to send mass emails directly from Excel using VBA without Merge

    A version of this script has been used to create personalized emails for a list of clients. In my opinion this is much cooler than the in-built merge function because it allows to automate complex calculations and generate any kind of personalized email (even with HTML markup), attach files (which you can also generate on the go right before you send) and whatever else comes to your mind.

    Read more ...  
  • How to check if a file exists in Excel-VBA

    Today we will discuss different ways to check if a file exists in Excel-VBA.

    Read more ...  
  • Network effects as value drivers for online digital companies

    This research develops valuation methodology of digital companies which exploit network effects. The main asset of companies of this type is their user base. The business model design makes the user base of many of the companies to be directly observable and measurable by any user in the network (wholly or at least partially through sampling). This creates an opportunity for market participants to get an in-depth understanding of the state of the business of the company. This research starts with a brief recap of the key characteristics of networks and dynamic processes on them. After that the most common business model patterns of network companies are mapped and analyzed using business model canvas. Having obtained the mechanics of the business and the qualities of networks of users the DCF valuations are conducted. The baseline DCF simulations use top-down approaches for projecting cash-flows, growth and risks and the test case simulations use network science based approaches. The last part of the research is devoted to empirical testing of the influence of the network effects on company pricing using cluster analysis and multiple regression techniques. The findings of this research are of a value to valuation practitioners, standard setters and IR departments. ​

    Read more ...  


Support the project

Please feel free to support me on Patreon.