aacod
Well-known Member
- Joined
- Mar 20, 2009
- Messages
- 667
Below are links to 2 different excel stock files, created by Samir Khan.
<http://investexcel.net/<wbr>multiple-stock-quote-<wbr>downloader-for-excel/>
<http://investexcel.net/<wbr>automatically-download-<wbr>historical-forex-data-into-<wbr>excel/>
Both files are FREE to download, both have VBA code(s) and as per the author, codes on both the files can be edited as required by the user(mentioned on the website).
What I need is as follows:
On the Multiple Stock Quote Downloader file when I hit the ‘Get Bulk Quotes’ button on the Parameter sheet after filling in the requirements, it creates new sheets for each ticker requested, to these new sheets I want to add:
2. ‘PRICE in US Dollars’ in each cell under column ‘I’ on all newly created ticker sheets by creating a formula that
would convert the Adjusted Rate from column ‘G’ divided by the price from column ‘I’ to a price in US dollars,
rounded to 2 decimals, e.g. $25.65.
3. On the Parameter sheet, I would prefer the following change:
In cell B5: ‘End Date’ and in cell B6 ‘Start Date’ this would give the latest date and price on top in row A3 on all
newly created ticker sheets without scrolling all the way to the bottom to see the latest price.
4. On the Parameter sheet: On checking off the box in cell A8 to create ‘CSV’ files, I would prefer the CSV file be
created as under C:\Desktop\CSV
The Exchange rate under column ‘H’ and Price in US $ under column ‘I’ must appear with any ‘FREQUENCY’ selection under cell B7 on Parameter’s sheet.
Thanks.
aacod
<http://investexcel.net/<wbr>multiple-stock-quote-<wbr>downloader-for-excel/>
<http://investexcel.net/<wbr>automatically-download-<wbr>historical-forex-data-into-<wbr>excel/>
Both files are FREE to download, both have VBA code(s) and as per the author, codes on both the files can be edited as required by the user(mentioned on the website).
What I need is as follows:
On the Multiple Stock Quote Downloader file when I hit the ‘Get Bulk Quotes’ button on the Parameter sheet after filling in the requirements, it creates new sheets for each ticker requested, to these new sheets I want to add:
- ‘Daily Exchange Rate’ under column ‘H’ in each cell on all newly created ticker sheets for the duration selected on Parameters Sheet, from the following link <http://www.oanda.com/currency/historical-rates/> <http: www.oanda.com="" currency="" historical-rates=""><http: www.oanda.com="" currency="" historical-rates="">, under Historical Exchange Rate’s tab. I specifically prefer Indian Rupees to US Dollars, e.g. (1 INR = US $0.0161). </http:> </http:>
2. ‘PRICE in US Dollars’ in each cell under column ‘I’ on all newly created ticker sheets by creating a formula that
would convert the Adjusted Rate from column ‘G’ divided by the price from column ‘I’ to a price in US dollars,
rounded to 2 decimals, e.g. $25.65.
3. On the Parameter sheet, I would prefer the following change:
In cell B5: ‘End Date’ and in cell B6 ‘Start Date’ this would give the latest date and price on top in row A3 on all
newly created ticker sheets without scrolling all the way to the bottom to see the latest price.
4. On the Parameter sheet: On checking off the box in cell A8 to create ‘CSV’ files, I would prefer the CSV file be
created as under C:\Desktop\CSV
The Exchange rate under column ‘H’ and Price in US $ under column ‘I’ must appear with any ‘FREQUENCY’ selection under cell B7 on Parameter’s sheet.
Thanks.
aacod
Last edited:
