10 Messages
Digest #4134
Messages
Tue Aug 29, 2017 9:06 pm (PDT) . Posted by:
joelfp2000
Randy,
Thanks! It works great.
Now, how do I reference a cell in the formula. The old t=&a2". doesn't work in place of the actual ETF symbol.
Thanks...
Joel
Thanks! It works great.
Now, how do I reference a cell in the formula. The old t=&a2". doesn't work in place of the actual ETF symbol.
Thanks...
Joel
Tue Aug 29, 2017 11:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The &A2 goes on the other side of the double-quote, because you want to
concatenate the cell contents to the string:
=smfConvertData(smfStrExtr(SUBSTITUTE(smfGetTagContent("
http://srt.morningstar.com/oprn/etf/c-feesandexpense.html?t="&A2,"td",1,"Net
Expense Ratio: Category Average"),"\t",""),"\n","%"))
You're concatenating two strings:
"http://srt.morningstar.com/oprn/etf/c-feesandexpense.html?t="
A2
On Tue, Aug 29, 2017 at 9:06 PM, joel.andrews@
...
wrote:
>
> Now, how do I reference a cell in the formula. The old t=&a2". doesn't
> work in place of the actual ETF symbol.
>
>
>
concatenate the cell contents to the string:
=smfConvertData(smfStrExtr(SUBSTITUTE(smfGetTagContent("
http://srt.morningstar.com/oprn/etf/c-feesandexpense.html?t="&A2,"td",1,"Net
Expense Ratio: Category Average"),"\t",""),"\n","%"))
You're concatenating two strings:
"http://srt.morningstar.com/oprn/etf/c-feesandexpense.html?t="
A2
On Tue, Aug 29, 2017 at 9:06 PM, joel.andrews@
...
wrote:
>
> Now, how do I reference a cell in the formula. The old t=&a2". doesn't
> work in place of the actual ETF symbol.
>
>
>
Wed Aug 30, 2017 6:16 am (PDT) . Posted by:
mjblauer
Randy, another thought is it possible to create a recalculation macro that recalculates
only the cell the current field and not the entire workbook??? The entire workbook takes
5-10 minutes to recalculate and then it randomly skips over fields that were populated previously.
thanks
only the cell the current field and not the entire workbook??? The entire workbook takes
5-10 minutes to recalculate and then it randomly skips over fields that were populated previously.
thanks
Wed Aug 30, 2017 10:39 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Nope, sorry. The removal of saved web pages, to force a new retrieval of
web pages, is an all or nothing deal.
In select cases, it may be possible to change the formulas in a way that
would get a DIFFERENT web page, but that would require knowledge of how the
particular data item is being retrieved. For example, if
RCHGetElementNumber() is being used, changing the ticker symbol from "MMM"
to "MMM&1" might force the element to use a different web page.
On Wed, Aug 30, 2017 at 6:16 AM, mblauer@
...
wrote:
>
> another thought is it possible to create a recalculation macro that
> recalculates
> only the cell the current field and not the entire workbook??? The entire
> workbook takes
> 5-10 minutes to recalculate and then it randomly skips over fields that
> were populated previously.
>
>
web pages, is an all or nothing deal.
In select cases, it may be possible to change the formulas in a way that
would get a DIFFERENT web page, but that would require knowledge of how the
particular data item is being retrieved. For example, if
RCHGetElementNumber
to "MMM&1" might force the element to use a different web page.
On Wed, Aug 30, 2017 at 6:16 AM, mblauer@
...
wrote:
>
> another thought is it possible to create a recalculation macro that
> recalculates
> only the cell the current field and not the entire workbook??? The entire
> workbook takes
> 5-10 minutes to recalculate and then it randomly skips over fields that
> were populated previously.
>
>
Wed Aug 30, 2017 7:03 am (PDT) . Posted by:
navman92
I've been getting an error with element 13863 (Company Name) for about a month using RCHGetElementNumber (xx,13863). It is not a big problem but I wonder what happened. By the way, thanks to Randy for providing us with these wonderful tools for extracting market data from the internet. I prefer using my spreadsheet to going to my Merrill Lynch and E-trade accounts online.
RCE
RCE
Wed Aug 30, 2017 7:12 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That element is working fine here. You may need to update your Yahoo
element definitions.
2017-04-26 smfGetOptionQuotes
smfGetYahooOptionQuotes
RCHGetElementNumber Updated all remaining Yahoo usage of protocol "http://"
to "https://", both in element definitions and in the XLA file.
On Wed, Aug 30, 2017 at 5:32 AM, navman92@
...
wrote:
>
> I've been getting an error with element 13863 (Company Name) for about a
> month using RCHGetElementNumber (xx,13863). It is not a big problem but I
> wonder what happened.
> By the way, thanks to Randy for providing us with these wonderful tools
> for extracting market data from the internet. I prefer using my
> spreadsheet to going to my Merrill Lynch and E-trade accounts online.
>
>
>
element definitions.
2017-04-26 smfGetOptionQuotes
smfGetYahooOptionQu
RCHGetElementNumber Updated all remaining Yahoo usage of protocol "http:/
to "https:
On Wed, Aug 30, 2017 at 5:32 AM, navman92@
...
wrote:
>
> I've been getting an error with element 13863 (Company Name) for about a
> month using RCHGetElementNumber (xx,13863). It is not a big problem but I
> wonder what happened.
> By the way, thanks to Randy for providing us with these wonderful tools
> for extracting market data from the internet. I prefer using my
> spreadsheet to going to my Merrill Lynch and E-trade accounts online.
>
>
>
Wed Aug 30, 2017 7:07 am (PDT) . Posted by:
danzig_36526
Yes, it does appear to be a Reuters problem. Been like this for about a week now...hopefully they'll resolve soon.
Thanks.
Thanks.
Wed Aug 30, 2017 9:14 am (PDT) . Posted by:
danzig_36526
Got this response from Reuters:
Hello,
Thank you for reaching out. Please be advised that we are aware of this issue and our development team are already investigating to resolve this as soon as possible.
Thank you your patience.
Kind regards,
Reuters.com http://reuters.com/ Team
Hello,
Thank you for reaching out. Please be advised that we are aware of this issue and our development team are already investigating to resolve this as soon as possible.
Thank you your patience.
Kind regards,
Reuters.com http://reuters.com/ Team
Wed Aug 30, 2017 1:29 pm (PDT) . Posted by:
a.bereziuk
Thx for your quick answer.
Surprisingly, RCHGetWebData works! It returns:
>Frankfurt</a></td><td>93,60 -</td><td><span class="g">+0,25</span></td><td><span class="g">+0,27%</
RCHGetElementNumber("Version") delivers:
Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-in; Windows (32-bit) NT :.00; 16.0; ; ; 380)
... however I have Win10 x64.
But RCHGetTableCell and smfGetTagContent are still not working with Onvista.de (they return "Error").
But they both work fine with Finviz.com:
http://finviz.com/quote.ashx?t=RVT http://finviz.com/quote.ashx?t=RVT (in O54)
=RCHGetTableCell($O54;1;"Income") returns 271.90M
=smfGetTagContent(O54;"td";1;">Income";;;;1) returns 271.90M
smfForceRecalculation didn't help.
Surprisingly, RCHGetWebData works! It returns:
>Frankfurt</a></td><td>93,60 -</td><td><span class="g">+0,25</span></td><td><span class="g">+0,27%</
RCHGetElementNumber("Version") delivers:
Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-in; Windows (32-bit) NT :.00; 16.0; ; ; 380)
... however I have Win10 x64.
But RCHGetTableCell and smfGetTagContent are still not working with Onvista.de (they return "Error").
But they both work fine with Finviz.com:
http://finviz.com/quote.ashx?t=RVT http://finviz.com/quote.ashx?t=RVT (in O54)
=RCHGetTableCell(
=smfGetTagContent(
smfForceRecalculati
Wed Aug 30, 2017 4:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I can't understand why the RCHGetWebData() function would work, but not the
smfGetTagContent() function, based on what I see returned by
RCHGetWebData()?
Do you get anything with:
=smfGetTagContent("
https://www.onvista.de/anleihen/kurse.html?ISIN=GR0128010676
","td",1,">Frankfurt")
I'm thinking there is probably an issue with conversion of an amount, as
the add-in is written for USA regional settings?
On Wed, Aug 30, 2017 at 1:29 PM, a.bereziuk@
...
wrote:
>
> Thx for your quick answer.
> Surprisingly, RCHGetWebData works! It returns:
>
> >Frankfurt</a></td><td>93,60 -</td><td><span class="g">+0,25</span></td><td><span
> class="g">+0,27%</
>
> RCHGetElementNumber("Version") delivers:
> Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-in;
> Windows (32-bit) NT :.00; 16.0; ; ; 380)
> ... however I have Win10 x64.
>
> But RCHGetTableCell and smfGetTagContent are still not working with
> Onvista.de (they return "Error").
> But they both work fine with Finviz.com:
>
> http://finviz.com/quote.ashx?t=RVT (in O54)
> =RCHGetTableCell($O54;1;"Income") returns 271.90M
> =smfGetTagContent(O54;"td";1;">Income";;;;1) returns 271.90M
>
> smfForceRecalculation didn't help.
>
>
smfGetTagContent() function, based on what I see returned by
RCHGetWebData()?
Do you get anything with:
=smfGetTagContent("
https://www.onvista.de/anleihen/kurse.html?ISIN=GR0128010676
","td",1,">Frankfurt")
I'm thinking there is probably an issue with conversion of an amount, as
the add-in is written for USA regional settings?
On Wed, Aug 30, 2017 at 1:29 PM, a.bereziuk@
...
wrote:
>
> Thx for your quick answer.
> Surprisingly, RCHGetWebData works! It returns:
>
> >Frankfurt</a></td><td>93,60 -</td><td><span class="g">+0,25</span></td><td><span
> class="g">+0,27%</
>
> RCHGetElementNumber("Version") delivers:
> Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-in;
> Windows (32-bit) NT :.00; 16.0; ; ; 380)
> ... however I have Win10 x64.
>
> But RCHGetTableCell and smfGetTagContent are still not working with
> Onvista.de (they return "Error").
> But they both work fine with Finviz.com:
>
> http://finviz.com/quote.ashx?t=RVT (in O54)
> =RCHGetTableCell(
> =smfGetTagContent(
>
> smfForceRecalculati
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar