Stock Screener with Exel
- Thread starter Huskeez
- Start date
you mean excel,right? if so-yes. excel is very flexible and could be the only tool you need. specially when combined with knowledge of VBA
http://en.wikipedia.org/wiki/Visual_Basic_for_Applications
http://en.wikipedia.org/wiki/Visual_Basic_for_Applications
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.
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.
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.
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.
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.
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.
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.
subscribe for a real time. it's only $14 and first month is free
http://billing.finance.yahoo.com/realtime_quotes/signup
that defeats the purpose of making money though. plus I would have to modify the VBA again... and im too lazy.
