ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I import external data from an authentified url? 4 STOCK VALUE (https://www.excelbanter.com/excel-discussion-misc-queries/196420-can-i-import-external-data-authentified-url-4-stock-value.html)

Bruno

Can I import external data from an authentified url? 4 STOCK VALUE
 
I'm interested in stock values for my worksheet or MY OWN html page (second
project)
I use a brokerage site and as any of these sites you have to log in.

After I'm logged I hit DATA IMPORT EXTERNAL DATA NEW WEB QUERY paste the
url that ends as .asp to link up some cell values on the table and hit search.

An error message pops up
"Your session has expired. If you want to continue trading please log in
again"

Options are OK - CANCEL hiting either one blocks the query window.


Is there any safe way I can import stock values from a database or a webpage
into my worksheet?? Any traders or experts care to guide or explain me this
process?

Hope to find some help. Thank you.


Don Guillett

Can I import external data from an authentified url? 4 STOCK VALUE
 
goto

and look in the files section. There are several free files.
I have a couple of free files under author donalb36


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bruno" wrote in message
...
I'm interested in stock values for my worksheet or MY OWN html page
(second
project)
I use a brokerage site and as any of these sites you have to log in.

After I'm logged I hit DATA IMPORT EXTERNAL DATA NEW WEB QUERY paste
the
url that ends as .asp to link up some cell values on the table and hit
search.

An error message pops up
"Your session has expired. If you want to continue trading please log in
again"

Options are OK - CANCEL hiting either one blocks the query window.


Is there any safe way I can import stock values from a database or a
webpage
into my worksheet?? Any traders or experts care to guide or explain me
this
process?

Hope to find some help. Thank you.



Bruno

Can I import external data from an authentified url? 4 STOCK V
 
can't find your group xltraders on
http://groups.yahoo.com/search?query...&submit=Search

"Don Guillett" wrote:

goto

and look in the files section. There are several free files.
I have a couple of free files under author donalb36


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bruno" wrote in message
...
I'm interested in stock values for my worksheet or MY OWN html page
(second
project)
I use a brokerage site and as any of these sites you have to log in.

After I'm logged I hit DATA IMPORT EXTERNAL DATA NEW WEB QUERY paste
the
url that ends as .asp to link up some cell values on the table and hit
search.

An error message pops up
"Your session has expired. If you want to continue trading please log in
again"

Options are OK - CANCEL hiting either one blocks the query window.


Is there any safe way I can import stock values from a database or a
webpage
into my worksheet?? Any traders or experts care to guide or explain me
this
process?

Hope to find some help. Thank you.




Don Guillett

Can I import external data from an authentified url? 4 STOCK V
 
http://tech.groups.yahoo.com/group/xltraders/

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bruno" wrote in message
...
can't find your group xltraders on
http://groups.yahoo.com/search?query...&submit=Search

"Don Guillett" wrote:

goto

and look in the files section. There are several free files.
I have a couple of free files under author donalb36


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bruno" wrote in message
...
I'm interested in stock values for my worksheet or MY OWN html page
(second
project)
I use a brokerage site and as any of these sites you have to log in.

After I'm logged I hit DATA IMPORT EXTERNAL DATA NEW WEB QUERY
paste
the
url that ends as .asp to link up some cell values on the table and hit
search.

An error message pops up
"Your session has expired. If you want to continue trading please log
in
again"

Options are OK - CANCEL hiting either one blocks the query window.


Is there any safe way I can import stock values from a database or a
webpage
into my worksheet?? Any traders or experts care to guide or explain me
this
process?

Hope to find some help. Thank you.






All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com