Code:
=== Starting New Session frmOpen====
===Starting New Session Ticker=====================================
Ticker symbols selected is/are AXP+AAPL+BA+NKE
bTickersAcceptable True
-Requested fieldnames LastTradeDate,Symbol,StockName,LastTradePrice
-Requested flddataTypes Varchar(10),Varchar(10),Varchar(50),Currency
Parm string matching these fields for Yahoo <d1snl1>
Going to procedure StatusTblYahooFin to process fields and local table info
Entering StatusTblYahooFin with
-Fields -LastTradeDate,Symbol,StockName,LastTradePrice
-Datatypes -Varchar(10),Varchar(10),Varchar(50),Currency
existing field LastTradeDate requested field LastTradeDate >>same
existing field Symbol requested field Symbol >>same
existing field StockName requested field StockName >>same
existing field LastTradePrice requested field LastTradePrice >>same
User Selected ... Yes = DELETE
tblYahooFin will be deleted
and new tblYahooFin with latest parms/fields created
Drop existing tblFin
tblYahooFin deleted
Entering createFinTable
finalsql-- create Table tblYahooFin( LastTradeDate Varchar(10) , Symbol Varchar(10) , StockName Varchar(50) , LastTradePrice Currency )
new table created
YahFin tbl exists
bFieldsAcceptable True
Set up URL and send request here
Constructed URL to be sent to Yahoo finance http://download.finance.yahoo.com/d/quotes.csv?s=AXP+AAPL+BA+NKE&f=d1snl1
Request sent to Yahoo Fin
Request Status from Yahoo is 200
Request response received from Yahoo Fin
Processing data from Yahoo Fin for insertion into local table
"5/3/2017","AXP","American Express Company",78.83
fld 0 LastTradeDate 5/3/2017
fld 1 Symbol AXP
fld 2 StockName American Express Company
fld 3 LastTradePrice 78.83
---record(0) from Yahoo Fin inserted into local table---
"5/3/2017","AAPL","Apple Inc.",147.06
fld 0 LastTradeDate 5/3/2017
fld 1 Symbol AAPL
fld 2 StockName Apple Inc.
fld 3 LastTradePrice 147.06
---record(1) from Yahoo Fin inserted into local table---
"5/3/2017","BA","Boeing Company (The)",183.39
fld 0 LastTradeDate 5/3/2017
fld 1 Symbol BA
fld 2 StockName Boeing Company (The)
fld 3 LastTradePrice 183.39
---record(2) from Yahoo Fin inserted into local table---
"5/3/2017","NKE","Nike, Inc.",54.53
This field value contains a comma?? "5/3/2017","NKE","Nike, Inc.",54.53
fld 0 LastTradeDate 5/3/2017
fld 1 Symbol NKE
fld 2 StockName Nike, Inc.
fld 3 LastTradePrice 54.53
---record(3) from Yahoo Fin inserted into local table---
03-May-2017 5:42:11 PM -Finished Processing data fom Yahoo Finance into local table ********
Rowsource of fields/parms listbox is
SELECT [YparmInfo].[ID], [YparmInfo].[YParm], [YparmInfo].[YMeaning], [YparmInfo].[YFormat] FROM YparmInfo ORDER BY [ID];
=== Starting New Session frmOpen====
===Starting New Session Ticker=====================================
Ticker symbols selected is/are AXP+AAPL+CAT+MSFT
bTickersAcceptable True
-Requested fieldnames LastTradeDate,Symbol,StockName,LastTradePrice
-Requested flddataTypes Varchar(10),Varchar(10),Varchar(50),Currency
Parm string matching these fields for Yahoo <d1snl1>
Going to procedure StatusTblYahooFin to process fields and local table info
Entering StatusTblYahooFin with
-Fields -LastTradeDate,Symbol,StockName,LastTradePrice
-Datatypes -Varchar(10),Varchar(10),Varchar(50),Currency
existing field LastTradeDate requested field LastTradeDate >>same
existing field Symbol requested field Symbol >>same
existing field StockName requested field StockName >>same
existing field LastTradePrice requested field LastTradePrice >>same
User Selected ... Yes = DELETE
tblYahooFin will be deleted
and new tblYahooFin with latest parms/fields created
Drop existing tblFin
Entering createFinTable
finalsql-- create Table tblYahooFin( LastTradeDate Varchar(10) , Symbol Varchar(10) , StockName Varchar(50) , LastTradePrice Currency )
YahFin tbl exists
bFieldsAcceptable True
Set up URL and send request here
Constructed URL to be sent to Yahoo finance http://download.finance.yahoo.com/d/quotes.csv?s=AXP+AAPL+CAT+MSFT&f=d1snl1
Request sent to Yahoo Fin
Request Status from Yahoo is 200
Request response received from Yahoo Fin
Processing data from Yahoo Fin for insertion into local table
"5/3/2017","AXP","American Express Company Common",78.83
fld 0 LastTradeDate 5/3/2017
fld 1 Symbol AXP
fld 2 StockName American Express Company Common
fld 3 LastTradePrice 78.83
---record(0) from Yahoo Fin inserted into local table---
"5/3/2017","AAPL","Apple Inc.",147.06
fld 0 LastTradeDate 5/3/2017
fld 1 Symbol AAPL
fld 2 StockName Apple Inc.
fld 3 LastTradePrice 147.06
---record(1) from Yahoo Fin inserted into local table---
"5/3/2017","CAT","Caterpillar, Inc. Common Stock",101.54
This field value contains a comma?? "5/3/2017","CAT","Caterpillar, Inc. Common Stock",101.54
fld 0 LastTradeDate 5/3/2017
fld 1 Symbol CAT
fld 2 StockName Caterpillar, Inc. Common Stock
fld 3 LastTradePrice 101.54
---record(2) from Yahoo Fin inserted into local table---
"5/3/2017","MSFT","Microsoft Corporation",69.08
fld 0 LastTradeDate 5/3/2017
fld 1 Symbol MSFT
fld 2 StockName Microsoft Corporation
fld 3 LastTradePrice 69.08
---record(3) from Yahoo Fin inserted into local table---
03-May-2017 5:47:26 PM -Finished Processing data fom Yahoo Finance into local table ********
Good luck.