Your cart is currently empty!
Author: jcianci12
-
SQL Cheat Sheet
List all rows in a table: SELECT * FROM table_name; List specific columns in a table: SELECT column1, column2 FROM table_name; Filter rows using a WHERE clause: SELECT * FROM table_name WHERE condition; Update rows in a table: UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition; Insert rows into a table: INSERT…
-
Placing a TP profit and Stop loss order using CCXT and BINANCE
After trying many different ways of doing this with ByBit I gave Binance a shot. This seems to work fine and means that I dont have to worry about cancelling the tp/sl order if the other order is triggered!
-
Fixing inconsistently formatted Australian mobile numbers… in excel! 😎
Here is the excel formula: This formula checks if the first character of cell M2 is 0. If it is, it concatenates “+61” with the rest of the characters in M2 except the first one. If not, it checks if the first three characters of cell M2 are “+61”. If they are, it returns M2.…
-
By-bit spot stop loss and take profit orders.- My findings!
After trying so many different ways to place these types of orders on the exchange, and no real success, I ended up doing this: First we need to place our order. We can do so like this: Notice we have saved our order into a csv called “orders.csv”? We can now use this to check…
-
How to add a remote folder share as a remote git repository in vs code?
In some cases, you might just wanna push your code to a network folder and use that as your remote. This will also work without vscode as long as you can get to the command line and you have the necessary folder permissions. Here is how 👍 First you will need to initialise your remote…
-
Simple way to sort dates in any format with jquery.datatables
Initially, I was formatting the date in my table using any format I liked. However, I soon realized that this would ruin sorting. For example, if you have a table with dates formatted as “dd/mm/yyyy” and “mm/dd/yyyy”, datatables will sort them incorrectly because it will sort them based on their underlying serial numbers. Then I…
-
Solving Issues with Bybit v5 Python API
Introduction: Recently, I encountered an issue while using the Bybit v5 Python API. After running for a few hours, the API would stop working properly and I would receive an error message stating “invalid request, please check your server timestamp or recv_window param”. After some investigation, I discovered that the solution was to sync the…
-
Getting Started with Windows Server Using VHDX and Enabling Nested Virtualization! 🚀🔌💻
Introduction: Welcome to our step-by-step guide on using a VHDX image to quickly get Windows Server up and running, along with enabling nested virtualization. This comprehensive tutorial will walk you through the process, making it easy for you to harness the power of Windows Server within a virtual environment. Let’s dive in! 🎉 Setting Up…
-
Converting from DOCX to PDF for thumbnails
I recently needed to show some thumbnails of docx files online. Here is what I came up with. Please note that this will not create a perfect thumbnail. In fact its quite basic. It allows the user to simply see that the file contains something. Nevertheless, I hope you find it helpful! Here is the…
-
🌎💻 Converting Lat Lng to XY Coordinates: A Guide
As someone who works with geographic data, I often need to manipulate latitudes and longitudes. Recently, a researcher requested that I convert a list of latitudes and longitudes to XY coordinates to obscure the actual location of the points while still allowing for analysis of the distance relationship between them. Here’s how I did it,…