General Business Automation

  • All
  • Articles
  • Blog Post
  • General Business Automation
  • Portfolio
  • Stock Market & Finance
General Business Automation, Stock Market & Finance

Analyzing Stock Data Efficiently: A Benchmarking Study

February 27, 2025

When working with financial data, efficiency matters. Traders, analysts, and data scientists rely on various storage formats—CSV, Parquet, and SQLite—for backtesting trading strategies. But which format offers the best performance? In this post, I benchmark three widely used storage formats while backtesting Apple Inc. (AAPL) stock data. The goal? To determine which format provides the fastest execution time while ensuring accuracy across different trading strategies. The Experiment I…

Articles, General Business Automation

Google Sheets Email Alert Reminder

March 12, 2024

This is just my solution to reminders for open items. This uses a combination of Google Sheets & Google Apps Scripts. I am a big fan of using Google Apps Scripts for email notifications/alerts. This example will send up to 3 emails provided columnD does not say “Complete” Google Sheets Sample Layout Google Apps Script Code Trigger Setup I then schedule this to run every day at a…

Articles, General Business Automation

Emailing With Google Apps Scripts

December 7, 2023

The purpose of this is to show how you can use Google Apps Script to send an email of files in a Google Drive Folder. This stemmed from a project and my approach to the solution. The goal of the project was – create 500 PDFs and email those PDFs out using the Google Suite of products. I ended up generating PDFs using python due to efficiency and…

Articles, General Business Automation

Excel + VBA To Create A Unique File For 500 Stocks

December 7, 2023

The purpose of this is to demonstrate the power of VBA with formatting a file, creating a pivot table, and saving files as PDFs. The PDF portion is something I’ll be exploring over a series of posts, but long story short – VBA is more powerful than Google Apps Script for creating PDFs. In addition, it is easier to create a PDF template in Excel vs python. We…

General Business Automation

Creating A Google Form Using Google Apps Script

June 25, 2023

I recently learned that you can create a Google Form by calling a function in Google Sheets. I am going to demonstrate how this is possible using Google Apps Scripts. The code above does the following The above should give a taste for what is possible. This process is also useful if you want to share the Google Sheets file that logs the responses of the Form /…

General Business Automation

Leads Tool: Sending Outlook Emails With Excel

June 9, 2023

Introduction This tool enables control of: In addition, you can create drafts of the email to manually review/proof or automatically send the emails. For example, I proof 2 emails and once I am happy with how they look, I automatically send 500 emails to reach out to everyone more efficiently. Tiers & Pricing There are 3 Tiers of versions of the tool. The lowest tier provides the most…

General Business Automation

Create Google Calendar Events From Excel File

May 13, 2023

This project came about because I like to create project plans starting in Excel. I was curious to see if I could put meetings on my Google Calendar. A direct link to the notebook can be found on my github. Google Developer Console Setup Python CodeImport & Setup Read In Excel Source File Update Google Calendar

Prev
12
Next
Github

All rights are reserved.