键入PSQ(B4;“PRICE”)时如何获得答案? [英] How do I get to get answers when typing such as PSQ(B4;"PRICE")

查看:102
本文介绍了键入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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆