Built My Stock Tracker on Libreoffice Calc.

 The other day I built mutual fund tracker on LibreOffice Calc. Today I built my Stock Tracker using LibreOffice Calc.

Suppose the Stock is HDFC Life whose symbol is HDFCLIFE.NS on Yahoo Finance.

Open a new Spreadsheet. Click on Sheet/Link_to_External_Data and enter the URL as https://query1.finance.yahoo.com/v7/finance/download/HDFCLIFE.NS and press Enter.

After a few minutes (may be seconds) the Data will come click Ok and Ok to CSV.all

The Data will come in two rows for the day.

You can select the third row and link another URL say for SBI as https://query1.finance.yahoo.com/v7/finance/download/SBIN.NS and press Enter.

The Data can be updated every day by selecting Edit/Links_to_External_Files and clicking on Update Button.

How to convert a password protected pdf to unprotected pdf.

 Suppose you send your password protected Bank Statement in pdf to some entity to show your financial capacity the other party can't read it without password.

You can convert the password protected pdf to unprotected pdf using pdftk.

pdftk /home/user/Documents/BankStatement.pdf input_pw password output /home/user/Documents/BankStatementcopy.pdf

Replace password with actual password.

The BankStatementcopy.pdf will be an unprotected pdf and could be opened by anyone and you can send it.