I’m straggling to download historical data for my masters thesis. I need daily prices (only one per day e.g. adjusted close) of all companies listed in a stock exchange, specifically in Hong Kong SE, over 20 years including delisted and new starting with issuing day. Is there a way to do it with R? I am thinking about getting a list of all companies listed at every day over the past 20 years and then getting prices for that particular day and company. But I’m not sure who to put it into a code. Or maybe there is another way to do it? Perhaps with Bloomberg terminal? I got one at campus. I would very much appreciate any help.
Getting historical data for all companies listed in a stock exchange (Hong Kong in my case)
395 views Asked by Andrey At
1
There are 1 answers
Related Questions in DATABASE
- How to add the dynamic new rows from my registration form in my database?
- How to store a date/time in sqlite (or something similar to a date)
- Problem with add new attribute in table with BOTO3 on python
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- SQLAlchemy: efficient relationship loading in 3-way many-to-many relationship
- Cannot connect to Postgres Database when running Quarkus Tests with Gitlab ci
- Local or remote database with react-native?
- I want to edit a specific row in database
- How to enter data in mongodb array at specific position such that if there is only 2 data in array and I want to insert at 5, then rest data is null
- Open Web Library
- database login.py and register.py error showing 404 file not found and doesn't work
- SQL71561: SqlComputedColumn: When column selected
- Liquibase as SaaS To Configure Multiple Database as Dynamic
- Updated max input vars but table still shows error
- Spring does not map set of roles
Related Questions in FINANCE
- Can't figure out to properly implement formula to get monthly payment for a mortgage into C#
- React component to display crypto price live data
- Is here a database for fetching a financial data for capital market?
- RSI from Trading View is different from my RSI calculation
- Proper way to implement transactional HOTP?
- Is there an Excel function to calculate the future value of constant interest rate, variable payments?
- Discrepancy between quantmod Results in R and Online Graphs with EURUSD load with yahoo
- How to configure Cumulative Dividend Reinvestment with an initial Value
- Rstudio monthly discount factor interpolation for data table
- Yield curve by liquidity premium hypothesis
- cs50 :( buy handles valid purchase expected to find "112.00" in page, but it wasn't found
- Goal Seek-Macro keeps crashing/running slow
- CRSP/Compustat Merged Database (CCM) in WRDS via Python didn't work
- How to decrease running time for a IRFunctionCurve.fitSvensson in Matlab?
- How to perform arithmetic operations from formula stored in another table in sql / pgsql?
Related Questions in QUANTITATIVE-FINANCE
- Yield curve by liquidity premium hypothesis
- Is There an R Function that Automatically Fits the Best GARCH Model to a Time Series Data?
- using multitasking.task to accelerate combine dataframe failed
- How to round BigDecimal money calculations in Java to 2 decimal places using the best RoundingMode?
- What will happen to src [1] if it is already the first in the pine
- Data Pipeline for Quantitative Research
- How to output interest rates path with QuantLib Black Karasinski model?
- Find if the matching date exists
- R Programming: Package DEoptim Returning Inconsistent Results
- Quantlib, difficulties reconciling yield to maturity of bond cashflows
- Approach on R's quadprog constraint variables in efficient portfolio theory application
- ValueError: The truth value of a Series is ambiguous. Using function and pandas df
- Trying to Run a Candlestick Graph that runs and updates every minute
- Cumulative Returns Calculation Giving Astronomical Result
- Finding the spread of LQD ETF using Price
Related Questions in STOCKS
- Running total per category for each day in pandas dataframe
- How to add conditions with moving day averages in pandas?
- How to iterate through pandas-datareader and create multiple dataframes for each stock ticker?
- Using python and yahoo finance (so something else) how can I get data for the price of an an asset throughout a trading day for X number of days
- Reinforcement Learning Using Multiple Stock Ticker’s Datasets?
- Backtesting a Universe of Stocks
- pandas nested loops out of range of list
- Web scraping CNN data
- Stock splits performance R
- Creating Real-Time Stock Quotes Using C#
- RVest too slow, trying to optimize for pulling stock indicators
- Python, Getting stock data on particular days
- Getting historical data for all companies listed in a stock exchange (Hong Kong in my case)
- TimeSeries - Seasonal Charting Analysis
- Is it possible to create a column called ticker with the name of each stock when reading in multiple csv files?
Related Questions in HISTORICAL-DB
- Handle changes in calculation logic for order system
- Can't Get Historical Weather Data using WeatherKit in SwiftUI App
- OHLC values of First Trade Bar[At the time of Commencement]
- backfill data using previous values in Snowflake
- How can I assign chronological order position or each customers purchase history using Python
- How to get a Historical information considering all the previous records about a customer in SQL Server?
- Temporal tables VS SCD 2
- Fail to draw historical data from TWS API
- How to get the Current products grouping
- Prevent table corruption with historical data - MariaDb / MySQL
- KuCoin API error for historical data in python
- Can pdfplumber extract tables for my scanned pdfs?
- Need historic data + refresh data (Power BI)
- missing minute data from coinApi
- Change tracking/history keeping in SQL database using TSQL script in single table
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
If i well understand your question. You need to work on R and manage a database of the HonKong SE stocks. For this task, I can advise you to go to quandl.com. You can access it for free and loading stock prices in R. You just have to sign into the api and get you Key. direct link to Hong Kong page on quandl.com