Index Match equivalent VBA program in Excel

In Excel, the

INDEX

and

MATCH

functions are commonly used together to perform lookups that are more flexible than

VLOOKUP

. To achieve similar functionality in VBA, you can create a custom function or use VBA code to mimic the behavior of

INDEX MATCH

. Here's how you can do it:

---

VBA Programming 106 reads 0 comments Print

Creating an Arduino-based home automation system

Creating an Arduino-based home automation system can be a rewarding project. Below, I will provide a simple example of home automation code using Arduino. This setup will control a few basic appliances like a light, fan, and other devices through a relay module using sensors and a Bluetooth module. 

---

Microcontrollers 104 reads 0 comments Print

Python Code to Calculate CPR - Central Pivot Range

The Central Pivot Range (CPR) is a popular technical analysis tool used by traders to identify potential support and resistance levels in financial markets. It consists of three levels: the Pivot Point (PP), the Bottom Central Pivot (BCP), and the Top Central Pivot (TCP). Here's how you can calculate the Central Pivot Range in Python:

---

Programming Languages 191 reads 1 comment Print

ESP32 Complete Project : Wi-Fi-connected weather station using the ESP32

The ESP32 is a powerful microcontroller with built-in Wi-Fi and Bluetooth capabilities, making it an excellent choice for IoT projects. Let's create a sample project where we build a Wi-Fi-connected weather station using the ESP32, which will display temperature and humidity readings from a DHT22 sensor and send the data to an online dashboard. (ESP 32)

---

Microcontrollers 122 reads 0 comments Print

Implementing an AI trading system on a Raspberry Pi

Implementing an AI trading system on a Raspberry Pi can be an exciting project that combines finance, machine learning, and embedded systems. Here’s a step-by-step guide to get you started:

---

AI and ML 159 reads 0 comments Print

Sources of free data available across topics, such as weather, population and geographical data

There are many sources of free data available across a variety of topics, such as weather, population, and geographical data. Here are some notable examples:

---

General 142 reads 0 comments Print

Create or convert - an NFT (Non-Fungible Token) art

Creating an NFT (Non-Fungible Token) art involves several steps, including creating digital artwork, minting the artwork as an NFT, and listing it on a marketplace. Here's a step-by-step guide:

---

General 132 reads 0 comments Print

Creating an AI engine that generates images based on text queries

Creating an AI engine that generates images based on text queries involves using a pre-trained model like OpenAI's DALL-E or similar models. However, as these models are quite large and require substantial computational resources, you typically use a pre-trained model available via an API.

---

AI and ML 145 reads 0 comments Print

Simple graphics game in Python - Step by Step Guide

How to create the Catch the Dot game using Python: Step by step guide and full source code

---

Programming Languages 155 reads 0 comments Print

Simple python program to learn AI and ML for students

Here's a simple Python program to help you get started with basic concepts in artificial intelligence (AI) and machine learning (ML). This program demonstrates how to build a basic machine learning model using the popular scikit-learn library.

---

AI and ML 121 reads 0 comments Print

OpenGL OBJ viewer using PyQt5 and PyOpenGL in Python

we will create an OpenGL OBJ viewer using PyQt5 and PyOpenGL in Python. This viewer will support color and lighting to make the 3D models look more realistic.

---

Programming Languages 257 reads 0 comments Print

Plot candle sticks with OHLC data from url - Python code

How to Plot candle sticks with OHLC data from url complete Python code

---

Programming Languages 208 reads 0 comments Print

A real-time OHLC (Open, High, Low, Close) generator from 1-minute Last Traded Price (LTP) data in Python

To create a real-time OHLC (Open, High, Low, Close) generator from 1-minute Last Traded Price (LTP) data in Python, we need to continuously fetch the LTP data, update our OHLC values, and store or display them in real-time.

---

Programming Languages 281 reads 0 comments Print

Sample python code for intraday scalping

Intraday scalping is a trading strategy that involves making multiple trades within a day to take advantage of small price movements. Below is a sample Python code for a simple intraday scalping strategy using moving averages. This example will use the

yfinance

library to fetch historical stock data and the

pandas

library for data manipulation.

---

Programming Languages 117 reads 0 comments Print

How to handle keyboard press events in Python - Step-by-Step Guide

To handle keyboard press events in Python, you can use the

keyboard

module. This module allows you to listen for keyboard events and execute code in response. Below is a guide on how to use the

keyboard

module to handle keyboard press events.

---

Programming Languages 184 reads 0 comments Print