访问：更新雅虎财经的日终股票价值
我即将向我的数据库添加一个内容，这可能会让那些通常不习惯使用它的用户的生活变得更加轻松。
我的数据库中有一个表；其中在另一个表中保存 Historical_stock_data 和 Historical_currency_data （将股价转换为美元的值）。他们每个人基本上都有四个＆amp;分别为三列（StockCode、Dates、SharePrice、Volume）和（CurrencyCode、Dates、Rates）。
现在每个交易日结束时；我需要更新这两个表。数据库中约有200家公司；目前我基本上在雅虎金融有一个投资组合，包含所有 200 家公司，我将其下载到 Excel 中并进行编辑，使其与列相匹配；然后通过添加到表来手动更新数据库。 （我也可以使用转账电子表格方法来执行此操作，但我曾经遇到过问题，所以现在手动执行；我的编码技能不是最好的）
货币价格，因为数据库中只有大约 6 种货币换成美元；我手动更新它们；目前这不是问题；但如果包括更多来自不同国家的公司，那就会更容易；此外，将事情自动化总是更好；所以想知道这是否也可能。
因此，如果有一种方法可以在每天结束时将这些值直接更新到 Access 中，而无需费心使用 Excel；那太好了。如果有的话，如果我看到一个示例，说明要使用哪种代码，仅用一个示例；我应该能够完成它。
am about to make an addition to my database that might make life much easier for users that are not normally accustomed to using it.
I have a table in my database; which holds Historical_stock_data and Historical_currency_data (Values to convert Share Price into dollars) in the other table. Each of them have basically got four & three columns (StockCode, Dates, SharePrice, Volume) and (CurrencyCode, Dates, Rates) respectively.
Now at the end of each trading day; I need to update the both tables. There around 200 companies in the database; and currently I basically have a portfolio in Yahoo finance holding all 200 companies which I download into Excel and edit so it matches the columns; and then manually update the database by adding to the table. (I can use the transfer spreadsheet method as well to do this but I ran into a problem once with it so do it manually now; my coding skills are not the greatest)
The currency prices, since there are only around 6 currencies in the database to dollars; I update them manually; this is not an issue at the moment; but if more companies from different countries are included than it would be easier; and besides it is always better to automate things; so was wondering if this was possible as well.
So if there was a way to update these values directly into Access at the end of each day without having to bother with Excel; that would be great. If there is then if I'm shown an example of what sort of code to use with just one example; I should be able to finish it.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
搜索“yahoo stock Price excel”，您应该会找到很多示例代码。然后将代码转换为使用记录集/表格而不是单元格，就完成了。
Search on "yahoo stock price excel" and you should find lots of sample code. Then convert the code to using recordsets/tables instead of cells and you're done.