How to connect to PostgreSQL database using pgAdmin 4?

 How to connect to PostgreSQL database using pgAdmin 4? In order to set up a connection to the PostgreSQL database, run pgAdmin 4, for example, from the Start menu. As a result, pgAdmin 4 will start. Then click the menu "Object->Create->Server" or right-click on the item "Servers" and select "Create->Server". The server connection settings window will open. On the General tab, we invent and enter the name of our server in the Name field. On the Connection tab, enter the server IP address, username, password, and if you want, you can check the “Save password?” to save the password and not to enter it every time you connect. If the standard port (5432) of the PostgreSQL server has been changed, then you also need to change it here. Press the "Save" button. Note! The PostgreSQL server must be installed, configured and running. We considered an example of installing and configuring PostgreSQL DBMS on Linux Debian in the material “Installing ...

CCI indicator (Commodity Channel Index)

 

Commodity Channel Index (CCI) is translated as "Commodity Channel Index". This non-normalized oscillator was developed by stock trader Donald Lambert, who used CCI to trade the commodity markets. The Commodity Channel Index indicator helps to determine the current state of a financial instrument: overbought or oversold.


The CCI indicator evaluates the current relationship between the price and the simple Moving Average (MA). In other words, the indicator shows the deviation of the instrument's price from its average values. Maximum CCI values ​​indicate that quotes have risen significantly and deviated upward from average prices, while minimum values ​​indicate that quotes have already fallen quite strongly and deviated downward from average prices.