PMT Forum
How do you want to make money today?

Where to get PSEi historical annual performance?

jerbersoftfx · 8 · 3864

jerbersoftfx

  • Senior Member
  • **
    • Posts: 81
    • Likes Received: +0/-0
hi all,

if this topic already exists, pardon me. please let me know.

i am looking for a website where i can find the annual performance history of the PSEI. anyone know where can we find such data? i am doing some studies regarding the performance of the PSEI. any help will be highly appreciated. TIA!
« Last Edit: Mar 24, 2014, 03:30 PM by FutureGizmo »


lemreyes

  • Forum Tambay 200
  • ***
    • Posts: 219
    • Likes Received: +0/-0
Reply #1 on: Mar 20, 2014, 10:55 AM
You can download PSEi charts from COL and calculate the annual performance.  If I recall correctly the charts there go way back to 1986.

P.S.  You don't have to be a COL member.  Even a demo account can have access to those charts.


TSO

  • PMT Idol 1500
  • ****
    • Posts: 1,639
    • Likes Received: +1/-0
Reply #2 on: Mar 20, 2014, 11:18 AM
Look for the PSEi on Yahoo!Finance, get historical prices, and export it all to Excel. You can compute Y/Y and geometric returns with those.


jerbersoftfx

  • Senior Member
  • **
    • Posts: 81
    • Likes Received: +0/-0
Reply #3 on: Mar 20, 2014, 05:28 PM
@lemreyes, i think you are referring to the downloadables in LHZ format? i don't know gow to use it though. :(

@TSO, i tried but to no luck. nothing happens when i try to download Historical Prices.


INDO

  • PMT Jedi 2000
  • ****
    • Posts: 2,283
    • Likes Received: +5/-0
Reply #4 on: Mar 20, 2014, 08:28 PM
@lemreyes, i think you are referring to the downloadables in LHZ format? i don't know gow to use it though. :(

@TSO, i tried but to no luck. nothing happens when i try to download Historical Prices.

ano po ba yung hinahanap nyo sir? yung yearly OHLC ng PSEi?


TSO

  • PMT Idol 1500
  • ****
    • Posts: 1,639
    • Likes Received: +1/-0
Reply #5 on: Mar 21, 2014, 12:07 AM
@lemreyes, i think you are referring to the downloadables in LHZ format? i don't know gow to use it though. :(

@TSO, i tried but to no luck. nothing happens when i try to download Historical Prices.

Wait, really?

PSE Index Historical Prices @ Yahoo!Finance won't let you DL the table?

...never mind, you're right. I can't even get historical data out of it.

Well, go to this website then. Set the dates and download in Excel format.


kikay_trader

  • Senior Member
  • **
    • Posts: 98
    • Likes Received: +0/-0
Reply #6 on: Mar 21, 2014, 09:53 AM

PSEI HISTORICAL DATA (DAILY END OF DAY QUOTE)
FROM OCT 24, 1994 to MAR 20, 2014
in .XLS FORMAT


if you want annual or per year basis, just pick out the data for dec31 (or last trading day) of each year

Hth.;)
« Last Edit: Mar 21, 2014, 11:17 AM by kikay_trader »


jerbersoftfx

  • Senior Member
  • **
    • Posts: 81
    • Likes Received: +0/-0
Reply #7 on: Mar 21, 2014, 11:16 AM
Thanks kikay_trader. i downloaded the file and it is all i needed. cheers.
« Last Edit: Mar 24, 2014, 03:30 PM by FutureGizmo »


 


PMT Shoutbox

Refresh History
  • Post only questions or comments here. Advertisements NOT ALLOWED.
  • Niel Jhacoubs: Hello sa mga online jan! :)
    Jun 15, 2019, 02:58 PM
  • oragon: :applause:
    May 20, 2019, 03:53 PM
  • FutureGizmo: Thank you for reporting those spam posts, oragon! Spam posts now deleted.
    May 20, 2019, 01:59 PM
  • oragon: Admin kindly monitor some peps! posting and sharing inappropriate nude photos and website links
    May 20, 2019, 01:52 PM
  • @culinary10: Hello I am new here! Regarding sa bdo life insurance for 8 years, pwede pa kaya ma refund yung binayad ko na 50k last year? Gusto ko sana icancel kasi lack of financial na, last may 15 2018 po un nag start ako ng life insurance, pinili ko annually kaso etong may 15 2019 wala nako ma ipay so gusto ko sana icash out, may alam ba kayo kung pano marerefund?
    May 17, 2019, 07:56 PM
  • FutureGizmo: Hi Sonny, the posting issue is now resolved. Thanks for informing us! We're currently testing a new, mobile-ready theme so let us us know kung may problema pa sa Forum. :)
    Apr 04, 2019, 10:40 AM
  • sonny.wapak: Nakaka receive din ba kayo nito pag gawa ng new post? "Please try again. If you come back to this error screen, report the error to an administrator."
    Apr 03, 2019, 10:56 PM
  • leonine_zafiro: what product nun?
    Apr 01, 2019, 10:25 PM
  • dhondiex27: hi
    Mar 30, 2019, 10:55 PM
  • lusart: jayrob i agree 200%. hulog ng langit organico. legit na legit
    Mar 29, 2019, 09:08 AM
  • palemelch: Hi
    Mar 28, 2019, 04:08 PM
  • O.C.W._AK: Magandang Araw sa Lahat! Blessings! (",)
    Mar 28, 2019, 08:42 AM
  • thor15: hello everyone, newbie here
    Mar 25, 2019, 01:47 AM
  • captjaylo: present newbie here
    Mar 22, 2019, 10:06 AM
  • balboagilbert26: hello Guys .. Newbie here
    Mar 21, 2019, 10:55 PM
  • businesswoman2019: @jefsanity nag inquire na po ako pero di sila nagdidisclose. Yung branch po kasi na target ko, currently building pa.
    Mar 21, 2019, 04:27 PM
  • jefsanity: @businesswoman2019, much better inquire ka na lang sa admin nila.
    Mar 21, 2019, 01:51 PM
  • businesswoman2019: Hello! Any idea how much ang stall sa waltermart. 2m x 2m
    Mar 21, 2019, 08:28 AM
  • John Neil: Looking for an accredited iron foundry
    Mar 17, 2019, 03:19 PM
  • jayrob: Mark_Lee ung organico legit po yan..  Member din AQ..
    Mar 17, 2019, 12:57 AM
  • perlymelad: Hello po! Need advice, why my new MLM leaders failing?
    Mar 14, 2019, 08:51 PM
  • perlymelad: Present
    Mar 12, 2019, 07:53 PM
  • kennethmauricio: Hi saan po dito pwede mag post ng for sale properties?
    Mar 11, 2019, 07:58 PM
  • jefsanity: @mark_lee isipin mo anu passion mo at skills mo...
    Mar 11, 2019, 06:52 PM
  • sniperaj09: BAGO LANG
    Mar 10, 2019, 11:16 AM
  • mark_Lee: magandang investnent ngayon sa 30k suggest naman keo mga boss
    Mar 10, 2019, 03:07 AM
  • perlymelad: E-BOOK PO SIR @JEFSANITY
    Mar 09, 2019, 05:40 PM
  • perlymelad: @jefsanity Good Morning Po
    Mar 09, 2019, 05:39 PM
  • perlymelad: Good Day everyone
    Mar 04, 2019, 06:24 PM
  • jefsanity: anu ang small business na yan?
    Feb 28, 2019, 07:40 PM
  • perlymelad: Good Day Everyone
    Feb 28, 2019, 03:31 PM
  • perlymelad: Hello everyone, CAN ANYONE HELP ME SUGGEST ANY SIDE TOPIC  / PROBLEM OF  STARTING SMALL BUSINESS?
    Feb 28, 2019, 06:58 AM
  • perlymelad: Present, 1st time po
    Feb 25, 2019, 06:17 PM
  • jd2281: newbie po
    Feb 25, 2019, 12:26 PM
  • ejllantino: present... 1st time
    Feb 24, 2019, 07:14 PM
  • rheiel: present. first time
    Feb 24, 2019, 11:04 AM
  • MELVIE: thanks po
    Feb 24, 2019, 12:50 AM
  • steph123: hello po, ask lang po, ilang months po ba ang hihintayin after mo ma process ang mga documents para maitama ang mali sa NSO?
    Feb 11, 2019, 03:13 PM
  • Deborah: newbie here.thanks
    Feb 08, 2019, 02:17 PM
  • marj0503: hello im newbie here
    Jan 31, 2019, 10:53 AM
  • yan24: any one here planning to start a tesda skill training center
    Jan 26, 2019, 12:07 PM
  • manzjon: Forex trading forum
    Jan 25, 2019, 02:16 PM
  • Lizette Ramos: Pwede po bang patulong... Maganda po ba ang gasul retailing business?
    Jan 24, 2019, 09:14 PM
  • Imnobody: Hi sino naghahanap ng casino financer dito?
    Jan 16, 2019, 09:59 PM
  • Odlanyer22: Good day!
    Jan 16, 2019, 09:55 PM
  • maryen: at kung sakaling may somobra sa food na nailuto.. dapat po bang bayaran ng client un .. or ipapa take mo na sakanila?...
    Jan 16, 2019, 03:52 PM
  • maryen: HI! GOOD DAY! newbiz lang po... question lang po regarding sa catering.. if may 50pax po ako dapat lang po ba na sakto ang serving ng food?
    Jan 16, 2019, 03:50 PM
  • mark_Lee: cno na nag organico dito scam po ba yun or legit
    Jan 09, 2019, 03:04 AM
  • kuray08: Have a Prosperous New Year to all..
    Jan 06, 2019, 09:27 PM
  • ethan: Sino po may auto supply business dito? How profitable po ba ito in terms of monthly income? Lalo na kung meron na one or two na competition.
    Jan 04, 2019, 11:34 AM