键入PSQ(B4;“PRICE”)时如何获得答案? [英] How do I get to get answers when typing such as PSQ(B4;"PRICE")
问题描述
当我键入PSQ(B4)时,它将为B4单元格中的股票代码提供正确的价格。如果我在我的电子表格中键入PSQ(B4;PRICE),我将只收到该条目的错误列表。我使用的是Microsoft Excel 2007.加载项下列出了正确的加载项。
我不知道上面标签是什么意思。我不知道该放什么。
我已经从本网站下载并设置了Excel 2007的股票报价加载项。
为什么它识别一个条目但是只会错误的另一个?
When I type PSQ(B4) it will give the correct price for the stock symbol in B4 cell. If I type PSQ(B4;"PRICE") into my Spreadsheet I will only get an ERROR listing for the entry. I am using Microsoft Excel 2007. The correct add-ins are listed under Add-ins.
I do not know what is meant by "Tags" above. I do not know what to put there.
I have downloaded and setup the Stock Quote Add-In for Excel 2007 from this Site.
Why does it recognize one entry but will only ERROR the other?
推荐答案
谢谢RyanDev的电子邮件。它现在有效。
我使用了分号,因为这是在本网站上用作下载系统的一个例子。
是否还有其他任何条目得到股票的东西?比如PRICE CHANGE。
我再次感谢你。我现在可以在电子表格中构建我想要的内容。
Thank You RyanDev for your e-mail. It now works.
I used the Semi-colon because that is what is used on this site as an example for the downloaded system.
Are ther any other entries that will get something for a stock? Such as PRICE CHANGE.
Again I thank you. I can now build what I want in my Spreadsheet.
这篇关于键入PSQ(B4;“PRICE”)时如何获得答案?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!