The information contained in this forum have been submitted by third parties directly without any verification by us. The information available in this forum is not researched or purported to be complete description of the subject matter referred to herein. We do not under any circumstances whatsoever guarantee the accuracy and completeness information contained herein.
www.srilankaequity.com its blogs, forums, subdomains and/or its affiliates and/or its web masters, administrators or moderators shall not in any way be responsible or liable for loss or damage which any person or party may sustain or incur by relying on the contents of this report and acting directly or indirectly in any manner whatsoever.
Trading or investing in stocks & commodities is a high risk activity. Any action you choose to take in the markets is totally your own responsibility, www.srilankaequity.com its blogs, forums, subdomains and/or its affiliates and/or its web masters, administrators or moderators shall not be liable for any, direct or indirect, consequential or incidental damages or loss arising out of the use of this information. The information on this website is neither an offer to sell nor solicitation to buy any of the securities mentioned herein. The writers may or may not be trading in the securities mentioned.
Find Past Data of Daily Stock Market Values in EXCEL
Find Past Data of Daily Stock Market Values in EXCEL
I'm looking for a source to get all the past data (at least 01 year) of each company daily stock market values such as Maximum, Minimum and Closing.

ss7097- Manager - Equity Analytics

- Posts: 108
Points: 631
Join date: 2011-01-28
Re: Find Past Data of Daily Stock Market Values in EXCEL
ss7097 wrote:Hi,
I'm looking for a source to get all the past data (at least 01 year) of each company daily stock market values such as Maximum, Minimum and Closing.
If you have CDAX, you can check under "OHLC values". This will give info you seek.
slstock- Admin
- Posts: 2547
Points: 4057
Join date: 2011-01-22
Re: Find Past Data of Daily Stock Market Values in EXCEL
slstock wrote:ss7097 wrote:Hi,
I'm looking for a source to get all the past data (at least 01 year) of each company daily stock market values such as Maximum, Minimum and Closing.
If you have CDAX, you can check under "OHLC values". This will give info you seek.
Hi slstock, I'm using DirectFN. Who is the broker having CDAX?

ss7097- Manager - Equity Analytics

- Posts: 108
Points: 631
Join date: 2011-01-28
Re: Find Past Data of Daily Stock Market Values in EXCEL
Where can I find "OHLC values" in CDAX ?
Thanks

wmdcf- Manager - Equity Analytics

- Posts: 104
Points: 644
Join date: 2011-01-29
Re: Find Past Data of Daily Stock Market Values in EXCEL
wmdcf wrote:Dear slstock,
Where can I find "OHLC values" in CDAX ?
Thanks
Go to
View->market watch->OHLC values
slstock- Admin
- Posts: 2547
Points: 4057
Join date: 2011-01-22
Re: Find Past Data of Daily Stock Market Values in EXCEL
ss7097 wrote:slstock wrote:ss7097 wrote:Hi,
I'm looking for a source to get all the past data (at least 01 year) of each company daily stock market values such as Maximum, Minimum and Closing.
If you have CDAX, you can check under "OHLC values". This will give info you seek.
Hi slstock, I'm using DirectFN. Who is the broker having CDAX?
Asha Phllips also provide CDAX with DirectFn
slstock- Admin
- Posts: 2547
Points: 4057
Join date: 2011-01-22
Re: Find Past Data of Daily Stock Market Values in EXCEL
ss7097 wrote:Hi,
I'm looking for a source to get all the past data (at least 01 year) of each company daily stock market values such as Maximum, Minimum and Closing.
Go to site : http://www.slstock.com/stock/#
Click on: Click here to login as a guest user
Click on : Stock movement details
Give the stock code: ex: hnb
Then you can get last 5 or 6 years data

MarketResearch- Senior Manager - Equity Analytics

- Posts: 477
Points: 1290
Join date: 2011-01-30
Location: Colombo
Re: Find Past Data of Daily Stock Market Values in EXCEL
*Go to this site
*Login as guest user
*Go to stock movement details (with MACD)
*Give relevant stock code, start date and end date & submit
*You'll get all the data you want

SmartMoney- Equity Analytic

- Posts: 48
Points: 552
Join date: 2011-02-07
Re: Find Past Data of Daily Stock Market Values in EXCEL

SmartMoney- Equity Analytic

- Posts: 48
Points: 552
Join date: 2011-02-07
abra12- Manager - Equity Analytics

- Posts: 139
Points: 625
Join date: 2011-02-10
Re: Find Past Data of Daily Stock Market Values in EXCEL
SmartMoney wrote:http://www.slstock.com/stock/Login.jsp
*Go to this site
*Login as guest user
*Go to stock movement details (with MACD)
*Give relevant stock code, start date and end date & submit
*You'll get all the data you want
I am the first .(-95 Points)

MarketResearch- Senior Manager - Equity Analytics

- Posts: 477
Points: 1290
Join date: 2011-01-30
Location: Colombo
Re: Find Past Data of Daily Stock Market Values in EXCEL
MarketResearch wrote:ss7097 wrote:Hi,
I'm looking for a source to get all the past data (at least 01 year) of each company daily stock market values such as Maximum, Minimum and Closing.
Go to site : http://www.slstock.com/stock/#
Click on: Click here to login as a guest user
Click on : Stock movement details
Give the stock code: ex: hnb
Then you can get last 5 or 6 years data
This is really good post. I gave my first vote (that is a positive vote) to you.
Academic- Senior Manager - Equity Analytics

- Posts: 443
Points: 1054
Join date: 2011-01-23
Re: Find Past Data of Daily Stock Market Values in EXCEL
Academic wrote:MarketResearch wrote:ss7097 wrote:Hi,
I'm looking for a source to get all the past data (at least 01 year) of each company daily stock market values such as Maximum, Minimum and Closing.
Go to site : http://www.slstock.com/stock/#
Click on: Click here to login as a guest user
Click on : Stock movement details
Give the stock code: ex: hnb
Then you can get last 5 or 6 years data
This is really good post. I gave my first vote (that is a positive vote) to you.
Thanks.
Please do not do that.
Do not block my journey to -100.
Pls add as much as -(Minus.)
Thanks again.

MarketResearch- Senior Manager - Equity Analytics

- Posts: 477
Points: 1290
Join date: 2011-01-30
Location: Colombo
Similar topics» Find Past Data of Daily Stock Market Values in EXCEL
» What is your expected Return Per annum from Stock Market?
» Stock Market Bottom - 5 Methods to Help You Spot a Market Bottom
» COLOMBO STOCK MARKET MOVEMENTS

» Harmonic Price Pattern Trading
» Guys what do u think about Kuru
» Motor Sector Analysis
» How would if SF released effect to cse ?
» Oil has come down further
» Which stock are seasonal?
» All banks have shown tremendous growth, even though people thought....
» Commercial credit's revenues gone up.....
» Invest 1.5M in Sri Lanka
» What wil happen tomorrow
» What about HVA
» Dow තියරි
» Future of Motor Sector share price
» Face Book First Day
» Thought for the Day
» ASI 3000 level ??
» 10 Things CEOs Won't Tell You
» Sri Lanka HDFC Bank net up 79-pct in March
» Buying Stocks When The Price Goes Down: Big Mistake?
» DFCC damn it
» Profit Loss Calculator
» Taprobane (TAP) another fraud discovered!!
» Useful links to Stock Market Books
» 1000 Posts Club
» Averaging the Buy Price to Minimize Risk: A Common Mistake of Stock Traders
» Learning From Trading Losses
» President Signs papers to release Sarath Fonseka
» Sampath will get interest on money paid to TFC sellers
» සිංගප්පූරු ආයෝජකයින් පිරිසක් ශ්රී ලංකාවට පැමිණෙයි
» Facebook sets richest tech IPO in motion
» A year of uncertain economic fortunes
» Forex gains buoy banks
» අනාවැකිය හරියට හරි
» 10 investment lessons
» Welcome New Admins, Co-Admins and Moderators
» Is this the best time to average (greg)?
» Securities Exchange Act to be amended
» Stock Market Quotes
» SLT hurt badly by rupee depreciation
» SEC Investigating Taprobane Securities For Multiple Offenses On The NSB Deal
» Online forex autotrading
» Fishermen to pay more for boats
» Myanmar’s central bank aims for weaker currency
» Why the Selloff in Emerging Market Currencies Could Worsen
» Bribery Commission to probe NSB-TFC deal
» Entertaiment Spot: All Are Welcome
» What do you think of GREEN FEILD COCONUT plantaion in Wanatawilluwa Puttalam?
» Rule of Law and accountability in the management of public funds
» DPL does well but notes cost pressure in fuel, power and wages
» Singer in deal to import high-quality office furniture
» Sri Lanka's postal service goes hi-tech amidst falling mail volumes
» Future demand for rubber continues
» “Bring those responsible to justice” – BT poll respondents say
» Lying, cheating and silence
» Lies and deception surround NSB-TFC deal
» Stock Market Cartoons
» Rs. 1 bn MBSL loan for Navara to buy MBSL Savings Bank ?
» Sri Lanka controversial stock sale to state bank reversed
» NSB අධ්යක්ෂක මණ්ඩයෙන් සුමනදාස අබේගුණවර්ධන ඉල්ලා අස්වේ
» Virtual Stock Market Game (VSTOX)
» What do you guys think about KAPI?
» Sri Lanka to hold 3rd anniversary celebrations of war victory on Saturday
» ෆොන්සේකා ඇප මත නිදහස් කිරීමට නියෝගයක්
» Historic Facebook debut falls short of expectations
» AEL what you guys think?
» Sri Lanka to establish new scheme to grant dual citizenship
» SHL at 10.70
» ඉල්ලා අස්නොවන බව NSB සභාපති කියයි
» Why fluctuations in the banks interest rate influence to Econmy of the country?
» Corporate Actions Announced on 18th May, 2012
» Taprobane buys back the TFC shares it sold to NSB
» Contribution of top 10 securities to the change of ASPI
» Following Stocks Reached New Low on 18/05/2012
» Sri Lanka overturns ill-fated National Savings Bank-The Finance Co. deal
» AGALAWATTE PLANTATIONS PLC, DIVIDEND
» Lowest turnover
» Trade Summary Market - 18/05/2012
» Sri Lanka president vows to free ex-army chief' AFP
» GREG Gonna Be HOT......
» Don’t fear a market crash. Embrace the opportunities.
» Companies effected due to rupee value depreciation
» සෙලාන් බැංකුවේ ලාභය 2012 දී 59% න් ඉහළට
» SF will be released unconditionally-Anoma
» Sri Lanka consumer durables retailer March net up
» Sri Lanka Hayleys March net up 78-pct
» HAYL - Interim Report - 31.03.2012
» Fonseka granted conditional bail
» Cabinet approves SF’s release
» WHAT DO YOU THINK ABOUT LGL
» Bond rates has come down 2nd time for the week.
» Dr. Jayasundera said the exchange rate could even strengthen to Rs. 50
» Taprobane Securities says...
» F & G Share certificates ?
» Brave hearts are well rewarded!
» Following Stocks Reached New High / Low on 17/05/2012
» Preparing for a downturn?
» Spot Gold Price-Live Update
» Spot Sliver Price-Live Update