2. ASPRunnerPro General questions
  3. Stock Quote Price
This topic is locked

Stock Quote Price

 		7/15/2003 12:10:26
ASPRunnerPro General questions
swat author

Is there any wat that I can link one of my column to yahoo.finance or else where to get real time stock price .
OR,
I ahve this link which gives you the real time stock quotes for selected companies Is there any possible way that I can link some of this data into my db .
http://quotes.nasdaq.com/quote.dll?mode=st...min&symbol=msft
Thank you
Sergey Kornilov admin 7/19/2003

Hi,
Lets assume that you have column named SYMBOL in your database.
Default SQL query in ASPRunner will be something like this

select

...

SYMBOL

...

from stocks


change it to:

select

...

'< a href="' +http://quotes.nasdaq.com/quote.dll?mode=stock&page=xml&symbol=ibm&symbol=orcl&symbol=cmin&symbol='; + SYMBOL + '">' + SYMBOL + '</a>'as SYMBOLLINK

...

from stocks


This is it.
Sergey Kornilov
swat author 7/21/2003

I put the code table_list.asp after displaying the data but did not work?
Thank you
Sergey Kornilov admin 7/22/2003

Hi,
if you like me to take a look just post your table structure here and that portion of code that you have added.
Best regards

Sergey Kornilov