How do I get to get answers when typing such as PSQ(B4;"PRICE")

Question

0.00/5 (No votes)

See more: (untagged)

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?

Posted 18-Mar-15 10:22am

Member 11536401

Add a Solution

Comments

ZurdoDev 18-Mar-15 16:36pm

ERROR means you did something wrong. You have to refer to the documentation to see what is valid.

However semi-colons are never valid like that. Use commas to separate parameters.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 11536401 · Answer 1 · 2015-03-18T10:53:00

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.