SERV.LO.CI

If you are looking for broadband connection and want honest review about timbl broadband, My suggestion is no. Please do not subscribe timbl broadband.

Within 3 month of service, I found that their field service worker are not serving at all. Your money will be wasted and no one come to help neither they bothered to help you again.

I made 100+ calls to rectify the connection but all in vain. Finally , I decided to discontinue the service and advise other to do same.

Do not go with it. Choose any other.

This is frequently found error while running plumber proxy ( such as nginx)

location /api/ {
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_pass http://localhost:9977/;
}

Match settings in nginx config . Rewrite url and proxy pass have ending “/” . This is working solution , tested on nginx on ubuntu ( 18.04)

Install R Kernal :

Info could be found at https://github.com/IRkernel/IRkernel

install.packages('IRkernel')
IRkernel::installspec()

# in R 3.3
IRkernel::installspec(name = 'ir33', displayname = 'R 3.3')
# in R 3.2
IRkernel::installspec(name = 'ir32', displayname = 'R 3.2')

Why you need ssh key for cloud server ?

This is one time setup which enable quicker and safe login experience . Username ,password login is no longer safe and reproducible. Switch to ssh login for quicker and secured login system.

How to generate it ?

Step 1: ssh-keygen -t rsa -b 4096

Step 2: Read keys and print it content , so you can copy-paste it in destination ssh keys (public key)

Step 3 : Login using ssh

ssh -i /path/to/ssh username@host_ip

I am sharing this with my experience and this is for retail investors. According to my experience , top 3 stock brokers are :

1. Zerodha
2. Upstox
3. Samco Securities

Zerodha is best due to technical superiority,clean UI, lowest brokrages.
Pros:

1. lowest brokrages – zero brokrage for delivery . Huge savings
2. Easy interface.. Anyone will love it. Clean,organized and beautiful
3. Good intraday margin for quality stocks
4. Nice Calculator
5. Nice Backoffice Admin

Cons :

1. On volatile days, system slows , login errors and some client report unexpected trade executions
2. Slower response to customer query.
3. No margin on cash-n-carry delivery trades

Upstox :

Upstox is replicating zerodha model. Backoffice is not just good as Zerodha. Two noticable advantages on Upstox compared to zerodha is –

1. Upstox started providing 2x margin on delivery trades at rate of 20/50000 excess margin utilized.
2. API trading and historical data cost is cheaper than zerodha. API trade through upstox is 850 vs 2000 of zerodha. Similar historical data api is 550 vs 2000 of zerodha.

Both upstox and zerodha calculate same day squareoff trades as intraday. This is saving for both. Trader have to pay less transaction tax(STT) and Brokers earn some brokrages( as their delivery model is zero brokrage). Here brokrage is huge savings .

Samco is for long term quality traders. Samco brokrage is bit higher but with Samco Plus, you get upto 4x margin on selected stocks. You need to pay interest on extra margin utilized but in most cases, it is favor of you. Samco earn interest and more brokrage. You can buy more stocks in multi-legged strategy. With investment of re 50000, buy reliance worth 200000 and upon a simple per stock profit of 50, you can earn 4000 ( simple calculation ) with investment of just 50000 and it is without huge risk . You can buy stocks at 1300 and mamage free fall upto 1100 with any worries. When price will move upward after 15-30 days, still income is good. Samco for long term trading.

from pymongo import MongoClient
client = MongoClient()
db = client.database
collection = db.tables

You need to import pymongo to connect python with mongo database. Later, connect to running instance of mongo ( default at 27017) . You can use dcker to run mongo instance *single,multiple or cluster)

import psycopg2
from psycopg2.extras import RealDictCursor
from datetime import date
connection = psycopg2.connect(user = "root",
                              password = "password",
                              host = "localhost",
                              port = "5432",
                              database = "database")
cursor = connection.cursor(cursor_factory=RealDictCursor)
cursor.execute("""select * from table where date(created_at)=%s order by id desc limit 100""",(date.today(),))
res=cursor.fetchall()

Explanation :

First you need to import required module.For postgres database access,psycopg2 is latest and recommended modue. RealDictCursor is required to get data in proper dictinary form otherwise data will arrive without column name( hard to guess for wide tables).

Create a connection object with defined connection string. Prepare query. Execute it with a cursor and fetch result from cursor . Fetching and selections will be discussed in later series.

You can start with it. Use the data to apply different types of visualization or draw useful conclusions using python,postgres,pandas and python visualization library