Friday, June 19, 2020

Why should you learn Python?

There is great value in learning Python.

You may want to read this link to learn the use cases of Python.

Insurance: creating business insights with machine learning
Retail banking: flexible data transformation and manipulation
Aerospace: meeting software system deadlines
Finance: data mining to identity cross-sell opportunities
Business services: API access to financial information
Hardware: automating network administration
Healthcare: predicting disease prognosis
Consulting services: bespoke web development
InfoTech: IT modernization
Software: adding extensibility to legacy applications

Source:
https://www.activestate.com/resources/datasheets/top-10-python-use-cases/


Python is also used for backend in Web Applications where it is used for scripting
2) Desktop GUI Applications.
3) Software Development. ...
4) Scientific and Numeric. ...
5) Business Applications. ...
6) Console Based Application. ...
7) Audio or Video-based Applications. ...
8) 3D CAD Applications.

For more applications read here:
https://intersog.com/blog/python-application-development-common-use-cases-and-project-examples/

Read all Python-related posts in this blog:
https://hodentekhelp.blogspot.com/search?q=python

Thursday, June 18, 2020

Butchered by the Chinese on the heights of the Himalayas

He went there to serve the country and he fell defending it.

Chinese are flexing their muscle to grab more land in the Ladakh area. During the most recent, serious skirmish, we lost one of our sons. May his soul rest in peace.



Colone B. Santosh Babu
File picture: Colonel B Santosh Babu|Photo Credit: IANS



Source: AFP
Image caption
The cremation ceremony for one of the Indian soldiers killed took place on Thursday

Here is a picture of a club of sorts that appears to have been used in the brawl.



It is crude even by MING standards!




Tuesday, June 16, 2020

Hard to figure this one out in Excel

There is such a thing called a rogue!

It did once in all these years (30 yrs) I have used EXCEL. I simply cannot figure it out. I include a screenshot of what I observed.




As a workaround, I deleted the line and recreated it. Everything OK.

Thursday, June 04, 2020

How do you access financial data like stock portfolio using MS Excel?

I know a couple of ways. I describe two of them.

First Method:

Excel has a built-in data type called Stock that you can use.


StockDataType-0.png

This allows you to do most things with the stock portfolio.

Details here:
https://hodentek.blogspot.com/2020/05/three-easy-steps-to-work-on-your-stock.html

Although you can get most information of a stock, still some data such as 'dividned' is not available. Microsoft may change and add this as well.

Second Method:
It is easy to import financial data from a site such as Yahoo. The following steps show with step-by-step screen shots how you may get the data in the Yahoo's web page. The next screen shown uses the ribbon to get data from WEB.


In the URL type in the Yahoo URL for the Quote page filtering MSFT (Microsoft).

Click OK and you may need to wait it out.

Stick with anonymous. That's OK. I
In the above, click Connect.
 Well. have patience.
The Navigator shows up.


All that remains is for you to choose the data in the web page.

The following are the ones for Document, Table1, Table2 and Table 3.




Table 2 has the Dividend information.










DMCA.com Protection Status