ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   stock screener (https://www.excelbanter.com/excel-programming/351907-stock-screener.html)

[email protected]

stock screener
 
Hello Everyone,
I am new to this forum and am an intermediate excel user. I wanted some
help on creating an excel stock screener.
In simple terms I have a list of parameters whose values can be greater
than, less than or equal to certain values. After entering these values
I want to access a data base of stocks and pick the ones satisfying the
conditions I have specified. Can some one please give me an outline of
how to go about this? For convienience let us assume the database to be
in microsoft access.

Any help would be greatly appreciated

Thanks

Aditya Dhar


[email protected]

stock screener
 
First of all, you have to know how to use ADO database library and
several simple SQL query(eg.SELECT).
All of screener is doing are may be query-related works.
What you request is,however, so complicated to show a sample.

Best regards,
sjoo



All times are GMT +1. The time now is 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com