Click here to Login





                                                   Manual Load EOD Data

  0

0
Ivan Cheng
2015-01-12 20:57:15


Hi,

I am currently using the downloader 'Historical Stock Market Data' to download EOD quotes for Bursa Malaysia.

However I realize that the EOD data is not available on the same day even after the market closes, which of course hinders me from making any sort of analysis
and screening at night.

I have searched for faster ways to download EOD data and manages to find the updated daily EOD data in the form of CSV. May I know how do I manually load
it into Quantshare?

Any help would be really appreciated. Thank you.




QuantShare
2015-01-13 02:12:09

  0

Hi Ivan,

Please use "Data -> ASCII Import" to manually import data into QuantShare.
http://www.quantshare.com/how-377-how-to-import-trading-data-from-csv-files



Ivan Cheng
2015-01-14 10:02:42

  0

Hi,

The ASCII Import function can only import files that has 1 line (1 file = 1 quote)

Is there any way to import multiple quotes with only 1 file? This is the file format that I currently have:

<Name>,<TICKER>,<PER>,<DATE>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>,<OPENINT>
ICAPITAL.BIZ BHD,ICAP.KL,D,20150114,2.3300,2.3300,2.3200,2.3200,520,0
AHMAD ZAKI RESOURCES BHD,AZRB.KL,D,20150114,0.6950,0.7000,0.6850,0.7000,5428,0
BENALEC HOLDINGS BERHAD ,BENALEC.KL,D,20150114,0.6400,0.6450,0.6350,0.6400,23184,0
BINA PURI HOLDINGS BHD,BPURI.KL,D,20150114,0.5350,0.5400,0.5350,0.5400,300,0
BREM HOLDINGS BHD,BREM.KL,D,20150114,1.0100,1.0300,1.0100,1.0200,1820,0
CREST BUILDER HOLDINGS BHD,CRESBLD.KL,D,20150114,1.2300,1.2300,1.2300,1.2300,0,0
DKLS INDUSTRIES BHD,DKLS.KL,D,20150114,1.8000,1.8000,1.8000,1.8000,20,0


Appreciate if you can further assist in this. Thanks.



QuantShare
2015-01-15 03:16:12

  0

Hi Ivan,

This is not correct. You can also import files with multiple symbols.
You just need to add a "Quotes -> Symbol" column in the appropriate order

Given your example:
Quotes -> Skip
Quotes -> Symbol
Quotes -> Skip
Quotes -> Date
Quotes -> Open
Quotes -> High
Quotes -> Low
Quotes -> Close
Quotes -> Volume
Quotes -> Open Interest



Ivan Cheng
2015-01-21 08:51:58

  0

Hi,

I have formatted the file into excel file with each field separated by column as below:
3A 20150121 0.97 1.01 0.97 1.01 22798 0
A&M 20150121 0.88 0.88 0.865 0.87 4481 0
AASIA 20150121 1.07 1.07 1.07 1.07 0 0
AAX 20150121 0.67 0.675 0.665 0.67 18194 0
AAX-CA 20150121 0 0 0 0 0 0
AAX-CB 20150121 0 0 0 0 0 0
AAX-CC 20150121 0 0 0 0 0 0
AAX-CD 20150121 0 0 0 0 0 0
AAX-CE 20150121 0 0 0 0 0 0

and I have added in the column in the ASCII import like what you mentioned
Quotes -> Symbol
Quotes -> Date
Quotes -> Open
Quotes -> High
Quotes -> Low
Quotes -> Close
Quotes -> Volume
Quotes -> Open Interest

With date format YMD and separator as "tab". However I am getting error from the parser. What else am I supposed to do?

Really appreciate your help as this is crucial for me to decide if I were to continue using Quantshare.



Ivan Cheng
2015-01-21 08:56:18

  0

Hi,

Thanks for your help so far. It works perfectly now! Seems that I need to use a text delimited file format for the importer to work.




Ivan Cheng
2015-01-21 09:40:34

  0

Hi,

I have another question. After importing my data via ASCII importer, I realized that some of my data weren't translated to the chart correctly.

For example,
<TICKER>,<PER>,<DTYYYYMMDD>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>,<OPENINT>
AAX,D,20150121,0.67,0.675,0.665,0.67,18194,0

The High and Low is 0.675 and 0.665 respectively in the parser preview output. However when it is imported to the charts it is shown as 0.67 and 0.66 instead. Is it that the chart can only interpret up to 2 decimal points? How do I change that?



QuantShare
2015-01-22 01:58:20

  0

Does it show 2 decimal points in both the top of the chart and the right Y axis?
What does it display in "Data -> Edit Databases"?



Ivan Cheng
2015-01-22 02:17:17

  0

On the chart Y-axis it shows 3 decimal points i.e. 0.668 but the top of the chart is only 2 decimal points i.e. 0.67

In Data -> Edit Databases also show 2 decimal points despite the data in my file is 3 decimal points. Even after I attempt to manually change the data in edit databases to 3 decimal points, the changes doesn't seem to be reflected and it reverts itself once I close the window.



No more messages
0




Reply:

No html code. URLs turn into links automatically.

Type in the trading objects you want to include: - Add Objects
To add a trading object in your message, type in the object name, select it and then click on "Add Objects"










QuantShare

Trading Items
Historical EOD data for Saudi stocks
EOD Quotes Data for Hong Kong Stocks and ETFs
Abu Dhabi Securities Exchange - EOD data
Dhaka Stock Exchange - Historical EOD Data
JSE Historical EOD Data - Johannesburg Stock Exchange

How-to Lessons
How to quickly download the most recent EOD data for your stocks
How to download historical EOD data for penny stocks
How to download EOD quotes for active and valid stocks only
How to export trading data to a CSV file
How to automate the data downloading process

Related Forum Threads
IB realtime data, how to automatically backfill EOD data
Problem downloading EOD data for Paris stock market (Euronext Par...
LSE - UK - EOD data 202 and 102 errorrs for all stocks
Can I download EOD data a few hours after market closed?
Problem with EOD Historical Data for LSE Listed Stocks

Blog Posts
Day Trading: A trading system that combines intraday and EOD data
Download historical EOD data for the stock, futures, ETF and Fore...
Create custom metrics for the statistical data analysis tool
4 Market Composite Indicators Based on Industry Data
German Stock Exchanges: 5 free ways to download historical EOD/In...









QuantShare
Product
QuantShare
Features
Create an account
Affiliate Program
Support
Contact Us
Trading Forum
How-to Lessons
Manual
Company
About Us
Privacy
Terms of Use

Copyright 2021 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
Follow us on Google+
RSS Trading Items



Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.