Stock Screener with Exel

Discussion in 'App Development' started by Huskeez, Nov 2, 2013.

  1. Huskeez

    Huskeez

    Hey guys , has any one on here seen/developed a stock screener using Exel?
     
  2. Bob111

    Bob111

  3. Huskeez

    Huskeez

    Ha! Yes my bad that what I meant!,

    I have been tinkering around with VBA for the last week, seems like the only limitation with it is ones imagination.

    At the moment I am manually going from chart to chart in search of my buy signals which is very time consuming, hence the reason I would love to be able to just enter data into excel which in turn would change a stock to red or green based on whether the "entry" signal has been triggered or not.
     
  4. Bob111

    Bob111

    yes, most likely you will need VBA for that .
    and if you don't know the language-it will be hard. add complexity of the 'signal' + database,where all information was stored. chart that you see is just a graphical representation of this data. if it's online-this mean data is stored on their side. if you want to run scan from your PC-the data have to be on it too.
     
  5. Huskeez

    Huskeez


    Yes im trading not intra day, just trend/swing type trading. So end of the day data is good for me.

    I currently use yahoo finance stock historical data, from which I calculate my stops by calculating true range/ATR with excel, I use VBA to customize my own formulas to save time.
     
  6. Bob111

    Bob111

    you can try to record a macro or something.
    do it for one ticker using maybe a web query(i'm not an expert in excel and rarely using it) and then -put it in some sort of loop,where all you have to do is to change that ticker in the query

    http://www.experiglot.com/2011/10/1...s-in-excel-with-macros-or-any-other-web-data/

    google something like yahoo stock data excel macro. there is also big yahoo group dedicated to this particular direction-excel and trading. somebody probably done this already 100 times or so. all you need is to find it and modify to your needs.
     
  7. I have the same thing. I solved it by modifying a yahoo from the internet. I still dont know any VBA.

    Problem is data is updated at 4:15. So you have to input data from 3,45, then change the close time, OHL is accurate, but C is 15 minutes off, unfortunately.
     
  8. Bob111

    Bob111

    subscribe for a real time. it's only $14 and first month is free

    http://billing.finance.yahoo.com/realtime_quotes/signup
     
  9. #10     Nov 8, 2013