2 New Messages

Digest #2875

Re: Extract Open High Low from Google Finance by "Ali Imran Naqvi" dillli_ka_baadshah

Re: Extract Open High Low from Google Finance by "Randy Harmelink" rharmelink

Messages

1a

Re: Extract Open High Low from Google Finance

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

"Ali Imran Naqvi" dillli_ka_baadshah

Thanks buddy..How can I update it regularly....Can i put any time interval?

On Tue, Nov 26, 2013 at 3:36 AM, Randy Harmelink <rharmelink@gmail.com>wrote:

>
>
> 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?
>>
>>
>
>

--
Ali Imran Naqvi
9327016964

"Smooth sea never makes a skillful mariner"

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

1b

Re: Extract Open High Low from Google Finance

Mon Nov 25, 2013 10:08 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You'd need to write your own VBA timing routine...and have it execute the
smfForceRecalculation macro.

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

>
> Thanks buddy..How can I update it regularly....Can i put any time interval?
>