Posts

Showing posts from August, 2019

Data analytics with Python - Installing Numpy

Image
I am now checking out how data-analytics could be integrated technical analysis. My intention is to use pandas and implement some algos of mine. From what I have read, it is better that I be familiar with numpy first. Initially I am thinking perhaps I have to use the pip command to install.  To test that, I called up Pycharm and sure enough. the IDE could not recognize numpy (as it is not installed). Strangely PyCharm actually know the purpose of  numpy and ask me whether I will like to switch to scientific mode. Well according to JetBrains: " Scientific mode in PyCharm  provides support for interactive  scientific  computing and data visualization", so I select enable. Next is to download numpy, Pycharm is really friendly. It gives me an option to load numpy and I do not to use pip.  Nice feature and you can my numpy is now installed with the documentation shown on the right pane. I am going for lunch and will update in this blog what I ...

Python -An enhanced script for ShareInvestor price data and Metastock

Image
Hi, I have implemented a few more things on the previous script. The script now do the following: It auto downlaod the historical SGX price data from the ShareInvestor Website It extracts the data to the correct the folder. It fixed the problem with the ticker symbol. It launches the off-line mode of metastock. For interest, it shows the time take to do the ticker replacement and it also state the total time taken to download the file and launching metastock The script is as follows (until I get my github setup, it will be stored here): #_*_ coding : UTF-8 _*_ # coder : MK Yuen # code time: 06-Aug-19 11:30 AM # file name: Read all files in shareinvestor.PY # Py ver : PyCharm # the problem with shareinvestor data is that the ticker symbol is being read by MS to be the name of the share # as a result, when we run explorer, we get a list of symbols which we need to refer before we know the stock # this is time consuming # for this program, i use os to join path, I be...

Python - make Metastock display ShareInvestor historical data as names instead of symbols

Image
I am new to Python and have decided to learn this language. The last time I learn a language is in my university day which is 40 years ago. Now with almost any information can be obtained from the internet and Youtube, I decided to embark on this journey. What better to start the journey by writing a program I can use. Problem: ShareInvestor.com provide historical data download.The problem is when I use MetaStock, somehow  MetaStock only display the symbol and not the stock name. This cause a problem when I do exploring as the nanme is not reflected and it take time for me to trace what stock does the symbol represent. I spent two days (about a total of 5 hours)  to come out with the script below: #_*_ coding : UTF-8 _*_ # coder : MK Yuen # code time: 06-Aug-19 11:30 AM # file name: Read all files in shareinvestor.PY # Py ver : PyCharm # the problem with shareinvestor data is that the ticker symbol is being read by MS to be the name of the share # as a result...