Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Strategies & Market Trends : A.I.M Users Group Bulletin Board -- Ignore unavailable to you. Want to Upgrade?

To: David Penfield who wrote (14717)	2/2/2001 3:34:34 PM
From: OldAIMGuy	Respond to of 18928

Hi David and Welcome, The software I use requires I type in the prices each week on my equities. It's not much of a burden. I use a ticker service called "Netstock" which is available at splitcycle.com It's a simple little ap. that has remained quite reliable for several years in satisfying my Quote Addiction. :-) It runs in the background and doesn't take up much in the way of resources and is a freebie. Best regards, Tom

To: David Penfield who wrote (14717)	2/2/2001 8:43:01 PM
From: axp	Read Replies (2) \| Respond to of 18928

My spreadsheet is customized for my use and probably not that useful. I've got some of my own twists on AIM built in. But I can tell you how to get quotes updated from the internet. A B C D ... 1 [Query] 2 3 4 A 5 AMD 6 ... The way to do this is part of Excel 2000, which is what I have. It may not work as easy on earlier versions. I'm describing a particular way to do this - there are lots of variations. 1) Enter your list of stocks in column A starting at row 4. 2) Select menu item Data\|External Data\|Run Saved Query. 3) In the dialog box select "Microsoft Investor Stock Quotes.iqy". If you don't see that file search your hard disk for it. 4) Click "Get Data" 5) "Where do you want to put the data?" Choose "existing worksheet" "=$B$1" 6) Click "Parameters". 7) Choose "Get the value from the following cell" 8) Click on the chooser thingy at the right side of the entry box. 9) Select the stocks by dragging the cursor over them from top to bottom. Hit RETURN. 10) Click "OK" 11) Click "OK" You should see a slew of formatted stuff come up including a whole line of stats for each stock. You can experiment with some of the parameters (right-click\|parameters). To refresh, do "right-click\|refresh" on any cell in the query. I put a "refresh" button on my main summary sheet. It links to this VBA macro: Sub RefreshQuotes() Sheets("Quotes").Range("B1").QueryTable.Refresh BackgroundQuery:=True End Sub ("Quotes" is the name of my sheet with the quote query on it.) To create the button enable the Control toolbox, select the command button tool and draw it on your spread sheet. Assign the button to the above macro. Use standard worksheet functions (MATCH,LOOKUP,INDEX,...) to get any stat from any stock in the list and put it where you want it on another sheet. I'm a programmer and this is fairly straight forward to me, but I can appreciate it if it seems complicated. If you have questions I'd be glad to help.