I have a table which looks like the one in the attachment

This is done in excel but i will be automating it in a linux EC2 AWS server instance
I can get the ‘Today NAV’ value from an API call in the linux AWS ec2 server & update all other values using formulas.
How do i create this kind of table and output to a pdf file using CLI and bash scripting only?
PS : Its a pdf because i ll be using it to send an email daily to my gmail id so i can view the statement on my cell phone.
Thank You for the help.

Attached Thumbnails

 

You haven't tried to create a PDF file from the CLI? Regarding BASH scripting, how well do you know it?

As you know, it is helpful to other members to understand what expertise you have with these actions so they can best offer you suggestions.

There are a variety of commands or tools to convert text or standard output to a PDF file, text2pdf, and convert are two options.

My most common statement about BASH scripting is that whatever you can write in the command line, you can put into a BASH script, where the command line is the equivalent of live scripting.

Please take the time to look up and choose a PDF generation tool or command, verify you have it, or can install it on your system. If you find one and have trouble installing it on your system, then post the specification of your distribution and we'll help first with that.

Next, people can help with BASH scripting, and as I said earlier, it would be helpful to know if you already know how to write and use a script, of any language, BASH or other.