Add custom stocks

Home » Topics » QuantTrader Forum » Add custom stocks
Add custom stocks 2018-05-25T11:51:20+00:00
  • Author
    Posts
  • memowork
    Participant
    Post count: 3

    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

  • Vangelis
    Moderator
    Post count: 154

    You 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.648

  • Alexander Horn
    Keymaster
    Post count: 383

    Most 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

You must be logged in to reply to this topic.