Amibroker: How To Import A Watchlist With A CSV File

Line1

Beginners Course  |  Intermediate Course  |  Amibroker Course

Using Amibroker for your charting can be very simple when you know how.

Here we show you how to make a watchlist from a CSV file.  This can be very handy if you have downloaded a list of stocks, for example from Yahoo or your online broker, or even after performing a scan of Fundamental criteria you want and getting the results in the form of a CSV file.

Sometimes we might want to perform technical analysis scans on this list of stocks, and there is no easier way to do this than using Amibroker after we’ve turned our list into a watchlist.

How To Make A Watchlist With A CSV File

In the main screen of Amibroker, go to the top and click on:

  • File
  • Click on Import Wizard
  • Select Pick Files and select your CSV file.  Click Next.
  • On this screen, under Group and Watchlist, select the group (usually zero) and the watchlist or list name you want the stocks to go into.
  • Under the tick boxes on the right, I usually click “Log Errors”, “No Quotation Data”, and uncheck “Add New Symbols”.
  • Under the columns at the top, I usually select the first one as “ticker” and leave the rest blank.
  • Click Next, then Finish

If all has gone well, you will have a list of stocks in your desired watchlist!  Congratulations!

Videos in the FREE Amibroker Course:

  1. Amibroker: How To Import A Watchlist With A CSV File
  2. Amibroker: How To Backtest A Single Stock Or Index
  3. Amibroker: How To Backtest a Portfolio or Group of Stocks
  4. Amibroker: How To Optimize A Trading System
  5. Amibroker: How To Scan The Market For Buy And Sell Signals
  6. Amibroker: How To Use Explore To Find And Filter Stocks
  7. Amibroker: How To Add Position Sizing Using AFL
  8. Amibroker: How to Add An Index Filter To Your Trading System Using AFL
  9. Amibroker: How To Plot Your Trading System On A Chart (incl. Buy/Sell Arrows)
  10. Amibroker: How to Use the If, Then Else Function (IIF)
  11. Amibroker: How to Code the ATR Trailing Stop (Chandelier) using ApplyStop
  12. Amibroker: How to Plot ApplyStop on a Chart
  13. Amibroker: How to Code Van Tharp Position Sizing (Fixed Fractional)
  14. Amibroker: How to “Scale In” to Positions (1) – Buying Once a Month
  15. Amibroker: How to “Scale In” to Positions (2) – Pyramiding Three Times
  16. Amibroker: How to Use “Cross”, When One Thing Crosses Another
  17. Amibroker Advanced: How to Compare Equity Curves

FREE Video Lessons On Trading Systems:

  1. 7 Free Trading Systems and Their Returns From The Last 13 Years
  2. Seven Full Trading Systems Revisited, With Completely New Data
  3. Trading System: How to Create A Buy and Hold Trading System
  4. Trading System: How to Code “Sell In May And Go Away”
  5. Trading System: How to Code a Moving Average Channel That Made 23% p.a
  6. Trading System: How to Code Highest Highs As Used In 52 Week Highs Or Turtle Trading System
  7. Trading System: How to Code a Bollinger Band Breakout Trading System
  8. Trading System: How to Code a Moving Average Crossover That Returned 28% per annum
  9. Trading System: How to Refer to Previous Signals For MAup Trading System
  10. Trading System: How to Code the Leap Of Faith (Gaps) Trading System That Returned 24% p.a.
  11. Trading System: How to Code a Short Selling System (Plus Results)
  12. Trading System: Meb Faber Trading System Using Different Timeframes
  13. Trading System: How to Code the Three Billion Dollar Trading System

Amibroker Q & A Videos:

  1. Amibroker Q & A: How To Do A Monte Carlo Test? (on ALL versions)
  2. Amibroker Q & A: Visualising Monte Carlo Data with Histograms and Scatter Plots
  3. Amibroker Q & A: How to Create the 52 Week High/Low Index with AddToComposite
  4. Amibroker Q & A: How to Code Trend Pilot: Five Consecutive Days Above or Below a Moving Average
  5. Amibroker Q & A: Three “Hacks” To Improve Your Coding Skills
  6. Amibroker Q & A: How to Remove Excess Signals

June 3, 2012  Tags: , , , , ,   Posted in: Amibroker, Amibroker Course, Articles On Building Wealth

One Response

  1. Truman - May 12, 2014

    Hi, when getting the EOD quotes from Yahoo, I am experiencing this issue. Yahoo provides raw Open, High, Low, Close data. After importing into Amibroker, if I backtest all years, there will be huge gaps when the stock is split.

    Yahoo provides adjusted data only for Close. But I can’t plot this in a full candlestick chart since I am missing Adjusted Open, Adjusted High, and Adjusted Low. Any advice of how to deal with this in Amibroker? Thanks.

Leave a Reply