[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] Can I create a watchlist like this using yahoo data?



PureBytes Links

Trading Reference Links

Not in a straight forward way, unless your database is from Quotes Plus.  With the Quotes Pus database, the fundamental data fields, and the GetExtraData function call you can get the Relative Strength rank (not just a similiar scalar that you can calculate in AB but a ranking based on the stocks universe you're scanning) and not sure about IRS. 

There's been some work on this forum in developing rankings based on values that are calculated based on Open, Close, High, Low, and Volume.  If you add the Open Interest field - that's all the data fields that you have on a typical Amibroker database interface.  You can calculate relative strength rankings but that takes some work and other than AFL coding.

Hope this helps
JOE . 

  ----- Original Message ----- 
  From: Brian 
  To: amibroker@xxxxxxxxxxxxxxx 
  Sent: Wednesday, September 15, 2004 10:28 PM
  Subject: [amibroker] Can I create a watchlist like this using yahoo data?



  The below list was created with Stock Investor Pro software.
  http://www.aaii.com/simember/si.shtml

  Can this be done with Amibroker????

  Top stocks listed are stocks with RS rankings between 95-99.  Only the
  highest rated stock is listed per industry unless multiple have an RS
  of 99.  I filtered out stocks with less than 40,000 shares traded on
  average. (IRS)= Industries are in group RS order.

  Code:

  Symbol  Price  52WkHi  %Chg      Vol       AvgVol   RS  IRS         
  Industry


  IST     29.45   30.45   -2%     277,500    306,943  99   99 
  Steel-Producers


  OS      15.84   17.76    0%     340,100    376,795  99   99 
  Steel-Producers


  SHLO    15.59   18.67   -1%      40,900     61,779  99   99 
  Steel-Producers


  AIRT    14.03   21.79   -1%     139,500    777,868  99   99 
  Transport-Air Freight


  TIE     24.13   24.90    1%      86,100     89,740  99   98 
  Steel-Specialty Alloys


  TZOO    65.91   67.80   -1%   3,756,000  1,639,027  99   97 
  Internet-Content


  JUPM    16.36   16.73    2%     375,400    528,368  99   97 
  Internet-Content


  TRA      7.52    8.64   -4%     674,900    480,120  99   97 
  Chemicals-Fertilizers


  TNH     17.82   19.60   -3%      83,100     60,250  99   97 
  Chemicals-Fertilizers


  TWI      9.99   12.30    2%      72,200    241,789  99   96 
  Auto/Truck-Tires & Misc


  EXM     38.00   47.90   -6%     141,600     55,073  99   96 
  Utility-Water Supply


  UIC     32.55   33.16    0%     233,900    208,513  97   95 
  Elec-Military Systems


  IO      10.43   10.99    0%     437,600    769,968  97   94 
  Oil&Gas-Machinery/Equip


  TVIN     6.00    6.71    5%     771,200    199,926  99   94 
  Aerospace/Defense Eqp


  ISSC    26.57   29.10    6%     493,200    259,176  99   94 
  Aerospace/Defense Eqp


  ATPG    11.16   10.67    9%     541,600    219,115  98   93 
  Oil&Gas-Intl Expl&Prod


  VLCCF   29.49   33.26    1%     154,300    484,014  98   92 
  Transportation-Ship


  PLMO    32.96   41.93    0%   2,639,500  3,681,814  99   92 
  Computer-Manufacturers


  ZEUS    21.47   24.90   -3%     235,000    250,762  99   91  Metal
  Proc & Fabrication


  TRGL     8.40    9.25   -1%      18,100     65,955  99   91  Oil&Gas-U
  S Expl&Prod


  HUBG    30.72   39.37    2%      94,100    123,869  95   90 
  Transportation-Svcs


  SNSA    18.02   18.74    0%      10,400     46,054  96   89 
  Oil&Gas-Field Services


  TASR    43.09   64.15   22%  40,280,700  8,004,271  99   88  Comml
  Svcs-Security/Sfty


  UHAL    33.25   32.89    2%     109,200     57,346  98   87  Comml
  Svcs-Leasing


  GRA      8.70    9.54   -4%   6,038,800  1,022,236  99   86 
  Chemicals-Specialty


  MSGI    10.50   15.88    1%       8,300     85,428  99   85  Comml
  Svcs-Consulting


  CALM    12.15   22.80   -4%   1,232,700    715,383  96   84  Food-Meat
  Products


  ADVNB   24.09   24.44    0%      52,600     84,250  97   83 
  Finance-Consumer/Cml Lns


  WIBC    31.64   34.46   -3%     208,400    108,193  97   83 
  Banks-West/Southwest


  KMRT    88.05   89.75   -1%   1,989,000  3,026,911  99   80 
  Retail-Major Disc Chains


  UCI     28.97   30.14   -3%     189,300    249,862  98   78 
  Insurance-Acc & Health


  CLF     74.37   75.05    1%     291,000    294,884  98   77  Metal Ores


  SMIT     7.60    8.16    8%      78,600    160,633  99   76 
  Elec-Scientific/Msrng


  BTHS    13.24   17.28    9%     249,600     65,821  99   76 
  Elec-Scientific/Msrng


  TSO     27.37   31.70    3%   2,136,500  1,199,729  98   76 
  Oil&Gas-Refining/Mktg


  FDG     51.91   54.49    2%     265,700     98,153  97   75  Energy-Other


  NPO     23.91   25.20    3%     251,500    168,054  96   73 
  Machinery-Gen Industrial


  LEND    40.09   43.25    0%     949,700    445,433  96   72 
  Finance-Mrtg&Rel Svc


  ACR      6.95    7.05   -1%      44,700     94,132  98   71 
  Medical-Nursing Homes


  BMHC    24.92   26.36    1%     304,400    185,845  95   71 
  Retail/Whlsle-Bldg Prds


  LGF      7.79    7.95    2%   1,273,600    651,377  96   68 
  Leisure-Movies & Related


  PKOH    17.93   20.12    0%      37,600     73,552  98   67 
  Diversified Operations


  NAVR    14.69   16.25    0%     234,100    526,206  99   64 
  Retail/Whlsle-Cmptr/Cell


  MGN      5.96    9.70   -4%      66,700     54,678  98   63  Metal
  Ores-Gold/Silver


  TXU     44.68   44.44    2%   6,516,600  2,596,759  96   62 
  Utility-Electric Power


  OCLR    46.49   47.00    0%     135,000    418,693  97   61 
  Medical/Dental-Supplies


  CWTR    20.92   21.98   -2%     182,900    299,913  97   60 
  Retail-Mail Order&Direct


  AWIN    30.11   36.55    2%      86,900     84,315  96   59 
  Telecomm-Wireless Svcs


  VLTS     6.75   10.43   11%     272,700    175,306  96   57 
  Medical-Genetics


  RSE     66.71   67.10    0%   1,647,500  1,315,690  95   56  Finance-Reit


  AIQ      7.60    8.00    1%     157,400     88,588  98   54 
  Medical/Dental-Services


  SAPE     7.78    8.17   -2%   1,113,500  1,493,741  96   52 
  Computer-Tech Services


  ALDA    11.43   18.48  -11%     414,900    104,866  99   52 
  Leisure-Products


  NTMD    19.69   23.18    4%     825,600  2,401,458  99   51 
  Medical-Ethical Drugs


  ELN     23.85   25.90   -1%   2,600,600  4,979,514  99   51 
  Medical-Ethical Drugs


  WYNN    41.29   43.77   -1%     464,500    352,886  95   51 
  Leisure-Gaming/Equip


  URBN    35.07   35.29    1%   1,451,800  1,480,882  98   50 
  Retail-Clothing/Shoe


  HURC    11.33   14.40    0%      24,800     73,600  99   48 
  Machinery-Mtl Hdlg/Autmn


  CSAR    16.58   17.00    0%      59,300    130,240  95   46  Paper &
  Paper Products


  PARL     9.95   13.73    8%      94,200     76,482  97   45 
  Cosmetics/Personal Care


  HRT     20.75   48.15  -14%   1,003,200    203,490  99   43 
  Medical-Systems/Equip


  PMTI    22.03   23.67    1%     256,600    239,032  99   43 
  Medical-Systems/Equip


  ESMC    12.84   27.49   -6%   1,140,200    453,054  96   43 
  Medical-Products


  AKAM    14.70   18.47   -4%   4,191,800  2,673,288  95   40 
  Internet-Network Sltns


  GMAI    14.17   17.99    0%     158,300    156,466  97   39 
  Retail-Miscellaneous


  DECK    33.10   34.40    0%     231,200    400,639  98   38 
  Apparel-Shoes & Rel Mfg


  TRMM    14.00   27.00   -2%      47,600    111,333  98   35  Comml
  Svcs-Miscellaneous


  IIVI    38.39   39.41    0%      80,900    107,106  96   35 
  Elec-Component/Connectr


  TBUS     5.49   16.87   27%   4,854,900    669,764  97   34 
  Telecomm-Equipment


  PTRY    24.15   29.64    3%     216,200    115,226  95   33 
  Retail-Super/Mini Mkts


  SMF     16.59   17.49    0%     234,400    154,130  97   33 
  Retail/Whlsle-Food


  PHI     24.42   25.72   -2%      76,600    138,416  97   32 
  Telecomm-Services Frgn


  IDSA     9.95   23.75   -7%   1,342,800    162,169  99   31  Pollution
  Control-Svcs


  RAI     74.34   76.19   -2%     949,700  1,183,778  95   26  Tobacco


  DHC      5.85   10.40   -2%      57,800    149,907  98   24 
  Insurance-Prop/Cas/Titl


  KERX    12.06   19.86    1%     203,400    295,582  99   22 
  Medical-Biomed/Biotech


  RIMM    70.03   72.07    2%   8,717,500  7,509,693  99   21 
  Telecom-Wireless Equip


  ALDN    19.86   28.75    1%     555,300    322,197  96   20  Computer
  Sftwr-Security


  ADSK    47.25   47.43    0%   1,048,400  1,807,022  98   20  Computer
  Sftwr-Design


  MWY     11.23   13.48   -2%     230,100    884,062  98   18  Computer
  Sftwr-Educ/Entr


  HANS    25.28   30.28   -2%     320,100    319,758  99   16 
  Beverages-Soft Drinks


  WCC     20.99   21.50    0%     157,100    164,571  98   15 
  Elec-Parts Distributors


  ICU      5.10    7.50    5%      19,600     51,170  97   14 
  Internet-E Commerce


  AMED    28.52   33.57    7%     923,900    302,080  98   12 
  Medical-Outpnt/Hm Care


  WITS    14.62   15.58   -3%     631,700    314,360  97   12  Computer
  Sftwr-Enterprse


  HA       7.60    8.75   -4%      62,600    152,088  99   11 
  Transportation-Airline


  CETV    28.59   28.11    3%     176,900    128,878  97    8 
  Media-Radio/Tv


  AMXC    19.16   19.60    2%     124,000    210,271  99    8 
  Computer-Networking


  BAMM     7.61    8.19    1%      50,800     67,090  95    7 
  Retail-Leisure Products


  IPIX     8.28   27.34    6%  10,203,400  3,749,378  99    7 
  Internet-Software


  TUNE     5.48    5.67    2%     529,500    553,256  98    3 
  Elec-Semiconductor Mfg


  SMTI    11.10   12.75    2%      19,600     44,882  99    2 
  Elec-Contract Mfg



  Check AmiBroker web page at:
  http://www.amibroker.com/

  Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 


        Yahoo! Groups Sponsor 
              ADVERTISEMENT
             
       
       


------------------------------------------------------------------------------
  Yahoo! Groups Links

    a.. To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/
      
    b.. To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx
      
    c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 



[Non-text portions of this message have been removed]



------------------------ Yahoo! Groups Sponsor --------------------~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/GHeqlB/TM
--------------------------------------------------------------------~-> 

Check AmiBroker web page at:
http://www.amibroker.com/

Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/