How can I import data from .asp web pages

C

chs245

New Member
Joined
Oct 6, 2002
Messages
24
Hi
my problem is that I would like to import data into Excel (with "Import External Data") from a database that is queried with an .asp command such as http://www.nysedata.com/queries/makeQuery10a.asp

Is that possible at all ?

Thx,

Oliver

The source code of the page is as follow:
Rich (BB code): 
<html>
<head>
<base href="http://www.nysedata.com/">
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<noscript><meta HTTP-EQUIV="refresh" CONTENT="1; URL=../browserError.asp"></noscript>
<title>NYSEData.com - Trade History Database</title>
<link rel="stylesheet" type="text/css" href="css/standard2.css">
<script language="JavaScript" src="scripts/formValidation.js"></script>
<script language="JavaScript" src="scripts/datePicker.js"></script>
<script language="Javascript">
function doOpenWin(whichB)
{
	var newWin;
	if (whichB=="symbol")
	{	newWin = window.open('http://www.nysedata.com/findsymbol.asp','symbollookup','resizable,scrollbars=yes,width=425,height=400,left=100,top=100');	}
	if (whichB=="help")
	{	newWin = window.open('http://www.nysedata.com/database/tradehistory.htm','help','resizable,scrollbars=yes,width=500,height=600,left=100,top=100');	}
	if (!newWin.opener)
	{ newWin.opener=self;	}
	newWin.opener.name="NYSEData";	
	newWin.focus();	
	return;
}
function doSubmit(form)
{
	var errMsg = "Please enter symbol";
	if (!checkTextField(form.querySymbol,errMsg))
	{	return;	}
	errMsg = "Please enter valid Date";
	if (!checkDate(form.queryDate,errMsg))
	{	return;	}
	errMsg = "End Date must occur after Begin Date.";
	if ( !compareTime(form.queryTimeBegin,form.beginAMPM.options[form.beginAMPM.selectedIndex],false,form.queryTimeEnd,form.endAMPM.options[form.endAMPM.selectedIndex],false,errMsg) )
	{	return;	}
	errMsg = "Please check at least one check box to proceed";
	var checkBoxIsChecked = false;
	for (i=0; i<form.queryExchange.length; i++)
	{
		if (form.queryExchange.checked)
		{	checkBoxIsChecked = true;	}
	}
	if (!checkBoxIsChecked)
	{	alert(errMsg); return;	}
	form.submit();
}
</script>
<meta name="Microsoft Border" content="none, default">
</head>

<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" marginheight="0" marginwidth="0">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
    <td width="100%">
<table background="/images/banner_back4.gif" width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td>
	  <table width="100%" border="0" cellpadding="0" cellspacing="0">
	    <tr>
	      <td>
	        <table border="0" cellpadding="0" cellspacing="0">
	          <tr>
	            <td></td>
	            <td>/images/clearpix.gif</td>
	          </tr>
	          <tr>
	            <td>/images/clearpix.gif</td>
	            <td></td>
	          </tr>
	          <tr>
	            <td></td>
	            <td>/images/clearpix.gif</td>
	          </tr>
	        </table>
	      </td>
	      <td valign="top">
	        <table width="100%" border="0" cellpadding="0" cellspacing="0">
	          <tr>
	            <td></td>
	            <td align="right" valign="top" width="470">
				  <table border="0" cellpadding="0" cellspacing="0">
				    <tr>
				      <td valign="bottom" class="bannerColor">/images/curve_botleft.gif</td>
				      <td class="bannerTopRight" align="right" nowrap>  Market Data Services  |  Vendor Services  |  NYSE Openbook  |  MarkeTrac  |  NYSE.com</td>
				      <td class="bannerColor" align="right">/images/clearpix.gif</td>
				    </tr>
				  </table>
	            </td>
	          </tr>
	          <tr>
	            <td>/images/clearpix.gif</td>
	            <td align="right">
	              <table border="0" cellpadding="0" cellspacing="0">
	                <tr>
	                  <td>/images/clearpix.gif</td>
	                  <td width="220" bgcolor="#15205E" align="center">/images/ad_brokervol2.gif</td>
	                  <td width="220" bgcolor="#15205E" align="center">/images/ad_liquidity.gif</td>
	                </tr>
	              </table>
	            </td>
	          </tr>
	        </table>
	      </td>
	    </tr>
	  </table>
	</td>
  </tr>
  <tr>
    <td>
      <table width="100%" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td width="130" class="bannerIndex" align="center" nowrap> Home</td>
          <td width="20" valign="top" class="bannerColor" nowrap>/images/curve_banner_2.gif</td>
          <td class="bannerColor" nowrap><font class="bannerLinks2"></font></td>
          <td width="10" align="right" valign="top" class="bannerColor" nowrap>/images/clearpix.gif</td>
		  <td class="bannerColor" valign="center" align="right" nowrap>Log Out</td>
          <td width="10" align="right" valign="top" class="bannerColor" nowrap>/images/clearpix.gif</td>
        </tr>
		
		<tr>
		  <td class="bannerColor" width="130"></td>
		  <td bgcolor="#ffffff" align="left">/images/curve2_banner.gif</td>
		  <td bgcolor="#ffffff" colspan="4"></td>
		</tr>
		
      </table>
    </td>
  </tr>
</table>
</td>
  </tr>
</table>
<table border="0" width="760" cellspacing="0" cellpadding="0">
  <tr>
    <td valign="top" width="135"><script language="JavaScript1.2" src="scripts/menuScripts/menuScriptv4.js" type="text/javascript"></script>
<script>
var oM=new makeCM("oM")
oM.pxBetween=2;
oM.fromTop=100;
oM.fromLeft=0;
oM.menuPlacement="left";
oM.wait=600;
oM.fillImg="images/cm_fill.gif";
oM.zIndex=100;
oM.resizeCheck=1;
oM.zIndex=100;
oM.onlineRoot="http://www.nysedata.com/";
oM.offlineRoot="";
oM.rows=0;
oM.frames=0;
oM.useBar=0;
oM.barWidth="135";
oM.barHeight="18";
oM.barX=0;
oM.barY="menu";
oM.barClass="mclBar";
oM.barBorderX=0;
oM.barBorderY=2;
oM.barBorderClass="mclB";
oM.level[0]= new cm_makeLevel(135,20,"mclT","mclTover",0,1,"mclB1",0,"right",0,0,"images/jsMenuArrow.gif",7,7)
oM.level[1]= new cm_makeLevel(140,20,"mclS","mclSover",1,1,"mclB1",0,"right",0,0,"images/jsMenuArrow.gif",7,7)
oM.level[2]= new cm_makeLevel(155,20,"mclS2","mclS2over",1,1,"mclB1",0,"right",0,0,"images/jsMenuArrow.gif",7,7)
oM.makeMenu('m738','','Your Data','currentData.asp','','','');
oM.makeMenu('m512','','Your Account','','','','');
oM.makeMenu('m519','m512','Account Information','editProfile/viewProfile.asp','','','');
oM.makeMenu('m520','m512','Current Subscriptions','currentData.asp','','','');
oM.makeMenu('m521','m512','New Subscription','subscribe/p1ChooseProduct.asp','','','');
oM.makeMenu('m522','m512','Billing','editprofile/editBillingInfo.asp','','','');
oM.makeMenu('m524','m512','Email Preferences','editSubscription/editSubscriptions.asp','','','');
oM.makeMenu('m744','','NYSE Fact Book','factbook/main.asp','','','');
oM.makeMenu('m513','','Data Products','','','','');
oM.makeMenu('m526','m513','List of Products','info/productList.asp','','','');
oM.makeMenu('m527','m513','Broker Volume','','','','');
oM.makeMenu('m539','m527','Become a vendor','brokerVolume/Vregistration1.asp','','','');
oM.makeMenu('m540','m527','Database','','','','');
oM.makeMenu('m545','m540','FAQ','brokervolume/FAQ.asp','','','');
oM.makeMenu('m546','m540','Pricing','brokervolume/pricing.asp','','','');
oM.makeMenu('m547','m540','Sample','BrokerVolume/brokervol200212.zip','','','');
oM.makeMenu('m548','m540','Schema','brokervolume/BVSpecifications.asp','','','');
oM.makeMenu('m549','m540','Subscribe','brokervolume/Vregistration1.asp','','','');
oM.makeMenu('m550','m540','Viewer','brokervolume/viewer.asp','','','');
oM.makeMenu('m541','m527','Participate','brokervolume/instructions.asp','','','');
oM.makeMenu('m542','m527','Reports','','','','');
oM.makeMenu('m551','m542','Demonstration','brokervolume/demo/volumebyfirm.asp','','','');
oM.makeMenu('m552','m542','Pricing','brokervolume/pricing.asp','','','');
oM.makeMenu('m554','m542','Subscribe via Authorized Vendor','brokervolume/vendors.asp','','','33');
oM.makeMenu('m528','m513','Liquidity Quote','liquidity/default.asp','','','');
oM.makeMenu('m529','m513','OpenBook','openbook/default.asp','','','');
oM.makeMenu('m530','m513','Trades and Quotes','','','','');
oM.makeMenu('m561','m530','Historical','','','','');
oM.makeMenu('m563','m561','Daily TAQ FTP','info/productDetail.asp?dpbID=13','','','');
oM.makeMenu('m564','m561','TAQ Web','info/productDetail.asp?dpbID=10','','','');
oM.makeMenu('m562','m530','Real Time','info/ctcq.asp','','','');
oM.makeMenu('m531','m513','Stock Prices','','','','');
oM.makeMenu('m565','m531','Delayed','info/delayedPrices.asp','','','');
oM.makeMenu('m566','m531','End of Day','','','','');
oM.makeMenu('m570','m566','Closing Summary','info/productDetail.asp?dpbID=5','','','');
oM.makeMenu('m567','m531','Historical','','','','');
oM.makeMenu('m571','m567','Daily TAQ FTP','info/productDetail.asp?dpbID=13','','','');
oM.makeMenu('m572','m567','TAQ Web','info/productDetail.asp?dpbID=10','','','');
oM.makeMenu('m568','m531','Pre-Opening','','','','');
oM.makeMenu('m573','m568','ITS Indications','mdx/','','','');
oM.makeMenu('m569','m531','Real Time','info/ctcq.asp','','','');
oM.makeMenu('m532','m513','Bonds','','','','');
oM.makeMenu('m575','m532','Bonds - Trades','info/productDetail.asp?dpbID=15','','','');
oM.makeMenu('m574','m532','Bonds - Quotes','info/productDetail.asp?dpbID=14','','','');
oM.makeMenu('m533','m513','Limit Orders','','','','');
oM.makeMenu('m576','m533','Real Time','openbook/default.asp','','','');
oM.makeMenu('m577','m533','Historical','','','','');
oM.makeMenu('m578','m577','OpenBook FTP','info/productDetail.asp?dpbID=12','','','');
oM.makeMenu('m579','m577','OpenBook Web','info/productDetail.asp?dpbID=16','','','');
oM.makeMenu('m534','m513','Dollar Volume','info/productDetail.asp?dpbID=18','','','');
oM.makeMenu('m535','m513','Short Interest','info/productDetail.asp?dpbID=7','','','');
oM.makeMenu('m536','m513','Corporate Actions','info/productDetail.asp?dpbID=29','','','');
oM.makeMenu('m537','m513','Administrative','','','','');
oM.makeMenu('m580','m537','Post & Specialist','info/productDetail.asp?dpbID=1','','','');
oM.makeMenu('m581','m537','Master File','info/productDetail.asp?dpbID=2','','','');
oM.makeMenu('m582','m537','Symbol File','info/productDetail.asp?dpbID=3','','','');
oM.makeMenu('m583','m537','Bond Symbols','info/productDetail.asp?dpbID=4','','','');
oM.makeMenu('m538','m513','Halts & Imbalances','mdx/','','','');
oM.makeMenu('m515','','Documentation','','','','');
oM.makeMenu('m592','m515','Contracts','info/vendorcontracts.asp','','','');
oM.makeMenu('m593','m515','Notices','http://mds.nysedata.com/efpdata/MDS/MarketDataHome.nsf/frmCTANotices?readform&Start=1&Count=10','','','');
oM.makeMenu('m594','m515','Policies','http://mds.nysedata.com/efpdata/MDS/MarketDataHome.nsf/frmPolicies?readform&Start=1&Count=10','','','');
oM.makeMenu('m595','m515','Pricing','','','','');
oM.makeMenu('m599','m595','CTCQ','http://mds.nysedata.com/efpdata/MDS/MarketDataHome.nsf/frmRateSchedules?readform&Start=1&Count=10','','','');
oM.makeMenu('m600','m595','PDP','info/priceList.asp','','','');
oM.makeMenu('m596','m515','Procedures','http://mds.nysedata.com/efpdata/MDS/MarketDataHome.nsf/frmProcedures?readform&Start=1&Count=10','','','');
oM.makeMenu('m516','','Vendor Services','','','','');
oM.makeMenu('m601','m516','Become a vendor','http://mds.nysedata.com/efpdata/MDS/MarketDataHome.nsf/frmVendorApp?openform','','','');
oM.makeMenu('m602','m516','Contracts','http://mds.nysedata.com/efpdata/MDS/MarketDataHome.nsf/frmAgreements?readform','','','');
oM.makeMenu('m603','m516','Datafeed Request','https://mds2.nysedata.com/efpdata/MDS/DataFeedRequestApp/DataFeedRequests.nsf/frmVendorsHome?readform&Start=1&Count=30','','','');
oM.makeMenu('m604','m516','Reporting','https://mds.nysedata.com/mdsdata/vendorreporting/vendorreporting2.nsf/vwstartapp/$first?opendocument&V=&P=mdrptlogin.html','','','');
oM.makeMenu('m517','','Customer Service','','','','');
oM.makeMenu('m609','m517','Billing Issues','mds/default.asp','','','');
oM.makeMenu('m610','m517','Other','info/helpCenter.asp','','','');
oM.makeMenu('m518','','Help','','','','');
oM.makeMenu('m612','m518','Complaints and Inquiries','mds/default.asp','','','33');
oM.makeMenu('m613','m518','FAQs','info/helpCenter.asp','','','');
oM.makeMenu('m614','m518','Product Info','info/productList.asp','','','');
oM.makeMenu('m615','m518','Technical Issue','info/contactus.asp?subjID=2','','','');
oM.makeMenu('m616','m518','Business Issue','info/contactus.asp?subjID=5','','','');
oM.makeMenu('m617','m518','Billing','','','','');
oM.makeMenu('m625','m617','PDP','info/contactus.asp?subjID=3','','','');
oM.makeMenu('m626','m617','CTCQ','mds/default.asp','','','');
oM.makeMenu('m618','m518','Website Comments','info/contactus.asp?subjID=6','','','');
oM.construct(); /*Create the menus*/
</script></td>
    <td width="10"> </td>
    <td align="center" width="615" valign="top">

		<table border="0" cellpadding="3" cellspacing="0" width="615">
		  <tr>
		    <td width="615" class="pageTitle">TAQ Web</td>
		  </tr>
		  <tr>
			<td width="615" height="5"></td>
		  </tr>
		  <!--<tr>
		    <td>
				<map id="mymap" name="mymap">
					<area shape="rect" coords="138,2,207,31" href="./queries/makeQuery10b.asp">
				</map>
				
		
		
	


	

		Tabs-TradesQuotes.gif
	

		    </td>
		  </tr>-->
		  <tr><td><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr><td width="5" nowrap background="/images/tab_start_stop.gif"></td><td width="24">/images/tab_left_whi.gif</td><td nowrap background="/images/tab_back_whi.gif" align="center" class="tabMenus">Trades</td><td width="24">/images/tab_whi_o_blu.gif</td><td nowrap background="/images/tab_back_blu.gif" align="center" bgcolor="#E7EDF9" class="tabMenus">Quotes</td><td width="24">/images/tab_right_blu.gif</td><td width="100%" align="right" background="/images/tab_start_stop.gif"></td></tr></table></td></tr>

		</table>
	    <form name="formMakeQuery" method="post" action="queries/queryresults10a.asp">
		<table border="0" cellpadding="1" cellspacing="0" width="550" align="center">
		  <tr>
		    <td class="viewColElement2"> </td>
			<td class="viewColElement3">Help?</td>
		  </tr>
		</table>
		<table border="0" cellpadding="3" cellspacing="0" align="center">
		  <tr>
		    <td class="viewFieldName">Symbol:</td>
		    <td class="viewColElement2"><input type="text" name="querySymbol" maxlength="10" size="15" value=""> <input type=button value="Look Up" title="Look Up Symbol" class="dbutton" name="symbolLookUp" onClick="doOpenWin('symbol');"></td>
		  </tr>
		  <tr>
		    <td class="viewFieldName">Date:</td>
			<td class="viewColElement2"><input type="text" name="queryDate" maxlength="10" size="15" value="10/3/2003"> </td>
		  </tr>
		  <tr>
		    <td class="viewFieldName">Time Begin (hh:mm):</td>
			<td class="viewColElement2"><input type="text" name="queryTimeBegin" maxlength="5" size="10" value="8:00"> <select name="beginAMPM" size="1"><option value="am" selected>AM</option><option value="pm" >PM</option></select></td>
		  </tr>
		  <tr>
		    <td class="viewFieldName">Time End (hh:mm):</td>
			<td class="viewColElement2"><input type="text" name="queryTimeEnd" maxlength="5" size="10" value="7:00"> <select name="endAMPM" size="1"><option value="am" >AM</option><option value="pm" selected>PM</option></select></td>
		  </tr>
		  <tr>
			<td class="viewFieldName" valign="top">Exchange:</td>
			<td class="viewColElement2">
			  <table border="0" cellpadding="0" cellspacing="0" align="left">
			    <tr>
			      <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="N" checked>NYSE</td>
			      <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="W" checked>CBOE</td>
			      <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="P" checked>Pacific</td>
				</tr>
				<tr>
			      <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="A" checked>AMEX</td>
			      <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="M" checked>Chicago</td>
			      <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="T" checked>NASDAQ</td>
				</tr>
				<tr>
			      <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="B" checked>Boston</td>
			      <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="C" checked>Cinn</td>
			      <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="X" checked>Phili</td>
				</tr>
			  </table>
			</td>
		  </tr>
		</table>
		<table border="0" cellpadding="3" cellspacing="0" align="center">
		   	<tr height="20"><td width="160"></td></tr>
			<tr>	
			  <td align="right" width="176"><input type="button" name="cancel" value="Cancel" class="dbutton1" title="Cancel" onclick="window.location.href='../currentData.asp'"></td>
			  <td align="center" width="259"><input type="button" name="submitIt" value="Submit" class="dbutton1" title="Submit" onclick="doSubmit(document.formMakeQuery);"></td>
			</tr>
		   	<tr height="10"><td width="160"></td></tr>
		</table>
		</form>

    </td>
  </tr>
</table>
<table border="0" width="760" cellspacing="0" cellpadding="0">
  <tr>
    <td width="145" class="footer"> </td>
    <td height="30"></td>
  </tr>
  <tr>
    <td width="145" class="footer"> </td>
    <td><hr size="1" class="lineColor"></td>
  </tr>
  <tr>
    <td width="145" class="footer"> </td>
    <td align="center" class="footer">© 2003 NYSE Inc. All Rights Reserved
      - Privacy - Conditions of Use</td>
  </tr>
  <tr>
    <td width="145" class="footer"> </td>
    <td align="center" class="footer"> </td>
  </tr>
</table>

</body>
</html>
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Sort by date Sort by votes
Hi Oliver ,
I think it's possible with web query. I tried but I got a message as follows. "You must log in before getting a file" :D
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
VBA for Web Scraping help
Replies
0
Views
579
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
Nelson78
  • Question
VBA and Scraping a table from web: how can I detect an image?
Replies
2
Views
355
Domenic
D
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
S
  • Question
How to click a link inside a table using VBA
Replies
0
Views
2K
swapnilk
S

Forum statistics

Threads
1,214,581
Messages
6,120,372
Members
448,957
Latest member
BatCoder

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top