Business

Binance Terminologies

Market Data Endpoints These endpoints provide real-time and historical market data for different cryptocurrencies traded on Binance. This data includes information such as the current price, trading volume, order book depth, and more. Account Endpoints These endpoints allow developers to access information about their Binance account, including balances, trade history, and open orders. They also…

Read more

Part 1 Machine Learning for Trading – From Idea to Execution

Algorithms are a sequence of steps or rules designed to achieve a goal. They can take many forms and facilitate optimisation throughout the investment process, from idea generation to asset allocation, trade execution, and risk management. Machine Learning (ML) involves algorithms that learn rules or patterns from data to achieve a goal such as minimising…

Read more
Mac OS
Database

MySQL Foreign Key Referential Actions

Referential Actions When an UPDATE or DELETE operation affects a key value in the parent table that has matching rows in the child table, the result depends on the referential action specified by ON UPDATE and ON DELETE subclauses of the FOREIGN KEY clause. Referential actions include: CASCADE: Delete or update the row from the parent table and automatically delete or update the matching rows in the…

Read more

Let’s Discover Microsoft Access

Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the professional and higher editions. MS Access Objects MS Access uses “objects” to help the user…

Read more

Some of The Most Important SQL Commands

SELECT – extracts data from a database UPDATE – updates data in a database DELETE – deletes data from a database INSERT INTO – inserts new data into a database CREATE DATABASE – creates a new database ALTER DATABASE – modifies a database CREATE TABLE – creates a new table ALTER TABLE – modifies a table DROP TABLE – deletes a table CREATE INDEX –…

Read more
Programming

A Basic Python main()

In some python scripts, you may see a function definition and a conditional statement that looks like the example below: In this code, there is a function called main() that prints the phrase “Hello World!” when the Python interpreter executes it. There is also a conditional (or if) statement that checks the value of __name__…

Read more

Regular Expressions Based on Syntax Used by Perl

Symbol(s) Meaning Example Example Matches * Matches the preceding character, subexpression, or bracketed character, 0 or more times a*b* aaaaaaaa, aaaaabbbb, bbbbbbb + Matches the preceding character, subexpression, or bracketed character, 1 or more times a+b+ aaaaaab, aaaabbbbb, abbbbbbb [] Matches any character within the brackets (i.e., “Pick any one of these things”) [A-Z]* APPLE,…

Read more

Bank Account Question

Write an algorithm to settle the following question: A bank account starts out with $10,000. Interest is compounded monthly at 0.5 per cent per month. Every month, $500 is withdrawn to meet college expenses. After how many years is the account depleted? State the current bank statement total is $10,000 State the monthly rate is…

Read more

Part 1 Machine Learning for Trading – From Idea to Execution

Algorithms are a sequence of steps or rules designed to achieve a goal. They can take many forms and facilitate optimisation throughout the investment process, from idea generation to asset allocation, trade execution, and risk management. Machine Learning (ML) involves algorithms that learn rules or patterns from data to achieve a goal such as minimising…

Read more

Bash: Reading Input

The read command is a builtin command that reads from the standard input. By default, it reads until a newline is received. The input is stored in one or more variables given as arguments: read var If more than one variable is given, the first word (the input up to the first space or tab)…

Read more

Bash: Printf

printf: formatting and printing data printf FORMAT ARG … The FORMAT string can contain ordinary characters, escape sequences, and format specifiers. Ordinary characters are printed unchanged to the standard output. Escape sequences are converted to the characters they represent. Format specifiers are replaced with arguments from the command line. Escape sequences are single letters preceded…

Read more
Public Share