How to use Stock Tickers (1 Viewer)
- Thread starter rykid16
- Start date
- Local time
- Today, 23:38
- Joined
- Jul 9, 2003
- Messages
- 16,280
Do you mean you want to access stock figures from the web and use them in access?
- Local time
- Today, 23:38
- Joined
- Jul 9, 2003
- Messages
- 16,280
Neither do I! I suggest you do some research and then posted back when you have a better idea of what you want.
- Local time
- Today, 23:38
- Joined
- Jul 9, 2003
- Messages
- 16,280
What are you looking for?
- Local time
- Today, 23:38
- Joined
- Jul 9, 2003
- Messages
- 16,280
MSAccessRookie
AWF VIP
- Local time
- Today, 18:38
- Joined
- May 2, 2008
- Messages
- 3,428
Once again, Uncle Gizmo is asking a legitimate question. A Stock Ticker is used like a Database Primary Key to obtain information (price, volume, etc.) pertaining to a stock from another application or database. Not knowing why you want to know, or what you want to do with the information, it is difficult to assist you beyond that level of detail. The Link he provides might be a good start.
-- Rookie
-- Rookie
- Local time
- Today, 23:38
- Joined
- Jul 9, 2003
- Messages
- 16,280
And this is VBA for Excel, which you should be able to adapt for use in MS Access:-
http://chandoo.org/wp/2010/06/02/excel-stock-quotes/
http://chandoo.org/wp/2010/06/02/excel-stock-quotes/
AlexN
Registered User.
- Local time
- Tomorrow, 01:38
- Joined
- Nov 10, 2014
- Messages
- 302
Stock Tickers are the abbreviated names of companies in the stock market. This is the way they appear in the stock market table, and this is the way you'll find them in almost all infromative datasheets.
Further more, if I wanted to use them in a database, I would first create a table with the CompanyID (autonumber) as a Primary Key, FullCompanyName as text field, and StockTicker as text field also.
Should you clarify further your intentions, you'll find more help here.
apr pillai
AWF VIP
- Local time
- Tomorrow, 04:08
- Joined
- Jan 20, 2005
- Messages
- 735
If you would like to use data from your table/query and display as a ticker on a Form then check this out, to get an idea as how it works: Reminder Ticker Form.
This is another example: Wave shaped Ticker.
This is another example: Wave shaped Ticker.
Last edited: