12 New Messages
Digest #2883
Messages
Tue Dec 3, 2013 1:08 am (PST) . Posted by:
CyrilLM
Hi
I am trying to call smfForceRecalculation from my own VBA code to ensure my spreadsheet really updates on request
However when I try to reference the addin (VBA Editor - Tools - Reference) despite selecting the .xla file nothing happens..and hence my code does not work
Do you know what I am missing ?
Thanks and regards
Cyril
P-S : awesome addin...and support !
I am trying to call smfForceRecalculati
However when I try to reference the addin (VBA Editor - Tools - Reference) despite selecting the .xla file nothing happens..and hence my code does not work
Do you know what I am missing ?
Thanks and regards
Cyril
P-S : awesome addin...and support !
Tue Dec 3, 2013 1:12 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sounds like it should work. This workbook in the FILES area has an example:
RCHGetYahooQuotes-Example-Timed-Update.xls
When you say you are selecting the .xla file, are you doing it from the
list of available references, or using the "Browse..." button?
On Tue, Dec 3, 2013 at 12:19 AM, <cyrillm@yahoo.com> wrote:
>
> I am trying to call smfForceRecalculation from my own VBA code to ensure
> my spreadsheet really updates on request
> However when I try to reference the addin (VBA Editor - Tools -
> Reference) despite selecting the .xla file nothing happens..and hence my
> code does not work
> Do you know what I am missing ?
>
> Thanks and regards
> Cyril
> P-S : awesome addin...and support !
>
>
RCHGetYahooQuotes-
When you say you are selecting the .xla file, are you doing it from the
list of available references, or using the "Browse.
On Tue, Dec 3, 2013 at 12:19 AM, <cyrillm@yahoo.
>
> I am trying to call smfForceRecalculati
> my spreadsheet really updates on request
> However when I try to reference the addin (VBA Editor - Tools -
> Reference) despite selecting the .xla file nothing happens..and hence my
> code does not work
> Do you know what I am missing ?
>
> Thanks and regards
> Cyril
> P-S : awesome addin...and support !
>
>
Tue Dec 3, 2013 6:00 pm (PST) . Posted by:
"Cyril Levy-Marchal" CyrilLM
could not get it to work, so I took the file you refer to below, and
rebuild my sheet on it (the reference was showing in this file, and I
could not get to appear on mine)
Works fine now
Never had this problem with XL before though
Thanks for your help
Cyril
On 03/12/2013 17:11, Randy Harmelink wrote:
> Sounds like it should work. This workbook in the FILES area has an
> example:
>
> RCHGetYahooQuotes-Example-Timed-Update.xls
>
> When you say you are selecting the .xla file, are you doing it from
> the list of available references, or using the "Browse..." button?
>
> On Tue, Dec 3, 2013 at 12:19 AM, <cyrillm@yahoo.com
> <mailto:cyrillm@yahoo.com>> wrote:
>
>
> I am trying to call smfForceRecalculation from my own VBA code to
> ensure my spreadsheet really updates on request
> However when I try to reference the addin (VBA Editor - Tools -
> Reference) despite selecting the .xla file nothing happens..and
> hence my code does not work
> Do you know what I am missing ?
>
> Thanks and regards
> Cyril
> P-S : awesome addin...and support !
>
>
>
rebuild my sheet on it (the reference was showing in this file, and I
could not get to appear on mine)
Works fine now
Never had this problem with XL before though
Thanks for your help
Cyril
On 03/12/2013 17:11, Randy Harmelink wrote:
> Sounds like it should work. This workbook in the FILES area has an
> example:
>
> RCHGetYahooQuotes-
>
> When you say you are selecting the .xla file, are you doing it from
> the list of available references, or using the "Browse.
>
> On Tue, Dec 3, 2013 at 12:19 AM, <cyrillm@yahoo.
> <mailto:cyrillm@yahoo.
>
>
> I am trying to call smfForceRecalculati
> ensure my spreadsheet really updates on request
> However when I try to reference the addin (VBA Editor - Tools -
> Reference) despite selecting the .xla file nothing happens..and
> hence my code does not work
> Do you know what I am missing ?
>
> Thanks and regards
> Cyril
> P-S : awesome addin...and support !
>
>
>
Tue Dec 3, 2013 2:50 am (PST) . Posted by:
"cyrillm@yahoo.com" CyrilLM
Browse...
It does not appear in the list of available references... Even after browsing and selecting the xla file
Sent from my HTC
----- Reply message -----
From: "Randy Harmelink" <rharmelink@gmail.com>
To: <smf_addin@yahoogroups.com>
Subject: [smf_addin] Referencing the RCH addin
Date: Tue, Dec 3, 2013 17:11
Sounds like it should work. This workbook in the FILES area has an example:
RCHGetYahooQuotes-Example-Timed-Update.xls
When you say you are selecting the .xla file, are you doing it from the list of available references, or using the "Browse..." button?
On Tue, Dec 3, 2013 at 12:19 AM, <cyrillm@yahoo.com> wrote:
I am trying to call smfForceRecalculation from my own VBA code to ensure my spreadsheet really updates on request
However when I try to reference the addin (VBA Editor - Tools - Reference) despite selecting the .xla file nothing happens..and hence my code does not work
Do you know what I am missing ?
Thanks and regards
Cyril
P-S : awesome addin...and support !
It does not appear in the list of available references..
Sent from my HTC
----- Reply message -----
From: "Randy Harmelink" <rharmelink@gmail.
To: <smf_addin@yahoogrou
Subject: [smf_addin] Referencing the RCH addin
Date: Tue, Dec 3, 2013 17:11
Sounds like it should work. This workbook in the FILES area has an example:
RCHGetYahooQuotes-
When you say you are selecting the .xla file, are you doing it from the list of available references, or using the "Browse.
On Tue, Dec 3, 2013 at 12:19 AM, <cyrillm@yahoo.
I am trying to call smfForceRecalcu
However when I try to reference the addin (VBA Editor - Tools - Reference) despite selecting the .xla file nothing happens..and hence my code does not work
Do you know what I am missing ?
Thanks and regards
Cyril
P-S : awesome addin...and support !
Tue Dec 3, 2013 4:58 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. I've never done it that way. If you have the add-in installed, it
should show up on the list of available references...
On Tue, Dec 3, 2013 at 3:50 AM, cyrillm@yahoo.com <cyrillm@yahoo.com> wrote:
> Browse...
> It does not appear in the list of available references... Even after
> browsing and selecting the xla file
>
should show up on the list of available references..
On Tue, Dec 3, 2013 at 3:50 AM, cyrillm@yahoo.
> Browse...
> It does not appear in the list of available references..
> browsing and selecting the xla file
>
Tue Dec 3, 2013 5:48 pm (PST) . Posted by:
"Cyril Levy-Marchal" CyrilLM
may I just ask, what name should i appear under in the reference list ?
On 03/12/2013 20:58, Randy Harmelink wrote:
> Hmmm. I've never done it that way. If you have the add-in installed,
> it should show up on the list of available references...
>
> On Tue, Dec 3, 2013 at 3:50 AM, cyrillm@yahoo.com
> <mailto:cyrillm@yahoo.com> <cyrillm@yahoo.com
> <mailto:cyrillm@yahoo.com>> wrote:
>
> Browse...
> It does not appear in the list of available references... Even
> after browsing and selecting the xla file
>
>
>
On 03/12/2013 20:58, Randy Harmelink wrote:
> Hmmm. I've never done it that way. If you have the add-in installed,
> it should show up on the list of available references..
>
> On Tue, Dec 3, 2013 at 3:50 AM, cyrillm@yahoo.
> <mailto:cyrillm@yahoo.
> <mailto:cyrillm@yahoo.
>
> Browse...
> It does not appear in the list of available references..
> after browsing and selecting the xla file
>
>
>
Tue Dec 3, 2013 8:19 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It should be:
RCH_Stock_Market_Functions
On Tue, Dec 3, 2013 at 6:48 PM, Cyril Levy-Marchal <cyrillm@yahoo.com>wrote:
>
> may I just ask, what name should i appear under in the reference list ?
>
>
RCH_Stock_Market_
On Tue, Dec 3, 2013 at 6:48 PM, Cyril Levy-Marchal <cyrillm@yahoo.
>
> may I just ask, what name should i appear under in the reference list ?
>
>
Tue Dec 3, 2013 11:47 pm (PST) . Posted by:
lawrence.leesh
Hi Randy
How come this formula does not work on another url, say http://www.marketwatch.com/investing/Stock/3IN/analystestimates?countrycode=UK http://www.marketwatch.com/investing/Stock/3IN/analystestimates?countrycode=UK
thanks
LL
---In smf_addin@yahoogroups.com, <lawrence.leesh@...> wrote:
Thanks so much.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
Try:
=smfConvertData(smfstrExtr(smfGetTagContent("http://www.marketwatch.com/investing/Stock/1/analystestimates?countrycode=HK http://www.marketwatch.com/investing/Stock/1/analystestimates?countrycode=HK","p",1,">Previous Close"),"/span>","~"))
On Tue, Nov 5, 2013 at 1:00 AM, <lawrence.leesh@... mailto:lawrence.leesh@...> wrote:
Could you pls help me with the formula for Previous close from this page?
http://www.marketwatch.com/investing/Stock/1/analystestimates?countrycode=HK http://www.marketwatch.com/investing/Stock/1/analystestimates?countrycode=HK
How come this formula does not work on another url, say http://www.marketwa
thanks
LL
---In smf_addin@yahoogrou
Thanks so much.
---In smf_addin@yahoogrou
Try:
=smfConvertData(
On Tue, Nov 5, 2013 at 1:00 AM, <lawrence.
Could you pls help me with the formula for Previous close from this page?
http://www.marketwa
Tue Dec 3, 2013 11:57 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The web page is coded differently because of the currency. For example:
=smfGetTagContent("
http://www.marketwatch.com/investing/Stock/1/analystestimates?countrycode=HK","p",1,">Previous
Close")
=smfGetTagContent("
http://www.marketwatch.com/investing/Stock/3IN/analystestimates?countrycode=UK","p",1,">Previous
Close")
On Wed, Dec 4, 2013 at 12:47 AM, <lawrence.leesh@yahoo.com> wrote:
> How come this formula does not work on another url, say
> http://www.marketwatch.com/investing/Stock/3IN/analystestimates?countrycode=UK
>
>
=smfGetTagContent(
http://www.marketwa
Close")
=smfGetTagContent(
http://www.marketwa
Close")
On Wed, Dec 4, 2013 at 12:47 AM, <lawrence.leesh@
> How come this formula does not work on another url, say
> http://www.marketwa
>
>
Wed Dec 4, 2013 12:20 am (PST) . Posted by:
lawrence.leesh
Hi Randy
Is there a formula like the one you gave me for the HK stock that will return a clean number for the UK stock (without the <span class="currency">p</span>)?
thanks
LL
Is there a formula like the one you gave me for the HK stock that will return a clean number for the UK stock (without the <span class="
thanks
LL
Wed Dec 4, 2013 12:27 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfConvertData(smfstrExtr(smfGetTagContent("
http://www.marketwatch.com/investing/Stock/3IN/analystestimates?countrycode=UK","p",1,">Previous
Close"),"~","<"))
On Wed, Dec 4, 2013 at 1:20 AM, <lawrence.leesh@yahoo.com> wrote:
>
> Is there a formula like the one you gave me for the HK stock that will
> return a clean number for the UK stock (without the <span
> class="currency">p</span>)?
>
=smfConvertData(
http://www.marketwa
Close")
On Wed, Dec 4, 2013 at 1:20 AM, <lawrence.leesh@
>
> Is there a formula like the one you gave me for the HK stock that will
> return a clean number for the UK stock (without the <span
> class="
>
Wed Dec 4, 2013 12:31 am (PST) . Posted by:
lawrence.leesh
Thanks Randy.
Tidak ada komentar:
Posting Komentar