Home › Forums › Logical Invest Forum › Add custom stocks
- This topic has 2 replies, 3 voices, and was last updated 6 years, 5 months ago by Alex @ Logical Invest.
- AuthorPosts
- 05/25/2018 at 11:51 am #52643memoworkParticipant
Hi, i want to add custom stocks from mexico which are not avaliable to download with QT. How could i create a excel file and upload to QT?
Should i create a excel file, name it _stock and use the format “date adj close ” ??
thanks
05/28/2018 at 1:01 pm #52709VangelisKeymasterYou can create a text file with the following format, name it _yourstockname.csv and add it to inside the QT folder.
Date,Open,High,Low,Close,Volume,Adj Close
2018-03-29,238.090,240.840,234.760,235.650,4671145.000,235.650
2018-03-28,244.080,246.930,235.600,236.680,4174405.000,236.680
2018-03-27,248.080,254.250,241.600,244.370,6309121.000,244.370
2018-03-26,247.670,248.830,240.510,247.730,4559848.000,247.730
2018-03-23,243.380,245.215,240.405,242.480,5845337.000,242.480
2018-03-22,242.030,246.720,241.500,243.570,4215848.000,243.570
2018-03-21,240.580,250.590,240.060,246.000,5439448.000,246.000
2018-03-20,245.100,248.050,241.280,242.360,6121449.000,240.64806/08/2018 at 8:16 am #53050Alex @ Logical InvestKeymasterMost Mexican companies, at least the IPC ones, are available in Yahoo, so you can download them into QT:
https://finance.yahoo.com/quote/CEMEXCPO.MX?p=CEMEXCPO.MX
Just setup CEMEX using symbol CEMEXCPO.MX
- AuthorPosts
- You must be logged in to reply to this topic.