DRSteele
Well-known Member
- Joined
- Mar 31, 2015
- Messages
- 2,654
- Office Version
- 365
- Platform
- Windows
Can someone please help me?
I have the following cell in a workbook. It is a formula that relies on the contents of three cells by using function CONCAT. [FYI. The three cells are the stock symbol (CNQ), the end date (3/30/2016 and the start date (1/12/1995). Note that for some reason yahoo says January is month 0.][TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"]
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"]http://real-chart.finance.yahoo.com/table.csv?s=CNQ.TO&d=2&e=30&f=2016&g=d&a=0&b=12&c=1995&ignore=.csv[/TD]
[/TR]
</tbody>[/TABLE]
I would like to create a Parameter out of that and pass it to a Query that goes to that source and downloads the csv file that exists on that webpage. My objective is to enter a stock symbol, an end date and a start date and have the query download the data to the workbook.
I have the following cell in a workbook. It is a formula that relies on the contents of three cells by using function CONCAT. [FYI. The three cells are the stock symbol (CNQ), the end date (3/30/2016 and the start date (1/12/1995). Note that for some reason yahoo says January is month 0.][TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"]
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"]http://real-chart.finance.yahoo.com/table.csv?s=CNQ.TO&d=2&e=30&f=2016&g=d&a=0&b=12&c=1995&ignore=.csv[/TD]
[/TR]
</tbody>[/TABLE]
I would like to create a Parameter out of that and pass it to a Query that goes to that source and downloads the csv file that exists on that webpage. My objective is to enter a stock symbol, an end date and a start date and have the query download the data to the workbook.