Senin, 26 September 2011

[smf_addin] Digest Number 1966

Messages In This Digest (14 Messages)

Messages

1a.

question for Randy..regarding RCHGetYahooQuotes function not working

Posted by: "investor952" investor952@yahoo.com   investor952

Sun Sep 25, 2011 12:32 pm (PDT)



In my spreadsheet, in the column that I use the function:
RCHGetYahooQuotes($C78,l1) , to find the last trade value, is working for most tickers, but not for PVR and TWO. For these 2 tickers, the function is returning 0. However, for example, when I go to

http://finance.yahoo.com/q?s=two&ql=1,

the values are there.

Also for these 2 stocks, RCHGetYahooQuotes($C78,n)is not giving me the company names, but rather, the ticker symbol. The previous close and ex-div date isn't working either.

Pls advise..thanks.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.

Re: question for Randy..regarding RCHGetYahooQuotes function not wor

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Sep 25, 2011 1:41 pm (PDT)



Sorry, but the add-in is giving you what Yahoo is returning:

view-source:
http://download.finance.yahoo.com/d/quotes.csv?s=TWO,PVR&f=nqp&e=.csv

On Sun, Sep 25, 2011 at 12:32 PM, investor952 <investor952@yahoo.com> wrote:

> In my spreadsheet, in the column that I use the function:
> RCHGetYahooQuotes($C78,l1) , to find the last trade value, is working for
> most tickers, but not for PVR and TWO. For these 2 tickers, the function is
> returning 0. However, for example, when I go to
>
> http://finance.yahoo.com/q?s=two&ql=1,
>
> the values are there.
>
> Also for these 2 stocks, RCHGetYahooQuotes($C78,n)is not giving me the
> company names, but rather, the ticker symbol. The previous close and ex-div
> date isn't working either.
>
> Pls advise..thanks.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

question for Randy regarding RCHGetTableCell function

Posted by: "investor952" investor952@yahoo.com   investor952

Sun Sep 25, 2011 12:43 pm (PDT)



Hello Randy..I just tried using the function:

=RCHGetTableCell("http://www.marketwatch.com/investing/stock/NCC.PC",1,"Ex dividend date")

and get 'error'

The website is:

http://www.marketwatch.com/investing/stock/NCC.PC

and I am trying to pull the ex-dividend date.

I can't use Yahoo because they are missing a lot of data for preferred stock . NCC.PC is a preferred stock.

I also get this same error when I try other tickers for regular stocks.

Pls advise?

thx.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.

Re: question for Randy regarding RCHGetTableCell function

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Sep 25, 2011 1:36 pm (PDT)



The data you want is NOT presented in an HTML table, so that function won't
be able to extract the data. Try:

=smfGetTagContent("http://www.marketwatch.com/investing/stock/NCC.PC","p",1,"Ex
dividend date")

On Sun, Sep 25, 2011 at 12:43 PM, investor952 <investor952@yahoo.com> wrote:

> Hello Randy..I just tried using the function:
>
> =RCHGetTableCell("http://www.marketwatch.com/investing/stock/NCC.PC",1,"Ex
> dividend date")
>
> and get 'error'
>
> The website is:
>
> http://www.marketwatch.com/investing/stock/NCC.PC
>
> and I am trying to pull the ex-dividend date.
>
> I can't use Yahoo because they are missing a lot of data for preferred
> stock . NCC.PC is a preferred stock.
>
> I also get this same error when I try other tickers for regular stocks.
>
> Pls advise?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

How come this is only calculating in the first cell?

Posted by: "naderphilip" naderphilip@yahoo.com   naderphilip

Sun Sep 25, 2011 1:32 pm (PDT)



I just downloaded the SMF add in and it was working great the other day. But now when I highlight the array and then type in the formula it only populates in the first cell that was highlighted. Am I doing something wrong?
Sorry if this is a dumb newbie question. Any help is greatly appreciated.

Thanks,
Nader

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3b.

Re: How come this is only calculating in the first cell?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Sep 25, 2011 1:33 pm (PDT)



After typing in (or editing the formula), you need to press Ctrl-Shift-Enter
instead of just Enter to array-enter a formula.

On Sun, Sep 25, 2011 at 1:22 PM, naderphilip <naderphilip@yahoo.com> wrote:

> I just downloaded the SMF add in and it was working great the other day.
> But now when I highlight the array and then type in the formula it only
> populates in the first cell that was highlighted. Am I doing something
> wrong?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3c.

Re: How come this is only calculating in the first cell?

Posted by: "Nader masarweh" naderphilip@yahoo.com   naderphilip

Sun Sep 25, 2011 1:45 pm (PDT)



Oh ya. Thx!!!

Sent from my Motorola ATRIX™ 4G on AT&T

-----Original message-----
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Sun, Sep 25, 2011 20:33:50 GMT+00:00
Subject: Re: [smf_addin] How come this is only calculating in the first cell?

After typing in (or editing the formula), you need to press Ctrl-Shift-Enter
instead of just Enter to array-enter a formula.

On Sun, Sep 25, 2011 at 1:22 PM, naderphilip <naderphilip@yahoo.com> wrote:

> I just downloaded the SMF add in and it was working great the other day.
> But now when I highlight the array and then type in the formula it only
> populates in the first cell that was highlighted. Am I doing something
> wrong?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
4a.

Google Element numbers changed?

Posted by: "pilzadam" adampilz.2326@gmail.com   pilzadam

Sun Sep 25, 2011 3:00 pm (PDT)



Hey,

It has been a while since i used the add-in. Have the element numbers for google changed or has there been an update to the addin? For some reason it seems like the google financial statement sheets, or any element from google for that matter, aren't functioning properly

Thanks so much,
AP

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
4b.

Re: Google Element numbers changed?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Sep 25, 2011 3:05 pm (PDT)



You probably just need the new element definitions from the "Works in
Progress" folder in the files area. Run the smfForceRecalculation macro
after replacing the file so that the add-in will load the new definition.

On Sun, Sep 25, 2011 at 3:00 PM, pilzadam <adampilz.2326@gmail.com> wrote:

>
> It has been a while since i used the add-in. Have the element numbers for
> google changed or has there been an update to the addin? For some reason it
> seems like the google financial statement sheets, or any element from google
> for that matter, aren't functioning properly
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
4c.

Re: Google Element numbers changed?

Posted by: "adam pilz" adampilz.2326@gmail.com   pilzadam

Sun Sep 25, 2011 4:21 pm (PDT)



Randy,

I appreciate your quick response, but one more question. I have saved the
new files but not sure how to run the smfForceRecalculation macro. I tried
to look in the documentation folder but did not find any info.

Thanks again,
AP

On Sun, Sep 25, 2011 at 6:05 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> You probably just need the new element definitions from the "Works in
> Progress" folder in the files area. Run the smfForceRecalculation macro
> after replacing the file so that the add-in will load the new definition.
>
>
> On Sun, Sep 25, 2011 at 3:00 PM, pilzadam <adampilz.2326@gmail.com> wrote:
>
>>
>> It has been a while since i used the add-in. Have the element numbers for
>> google changed or has there been an update to the addin? For some reason it
>> seems like the google financial statement sheets, or any element from google
>> for that matter, aren't functioning properly
>>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
4d.

Re: Google Element numbers changed?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Sep 25, 2011 4:32 pm (PDT)



Check out the "Links" area of the group. There's a pointer to information on
it there.

On Sun, Sep 25, 2011 at 4:21 PM, adam pilz <adampilz.2326@gmail.com> wrote:

>
> I appreciate your quick response, but one more question. I have saved the
> new files but not sure how to run the smfForceRecalculation macro. I
> tried to look in the documentation folder but did not find any info.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
4e.

Re: Google Element numbers changed?

Posted by: "adam pilz" adampilz.2326@gmail.com   pilzadam

Sun Sep 25, 2011 4:35 pm (PDT)



Thank you.
AP

On Sun, Sep 25, 2011 at 7:32 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> Check out the "Links" area of the group. There's a pointer to information
> on it there.
>
>
> On Sun, Sep 25, 2011 at 4:21 PM, adam pilz <adampilz.2326@gmail.com>wrote:
>
>>
>> I appreciate your quick response, but one more question. I have saved the
>> new files but not sure how to run the smfForceRecalculation macro. I
>> tried to look in the documentation folder but did not find any info.
>>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
5a.

wrong number

Posted by: "StanG" asahi3@hotmail.com   arigato12000

Sun Sep 25, 2011 5:45 pm (PDT)



Hi
When using smfGetOptionExpiry with the month = 9 it returns a date in the tenth (10) month.
smfGetOptionExpiry(2011,9) returns 10/22/2011.
so does smfGetOptionExpiry(2011,10)...
Stan Graham

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5b.

Re: wrong number

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Sep 25, 2011 6:01 pm (PDT)



Thanks. That has been fixed

It used to be that if you asked for the current year and month and the
current date was past that month's expiration date, it would give you the
following month's expiration date. The beta version of the add-in, in the
"Works in Progress" folder, now only does that processing if you ask for the
default values of year and month -- which right now would be 2011 and 9. But
it still gives you the current month expiration if you explicitly give them
both.

So, for me:

Returned Function invocation 2011-10-22 =smfGetOptionExpiry() 2011-09-17
=smfGetOptionExpiry(2011,9) 2011-10-22 =smfGetOptionExpiry(2011,10)
On Sun, Sep 25, 2011 at 5:44 PM, StanG <asahi3@hotmail.com> wrote:

> When using smfGetOptionExpiry with the month = 9 it returns a date in the
> tenth (10) month.
> smfGetOptionExpiry(2011,9) returns 10/22/2011.
> so does smfGetOptionExpiry(2011,10)...
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 03.07

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)