Randy, it behaves very strangely . Sometimes it does not work, than I go and check on yahoo website directly. After finding the results I need on the website, I go back and run smfForceRecalculation and magically it works. Then maybe after 20', I run smfForceRecalculation again and they disappear.

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

More details please. All three of those are working fine here, as:

=RCHGetElementNumber("MMM";,4924)
=RCHGetElementNumber("MMM";,992)
=smfGetOptionStrikes("MMM";,"12/21/2013")

On Sun, Nov 24, 2013 at 11:23 AM, <john.kalkanis@... mailto:john.kalkanis@...> wrote:
for example right now I am having problems with these functions:
smfGetOptionStrikes
=RCHGetElementNumber($B11,4924)
RCHGetElementNumber($B11,992)

Reply to sender . Reply to group . Reply via Web Post . All Messages (13) . Top ^

1b

Re: wmf add-in stopped responding

Mon Nov 25, 2013 7:14 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Did you install a new version of IE recently, or have something that would
have fiddled with your Internet settings? Or a product that attempts to
manage the Temporary Internet Files?

On Mon, Nov 25, 2013 at 7:47 AM, <john.kalkanis@yahoo.com> wrote:

> Randy, it behaves very strangely . Sometimes it does not work, than I go
> and check on yahoo website directly. After finding the results I need on
> the website, I go back and run smfForceRecalculation and magically it
> works. Then maybe after 20', I run smfForceRecalculation again and they
> disappear.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (13) . Top ^

1c

Re: wmf add-in stopped responding

Mon Nov 25, 2013 7:54 am (PST) . Posted by:

john.kalkanis

I have a mac and use vmware (windows xp virtual machine). I also have another excel add-in (qmatix) to get stock pricing data. But I always had this setup for many months and it worked till yesterday.

what should I check to see if I have indadvertedly messed around settings?

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

Did you install a new version of IE recently, or have something that would have fiddled with your Internet settings? Or a product that attempts to manage the Temporary Internet Files?

On Mon, Nov 25, 2013 at 7:47 AM, <john.kalkanis@... mailto:john.kalkanis@...> wrote:
Randy, it behaves very strangely . Sometimes it does not work, than I go and check on yahoo website directly. After finding the results I need on the website, I go back and run smfForceRecalculation and magically it works. Then maybe after 20', I run smfForceRecalculation again and they disappear.

Reply to sender . Reply to group . Reply via Web Post . All Messages (13) . Top ^

1d

Re: wmf add-in stopped responding

Mon Nov 25, 2013 8:20 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Make sure Internet Options are set to get fresh content "Every time I visit
the web page". How much disk space is allocated and number of days to
retain history may also be a factor.

Otherwise, I'm running out of ideas...

On Mon, Nov 25, 2013 at 8:54 AM, <john.kalkanis@yahoo.com> wrote:

> I have a mac and use vmware (windows xp virtual machine). I also have
> another excel add-in (qmatix) to get stock pricing data. But I always had
> this setup for many months and it worked till yesterday.
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (13) . Top ^

2a

dividend yield

Mon Nov 25, 2013 6:58 am (PST) . Posted by:

john.kalkanis

is there a way to retrieve the forward dividend yield for a specific stock in a specific date? only one piece of data, not a table... Thanks

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Re: dividend yield

Mon Nov 25, 2013 7:16 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I don't know of anything that would have such history...

On Mon, Nov 25, 2013 at 7:58 AM, <john.kalkanis@yahoo.com> wrote:

>
> is there a way to retrieve the forward dividend yield for a specific stock
> in a specific date? only one piece of data, not a table... Thanks
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3a

Re: Extract Open High Low from Google Finance

Mon Nov 25, 2013 8:49 am (PST) . Posted by:

"Ali Imran Naqvi" dillli_ka_baadshah

However, I was wondering how could we extract only single numbers from the
"Range" tag?

On Mon, Nov 25, 2013 at 11:52 AM, Ali Imran Naqvi <naqviimran@gmail.com>wrote:

> Thank you my friend.
>
>
> On Mon, Nov 25, 2013 at 11:22 AM, Randy Harmelink <rharmelink@gmail.com>wrote:
>
>>
>>
>> Simplest form of RCHGetTableCell():
>>
>> =RCHGetTableCell("https://www.google.com/finance?q=500312",1,">Open")
>> =RCHGetTableCell("https://www.google.com/finance?q=500312",1,">Range")
>>
>>
>> On Sun, Nov 24, 2013 at 10:21 PM, Ali Imran Naqvi <naqviimran@gmail.com>wrote:
>>
>>>
>>> I am trying to extract the open high and low from the following link:
>>>
>>> https://www.google.com/finance?q=500312
>>>
>>> Can u please help?
>>>
>>>
>>
>>
>
>
>
> --
> Ali Imran Naqvi
> 9327016964
>
> "Smooth sea never makes a skillful mariner"
>

--
Ali Imran Naqvi
9327016964

"Smooth sea never makes a skillful mariner"

Reply to sender . Reply to group . Reply via Web Post . All Messages (10) . Top ^

3b

Re: Extract Open High Low from Google Finance

Mon Nov 25, 2013 8:58 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You need to parse it out. I would use the smfStrExtr() function. For
example:

=smfConvertData(smfstrExtr(RCHGetTableCell("
https://www.google.com/finance?q=500312",1,">Range"),"~"," "))

=smfConvertData(smfstrExtr(RCHGetTableCell("
https://www.google.com/finance?q=500312",1,">Range"),"-","~"))

On Mon, Nov 25, 2013 at 9:48 AM, Ali Imran Naqvi <naqviimran@gmail.com>wrote:

>
> However, I was wondering how could we extract only single numbers from the
> "Range" tag?
>
> On Mon, Nov 25, 2013 at 11:52 AM, Ali Imran Naqvi <naqviimran@gmail.com>wrote:
>
>> Thank you my friend.
>>
>> On Mon, Nov 25, 2013 at 11:22 AM, Randy Harmelink <rharmelink@gmail.com>wrote:
>>
>>>
>>> Simplest form of RCHGetTableCell():
>>>
>>> =RCHGetTableCell("https://www.google.com/finance?q=500312",1,">Open")
>>> =RCHGetTableCell("https://www.google.com/finance?q=500312",1,">Range")
>>>
>>

Reply to sender . Reply to group . Reply via Web Post . All Messages (10) . Top ^

3c

Re: Extract Open High Low from Google Finance

Mon Nov 25, 2013 9:03 am (PST) . Posted by:

"Ali Imran Naqvi" dillli_ka_baadshah

Seems to be returning #NAME? error....Anything wrong?

On Mon, Nov 25, 2013 at 10:28 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

>
>
> You need to parse it out. I would use the smfStrExtr() function. For
> example:
>
> =smfConvertData(smfstrExtr(RCHGetTableCell("
> https://www.google.com/finance?q=500312",1,">Range"),"~"," "))
>
> =smfConvertData(smfstrExtr(RCHGetTableCell("
> https://www.google.com/finance?q=500312",1,">Range"),"-","~"))
>
> On Mon, Nov 25, 2013 at 9:48 AM, Ali Imran Naqvi <naqviimran@gmail.com>wrote:
>
>>
>> However, I was wondering how could we extract only single numbers from
>> the "Range" tag?
>>
>> On Mon, Nov 25, 2013 at 11:52 AM, Ali Imran Naqvi <naqviimran@gmail.com>wrote:
>>
>>> Thank you my friend.
>>>
>>> On Mon, Nov 25, 2013 at 11:22 AM, Randy Harmelink <rharmelink@gmail.com>wrote:
>>>
>>>>
>>>> Simplest form of RCHGetTableCell():
>>>>
>>>> =RCHGetTableCell("https://www.google.com/finance?q=500312",1,">Open")
>>>> =RCHGetTableCell("https://www.google.com/finance?q=500312",1,">Range")
>>>>
>>>
>
>

--
Ali Imran Naqvi
9327016964

"Smooth sea never makes a skillful mariner"

Reply to sender . Reply to group . Reply via Web Post . All Messages (10) . Top ^

3d

Re: Extract Open High Low from Google Finance

Mon Nov 25, 2013 9:05 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Do may have an older version of the add-in, before that function was added?

On Mon, Nov 25, 2013 at 10:02 AM, Ali Imran Naqvi <naqviimran@gmail.com>wrote:

>
> Seems to be returning #NAME? error....Anything wrong?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (10) . Top ^

3e

Re: Extract Open High Low from Google Finance

Mon Nov 25, 2013 9:06 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Ack. Time to go to sleep.

YOU may have an older version of the add-in, before that function was added?

On Mon, Nov 25, 2013 at 10:05 AM, Randy Harmelink <rharmelink@gmail.com>wrote:

> Do may have an older version of the add-in, before that function was added?
>
> On Mon, Nov 25, 2013 at 10:02 AM, Ali Imran Naqvi <naqviimran@gmail.com>wrote:
>
>>
>> Seems to be returning #NAME? error....Anything wrong?
>>
>>

Reply to sender . Reply to group . Reply via Web Post . All Messages (10) . Top ^

3f

Re: Extract Open High Low from Google Finance

Mon Nov 25, 2013 9:31 am (PST) . Posted by:

"Ali Imran Naqvi" dillli_ka_baadshah

Thanks a lot buddy...Have a sound sleep...

A little more trouble to you...Can u also pls help me extract that current
price along with the knowledge on how to update the numbers on a certain
interval?

Thanks. Thanks. Thanks.

On Mon, Nov 25, 2013 at 10:36 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

>
>
> Ack. Time to go to sleep.
>
> YOU may have an older version of the add-in, before that function was
> added?
>
> On Mon, Nov 25, 2013 at 10:05 AM, Randy Harmelink <rharmelink@gmail.com>wrote:
>
>> Do may have an older version of the add-in, before that function was
>> added?
>>
>> On Mon, Nov 25, 2013 at 10:02 AM, Ali Imran Naqvi <naqviimran@gmail.com>wrote:
>>
>>>
>>> Seems to be returning #NAME? error....Anything wrong?
>>>
>>>
>

--
Ali Imran Naqvi
9327016964

"Smooth sea never makes a skillful mariner"

Reply to sender . Reply to group . Reply via Web Post . All Messages (10) . Top ^

3g

Re: Extract Open High Low from Google Finance

Mon Nov 25, 2013 2:06 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfConvertData(smfGetTagContent("https://www.google.com/finance?q=500312
","span",-1,"_l"">"))

On Mon, Nov 25, 2013 at 10:31 AM, Ali Imran Naqvi <naqviimran@gmail.com>wrote:

>
> A little more trouble to you...Can u also pls help me extract that current
> price along with the knowledge on how to update the numbers on a certain
> interval?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (10) . Top ^

4.1 RCHGetYahooHistory

Mon Nov 25, 2013 8:54 am (PST) . Posted by:

john.kalkanis

is there a way to enter a RCHGetYahooHistory (to retrieve dividends) as an array function, specifying the date range? I have seen examples using it as an array function without specifying the date range (RCHGetYahooHistory then take the last dates by itself). I need to retrieve dividends for each month of the last 2 years. By column i have the end date of each month...

Reply to sender . Reply to group . Reply via Web Post . All Messages (35) . Top ^

4.2 Re: RCHGetYahooHistory

Mon Nov 25, 2013 9:01 am (PST) . Posted by:

"Randy Harmelink" rharmelink

That's a very inefficient way of getting the data. Just retrieve the entire
array of dividend data and then extract what you need from that range of
data. Then it just uses a single Internet access instead of 24.

On Mon, Nov 25, 2013 at 9:54 AM, <john.kalkanis@yahoo.com> wrote:

>
> is there a way to enter a RCHGetYahooHistory (to retrieve dividends) as
> an array function, specifying the date range? I have seen examples using it
> as an array function without specifying the date range (RCHGetYahooHistory
> then take the last dates by itself). I need to retrieve dividends for each
> month of the last 2 years. By column i have the end date of each month...
>