Pulling Stock/Commodity Intraday Quotes from PCQuotes.com or

[dano0726]

I'm trying to utilize Excel 97 to be able to design an Intraday Quote Page -- each row will contain (in separate rows) the date, time, open, high, low, close, volume of either a stock or a commodity.

Using Create Web Query under Data in the Excel 97 Toolbar, I can easily pull a snapshot quote...can someone help me design (or forward a similar Excel file) which will allow this to happen?

In addition, how does one "import" the data (into the abovementioned spreadsheet) from a non-Web-based source -- i.e. coming from LPT1?

This is my 1st posting, so be easy on me.

dano0726

[ This Message was edited by: dano0726 on 2002-06-30 18:00 ]

[PaddyD]

dano0726,

First question:
Do you mean "get some code that will run a macro that calls a web query every x minutes & puts the results into the row underneath the row it used last time the macro ran?"

what's the site(s) you want to get the data from? (Please give the exact page that you'd use to enter the relevant stock code into).

Second question:
You can get data from other sources (if you've got the right ODBC drivers installed) by creating & running a database query. What exactly are you trying to do?

Post back with more info.

Paddy

[ This Message was edited by: PaddyD on 2002-06-30 18:33 ]

[dano0726]

Regarding the nonWeb based source, it is a Signal Box which connects to one's LPT1 parallel port. The device receives price quotes (stocks, options, futures, indices, other) via FM airbourne transmissions like a radio...in the old days, the box "linked" directly with Lotus to produce a spreadsheet format which showed the ticker symbol, date, time, prices, etc. for a chosen security.

I'm trying to re-start the Box with Excel 97; would an upgrade to Excel 2000/2002 accelerate/help the process.

Thanks in advance.

dano0726

[PaddyD]

Hhmmm...sounds a little beyond me, to be honest . Still - where does the data go once it's been received by the device? If it ends up stored in a flat file or similar, then I can help. If it's a matter of getting excel to interact directly with the signal box I'll have to pass. & unless anyone else out there has done something similar, I think your problem might be too detailed to get fixed here, unless we can break it into smaller pieces.

Keep the info coming, but if all else fails, you might consider asking Mr Excel himself - take a look at :

http://www.mrexcel.com/consult.shtml

one of the specialities is stock data!

Paddy

[thereuare]

I recently did something just like this. It goes something like this:

Assuming quote, open, high, low, etc line is in Range("A1:G1")

If Counter=0 then Counter=2
Counter = Counter +1
Range("A1:G1").Select
Selection.Copy
ActiveCell.Offset(CellCount, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

Then have the code loop for each time you want to copy/paste a new line of data.

The "thought process" of this code is to have the data enter the Range(A1:G1), copy it, then paste the values into row 3, then when it loops, it repeats the copy and pastes into row 4, loops and pastes into row 5, and so on.

You can set the web query to refresh every 60 minutes if you'd like, and then just have the Macro run after a web refresh (thru some "workbook event" code)

Hope this helped.