Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How many days the ready stock+expected stock will last as allocate | Excel Discussion (Misc queries) | |||
How do i get historical stock quotes using MSN Money Stock Quotes | Excel Discussion (Misc queries) | |||
Web Query With Multiple Stock Symbols & Stock Scouter | Excel Worksheet Functions | |||
How can I use Dutch (NL) stock MSN MoneyCentral Stock in Excel | Excel Worksheet Functions | |||
Office 2003 Stock Action Add-In - Stock Handling Capacity/Numbers | Excel Worksheet Functions |