6 Messages
Digest #3049
Messages
Mon Apr 21, 2014 8:28 am (PDT) . Posted by:
jpsartrean
Hello,
Is there any way to time delay the add-in between queries? I saw some discussion of a 'Time Function' in the message archives, but no explanation/documentation on how to use it... (?)
There is a public website that I had used the addin to pull data from, but now when I run it I get an error message on every other query I request... I think the site changed its servers and now can't return successive queries quickly enough... but if there was more of a time delay between each query, I'm convinced it would still work (if I use the force recalculation and re-run it on the error queries, it works -- but again, only for every other query or so...)
I suppose I could input 'bogus'/'placebo' queries in between the requests that I really want, but that seems tedious/waste of time... any thoughts?
Is there any way to time delay the add-in between queries? I saw some discussion of a 'Time Function' in the message archives, but no explanation/
There is a public website that I had used the addin to pull data from, but now when I run it I get an error message on every other query I request... I think the site changed its servers and now can't return successive queries quickly enough... but if there was more of a time delay between each query, I'm convinced it would still work (if I use the force recalculation and re-run it on the error queries, it works -- but again, only for every other query or so...)
I suppose I could input 'bogus&#
Mon Apr 21, 2014 8:38 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The only way I know to do what you want would be to code your own VBA. But
it doesn't sound like a trivial task. I think you'd need to use VBA to
retrieve each data item instead of using formulas in your worksheet.
On Mon, Apr 21, 2014 at 8:28 AM, <jpsartrean@yahoo.com> wrote:
>
> Is there any way to time delay the add-in between queries? I saw some
> discussion of a 'Time Function' in the message archives, but no
> explanation/documentation on how to use it... (?)
>
> There is a public website that I had used the addin to pull data from, but
> now when I run it I get an error message on every other query I request...
> I think the site changed its servers and now can't return successive
> queries quickly enough... but if there was more of a time delay between
> each query, I'm convinced it would still work (if I use the force
> recalculation and re-run it on the error queries, it works -- but again,
> only for every other query or so...)
>
> I suppose I could input 'bogus'/'placebo' queries in between the requests
> that I really want, but that seems tedious/waste of time... any thoughts?
>
it doesn't sound like a trivial task. I think you'd need to use VBA to
retrieve each data item instead of using formulas in your worksheet.
On Mon, Apr 21, 2014 at 8:28 AM, <jpsartrean@yahoo.com> wrote:
>
> Is there any way to time delay the add-in between queries? I saw some
> discussion of a 'Time Function' in the message archives, but no
> explanation/
>
> There is a public website that I had used the addin to pull data from, but
> now when I run it I get an error message on every other query I request...
> I think the site changed its servers and now can't return successive
> queries quickly enough... but if there was more of a time delay between
> each query, I'm convinced it would still work (if I use the force
> recalculation and re-run it on the error queries, it works -- but again,
> only for every other query or so...)
>
> I suppose I could input 'bogus&#
> that I really want, but that seems tedious/waste of time... any thoughts?
>
Mon Apr 21, 2014 12:25 pm (PDT) . Posted by:
jpsartrean
Thanks for the quick response -
I certainly agree VBA tinkering is required --was just wondering if you/others had already tried it...
This command works:
Application.Wait(Now + TimeValue("0:00:05")) Where the time value is H:MM:SS.
Just not sure how/where to use it to get 'smfGetTagContent' (what I've used previously pull the data) to delay when using as a formula for multiple rows...
I certainly agree VBA tinkering is required --was just wondering if you/others had already tried it...
This command works:
Application.
Just not sure how/where to use it to get 'smfGetTagConte
Mon Apr 21, 2014 1:18 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You wouldn't be able to use it to control the individual formulas, unless
you invoked each within VBA and then placed the values in the cell using
VBA.
On Mon, Apr 21, 2014 at 12:25 PM, <jpsartrean@yahoo.com> wrote:
>
> Thanks for the quick response -
>
> I certainly agree VBA tinkering is required --was just wondering if
> you/others had already tried it...
>
> This command works:
> Application.Wait(Now + TimeValue("0:00:05"))
>
> Where the time value is H:MM:SS.
>
> Just not sure how/where to use it to get 'smfGetTagContent' (what I've
> used previously pull the data) to delay when using as a formula for
> multiple rows...
>
you invoked each within VBA and then placed the values in the cell using
VBA.
On Mon, Apr 21, 2014 at 12:25 PM, <jpsartrean@yahoo.com> wrote:
>
> Thanks for the quick response -
>
> I certainly agree VBA tinkering is required --was just wondering if
> you/others had already tried it...
>
> This command works:
> Application.
>
> Where the time value is H:MM:SS.
>
> Just not sure how/where to use it to get 'smfGetTagConte
> used previously pull the data) to delay when using as a formula for
> multiple rows...
>
Mon Apr 21, 2014 1:20 pm (PDT) . Posted by:
stephen.ronson
The percentage of emerging markets within Vanguard Total International Index Fund Admiral Shares is available on this page:
http://portfolios.morningstar.com/fund/summary?t=VTIAX®ion=usa&culture=en-US http://portfolios.morningstar.com/fund/summary?t=VTIAX®ion=usa&culture=en-US
at the bottom of the page as "14%"
and more accurately on this page:
https://personal.vanguard.com/us/funds/snapshot?FundId=0569&FundIntExt=INT https://personal.vanguard.com/us/funds/snapshot?FundId=0569&FundIntExt=INT
in the middle of the page as "17.6%"
I was able to use the SMF add-in to get the percentages on the morningstar page within that column down to the 10th number but not enough to get the 14% number (the 12th number). Any advice on how to get this number or another source to get it?
thanks
http://portfolios.morningstar.com/fund/summary?t=VTIAX®ion=usa&culture=en-US http://portfolios.morningstar.com/fund/summary?t=VTIAX®ion=usa&culture=en-US
at the bottom of the page as "14%"
and more accurately on this page:
https://personal.vanguard.com/us/funds/snapshot?FundId=0569&FundIntExt=INT https://personal.vanguard.com/us/funds/snapshot?FundId=0569&FundIntExt=INT
in the middle of the page as "17.6%"
I was able to use the SMF add-in to get the percentages on the morningstar page within that column down to the 10th number but not enough to get the 14% number (the 12th number). Any advice on how to get this number or another source to get it?
thanks
Mon Apr 21, 2014 1:37 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
For MorningStar, try:
=RCHGetTableCell("http://portfolios.morningstar.com/fund/summary?t=VTIAX",1,">%
Emerging Markets")
For Vanguard, it's more complicated, because the data isn't actually on
that web page, but on a supporting web page. Try:
=smfConvertData(smfstrExtr(smfstrExtr(smfGetTagContent("
https://personal.vanguard.com/us/FundsRegionAllocationXml?FundId=0569&FundIntExt=INT","chartdata"),"Emerging
Markets""",">"),"""",""""))
On Mon, Apr 21, 2014 at 1:16 PM, <stephen.ronson@yahoo.com> wrote:
>
> The percentage of emerging markets within Vanguard Total International
> Index Fund Admiral Shares is available on this page:
>
>
> http://portfolios.morningstar.com/fund/summary?t=VTIAX®ion=usa&culture=en-US
>
> at the bottom of the page as "14%"
>
> and more accurately on this page:
>
> https://personal.vanguard.com/us/funds/snapshot?FundId=0569&FundIntExt=INT
>
> in the middle of the page as "17.6%"
>
> I was able to use the SMF add-in to get the percentages on the morningstar
> page within that column down to the 10th number but not enough to get the
> 14% number (the 12th number). Any advice on how to get this number or
> another source to get it?
>
=RCHGetTableCell("http://portfolios.morningstar.com/fund/summary?t=VTIAX",1,">%
Emerging Markets")
For Vanguard, it's more complicated, because the data isn't actually on
that web page, but on a supporting web page. Try:
=smfConvertData(smfstrExtr(smfstrExtr(smfGetTagContent("
https://personal.vanguard.com/us/FundsRegionAllocationXml?FundId=0569&FundIntExt=INT","chartdata"),"Emerging
Markets""",">"),"""",""""))
On Mon, Apr 21, 2014 at 1:16 PM, <stephen.ronson@yahoo.com> wrote:
>
> The percentage of emerging markets within Vanguard Total International
> Index Fund Admiral Shares is available on this page:
>
>
> http://portfolios.morningstar.com/fund/summary?t=VTIAX®ion=usa&culture=en-US
>
> at the bottom of the page as "14%"
>
> and more accurately on this page:
>
> https://personal.vanguard.com/us/funds/snapshot?FundId=0569&FundIntExt=INT
>
> in the middle of the page as "17.6%"
>
> I was able to use the SMF add-in to get the percentages on the morningstar
> page within that column down to the 10th number but not enough to get the
> 14% number (the 12th number). Any advice on how to get this number or
> another source to get it?
>
Tidak ada komentar:
Posting Komentar