SMP WILL BE SWITCHED OFF SOON, THANK YOU FOR YOUR SUPPORT

I'm working on an algorithm and I need raw data
#1
First off, I'm a student of Computer Science and I've been following the stock market for quite a while now (I've been playing some simulators successfully but not a lot of trading with real cash for almost 2 years). We're actually using the algorithm for our research paper this semester.

We have the pseudo codes done and it looks really good on paper. Basically it's an algorithm that analyzes historical data, I can't show it in public for reasons. So here's what I really need help on.


1. I want to get raw historical data (at least date, open and close) from 5 tickers from 2011-2016 as a start.
I've downloaded the "2006-present worth of CSV files by Mr. Coelacanth" and for some reason I cant view it on excel (prolly only works on mac), I've tried converting it to different extensions and still nothing. I also have PSEGet v3 but when I download from the PSE site it just keeps failing and they only have coverage for the past 1 year or less.

We want the data to look like this in a text file (notepad).

eg.

Date----------Open----Close

01/01/11------50.15---51.02
01/02/11------50.95---52.30
01/03/11------53.51---58.12


Is there any way I can do this? Kasi wala akong makita na data sa iisang ticker lang. Bali kelangan namin ng 2011-2016 data ng isang ticker lang sa isang file. It would be hard to specifically look for these three specific data points sa specific na ticker mula sa napakaraming PSE daily quotations since 5 years ago haha. Generally, gusto lang namin mapadali kung paano namin makukuha yung data or kahit ano basta makuha lang namin sila.

So medyo yun lang muna. The first question is what we really need right now. I will be updating this thread for more info and stuff. Thanks SMP!
Reply
#2
Fundamental analysis is key to know the market in a clear way. The successful investor is one who is good in predicting the markets. The good your prediction is the more successful you are in the market. The money will float around you and you will be in the ship of money with all sides open for you.
Reply
#3
Have you tried some other version of Excel to view that .CSV file ? I am wondering why it's actually working on Mac, it really makes me wonder. Which software you are using here ? As far as I know you can't open .csv in notepad or so ? Problem is probably simplier than you try to present.
Reply
#4
(07-14-2019, 12:19 AM)Doomgrove Wrote: Have you tried some other version of Excel to view that .CSV file ? I am wondering why it's actually working on Mac, it really makes me wonder. Which software you are using here ? As far as I know you can't open .csv in notepad or so ? Problem is probably simplier than you try to present.

Try notepad++, it is an open source editing tool.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)