Rabu, 02 September 2015

[smf_addin] Digest Number 3501[4 Attachments]

9 Messages

Digest #3501

Messages

Tue Sep 1, 2015 8:14 am (PDT) . Posted by:

rogacox

Hi Randy,
I checked the web query and all looks ok. Using your link in your reply, the computer is using IE11. I am still debugging the spreadsheet I sent to determine why I am getting error messages or null values for some entries. It is strange that these errors are only occurring when I am adding a new security ticker. I am attaching a PDF file that shows in the right hand column how the returns are different for added tickers. Note the values are contained in the query to nasdaq on the old tickers, but not on the new tickers. Any idea what could cause this for added tickers? I suspect this is also the reason I am getting the error messages for the zacks queries. The pdf reflects that I have sorted the spreadsheet in case this was a problem for the end of the file which I have now ruled out. This pdf is the same as the spreadsheet I uploaded yesterday. I was afraid that when you loaded the spreadsheet it calculated everything automatically so you didn't see the error and blank entries. Thank you in advance for your assistance.
Roger
Attachment(s) from
1 of 1 File(s)

Tue Sep 1, 2015 8:19 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

What happens if you just do a normal function, instead of using
smfUpdateDownloadTable? For example:

=RCHGetElementNumber("AAPL",13870)

Which version of the add-in are you using:

=RCHGetElementNumber("Version")

On Tue, Sep 1, 2015 at 8:13 AM, rogacox@... wrote:

>
> Hi Randy,
> I checked the web query and all looks ok. Using your link in your reply,
> the computer is using IE11. I am still debugging the spreadsheet I sent to
> determine why I am getting error messages or null values for some entries.
> It is strange that these errors are only occurring when I am adding a new
> security ticker. I am attaching a PDF file that shows in the right hand
> column how the returns are different for added tickers. Note the values
> are contained in the query to nasdaq on the old tickers, but not on the new
> tickers. Any idea what could cause this for added tickers? I suspect this
> is also the reason I am getting the error messages for the zacks queries.
> The pdf reflects that I have sorted the spreadsheet in case this was a
> problem for the end of the file which I have now ruled out. This pdf is
> the same as the spreadsheet I uploaded yesterday. I was afraid that when
> you loaded the spreadsheet it calculated everything automatically so you
> didn't see the error and blank entries. Thank you in advance for your
> assistance.
> Roger
>

Tue Sep 1, 2015 9:01 am (PDT) . Posted by:

rogacox

With the =RCHGetElementNumber("Version")I get "#NAME?" I installed the June 8, 2015 version earlier today - not sure what version I had installed prior but am still having the same problem. I just tried the March 15,2015 version and still have the same problem. I ran a test using the ElementNumber 13870 and got the same returns - numbers on the old tickers and "Error" on the new ones. The attached pdf shows this in the right column. I am at a loss to explain this. Any ideas are greatly appreciated.
Attachment(s) from
1 of 1 File(s)

Tue Sep 1, 2015 9:09 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

If:

=RCHGetElementNumber("Version")

...is giving you a #NAME? error, then you don't have the add-in installed.
What happened on the other formula?

On Tue, Sep 1, 2015 at 9:01 AM, rogacox@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> With the =RCHGetElementNumber("Version&quot;)I get "#NAME?" I installed the
> June 8, 2015 version earlier today - not sure what version I had installed
> prior but am still having the same problem. I just tried the March 15,2015
> version and still have the same problem. I ran a test using the
> ElementNumber 13870 and got the same returns - numbers on the old tickers
> and "Error" on the new ones. The attached pdf shows this in the right
> column. I am at a loss to explain this. Any ideas are greatly appreciated.
>

Tue Sep 1, 2015 9:19 am (PDT) . Posted by:

rogacox

I had just put "Version" in the element number cell to get the "#NAME?" error. When I put the whole formula in "=RCHGetElementNumber("Version")" I get a "#VALUE!" error. Note in my earlier file attachement I have been using the ElementNumber when I have a number. That is when I get actual good values for the old tickers and "Error" for the new tickers. Strange. It seems like there is a trigger in the code. The Yahoo stuff works fine all the time as can be seen. It is the other sources that are experiencing the error or null value returns. Thanks

Tue Sep 1, 2015 9:27 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't understand the results you're getting with the version formula.
That's about as basic as it gets. It doesn't even use the Internet. There
have been a number of changes to the smfUpdateDownloadTable process. You
may just want to use the latest beta version of the add-in.

I can't think of any reason for your "old" versus "new" issue, except for
cached web pages.

On Tue, Sep 1, 2015 at 9:19 AM, rogacox@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I had just put "Version" in the element number cell to get the "#NAME?"
> error. When I put the whole formula in "=RCHGetElementNumber("Version")"
> I get a "#VALUE!" error. Note in my earlier file attachement I have been
> using the ElementNumber when I have a number. That is when I get actual
> good values for the old tickers and "Error" for the new tickers. Strange.
> It seems like there is a trigger in the code. The Yahoo stuff works fine
> all the time as can be seen. It is the other sources that are experiencing
> the error or null value returns. Thanks
>

Tue Sep 1, 2015 11:42 am (PDT) . Posted by:

rogacox

Still debugging. I copied the new tickers into a new worksheet and then copied the old tickers that had values. After forcing a recalculation these are the results. I am at a loss to figure what is causing this. Is there another way I can debug this? I have attached both the worksheet and the pdf of the worksheet just in case your computer automatically recalculates the values and you don't get the same results I am getting. You can see in the right hand column that I use as a test that the results mirror the rest of the spreadsheet which are just plain strange since the early entries find no value and the latter entries find the correct value. Wish I could give you more information to help solve this but I don't know what else would be helpful. The data retrieval appears to work for Yahoo and Reuters but the other sources get these strange results. Thanks again for your help.
Attachment(s) from
2 of 2 File(s)

Tue Sep 1, 2015 11:57 am (PDT) . Posted by:

rogacox

Finally found the problem!! The new tickers had a leading space prior to the letter. Take out the space and it works fine! Thanks for your help.

Tue Sep 1, 2015 12:01 pm (PDT) . Posted by:

rogacox

I had copied the list of tickers from an industry list. Sorry I did not put this in the prior email. Syntax, syntax, syntax.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.06

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)