COL Financial, one of the largest stockbrokers in the Philippines, provides fundamental and technical data to investors and traders. However, the data are separated, with discrepancies in timing and limited variables, posing challenges for users to identify potential investments and trades.
This app addresses these challenges by:
- Aggregating fundamental and technical data from multiple sources into a single source of truth.
- Updating the data using the most recent information, addressing timing discrepancies.
- For example, the All Shares Index updates data in real-time, the Investment Guide updates data weekly, and the Technical Guide updates data daily. The decision to buy and sell a stock should happen in real-time to maximize opportunities and minimize risks.
- Creating new variables from old variables, providing additional insights.
- Some investors would like to see a stock price with respect to its fair value to assess its valuation, while some traders would prefer to consider a stock's price relative to its 52-week high to gauge its strength.
- Visualizing data to identify potential investments and trades, facilitating informed and timely decision-making
Please note that the app is not affiliated with COL Financial and has some limitations, such as the lack of historical and fundamental data for some stocks, as well as some data being estimated by analysts. Nonetheless, the app still provides valuable insights for investors and traders in the Philippine stock market.
Click here to watch the COL Financial App Demonstration video.
To use the app, follow these simple steps:
- Create an xlsx file.
- In the file, create three sheets namely ASI, IG, and TG for All Shares Index, Investment Guide, and Technical Guide, respectively.
- Copy and paste each data from the website of the stockbroker to its respective sheet.
- Upload the file to the app.
Once the file has been uploaded, the app will then output a xlsx file containing the aggregated data, providing a comprehensive view of the stock market for investors and traders.