5 Messages
Digest #3468
Messages
Fri Jul 24, 2015 6:29 am (PDT) . Posted by:
wongkayau
thanks for the suggestion. i tried but i found "quit excel does not work. only the small macro can clear old data to store new data. Sub ForceCal()
Application.Run "smfForceRecalculation" End Sub
thanks.
Application.
thanks.
Fri Jul 24, 2015 7:12 am (PDT) . Posted by:
"Robin Saunders" robin301249
Randy
Apologies for the delay in getting back to you but I have been away.
I have now applied the RCHGetYahooQuotes() function to my general spreadsheet and identified those Tickers not returning a Current Price – interestingly they all return a Company Name.
I attach a sample spreadsheet showing the problems….
I have noted that if I look at the Current Price detail on the Yahoo Finance page that too is Zero.
For example - https://uk.finance.yahoo.com/q/bc?s=GB0006664683.L for Jupiter European
Please note – all the errors are for FUNDS not EQUITIES
Is there an alternative field I could use in the Yahoo Finance page please?
The data available in the UK is pretty good.
I also use the following sites – I show examples of the Jupiter European pages for your information
- http://funds.investorschronicle.co.uk/uk/Tearsheet/Summary?s=GB0006664683:GBX The Financial Times site
- http://www.morningstar.co.uk/uk/funds/snapshot/snapshot.aspx?id=F0GBR04C3Z Morningstar UK
- http://www.hl.co.uk/funds/fund-discounts,-prices--and--factsheets/search-results/j/jupiter-european-class-i-income This is the site I used to manage my portfolio (excellent by the way!)
Any advice would be most appreciated.
Robin
Robin Saunders, t : 01252 836745 m : 07831 834989 e : robin@enexus.co.uk
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: 22 July 2015 01:31
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Help for a new user in the United Kingdom
Can you give me some examples of ticker symbols that aren't populated? The three examples you gave me earlier all had values.
The element numbers aren't generally for volatile items like a current price.
There are other functions you can use. However, if you have a lot of ticker symbols, data retrieval may be slow. The advantage of the RCHGetYahooQuotes() function is that you can get multiple data items on up to 200 ticker symbols with a single Internet access.
The other functions I use quite often are RCHGetTableCell() and smfGetTagContent(). But when you resort to such web page scraping functions, you generally need at least one Internet access per ticker symbol. Even at a quick response time of a half-second per web page, you can see how quickly elapsed time can climb with hundreds of ticker symbols. And, even on a fast web site, you'll occasionally run into a 5 to 15 second delay on a single web page.
The other issue here is finding a good source of the data. I don't use UK data, so my advice on finding a good data source for them will be next to useless. :(
On Tue, Jul 21, 2015 at 4:46 PM, robin301249@yahoo.co.uk [smf_addin] <smf_addin@yahoogroups.com> wrote:
Right, I am making progress and think I am understanding the basics, however, as in your example there are some data elements ((Latest Price -l1 above) that are not populated in Yahoo Finance.
Are there any other sources I can use please? I note that this field is 'obsolete' in MSN and I cannot see an equivalent field in the RCHGetElementNumber-Element-Definitions file provided in the download.
Any help would be appreciated
Apologies for the delay in getting back to you but I have been away.
I have now applied the RCHGetYahooQuotes() function to my general spreadsheet and identified those Tickers not returning a Current Price – interestingly they all return a Company Name.
I attach a sample spreadsheet showing the problems….
I have noted that if I look at the Current Price detail on the Yahoo Finance page that too is Zero.
For example - https://uk.finance.yahoo.com/q/bc?s=GB0006664683.L for Jupiter European
Please note – all the errors are for FUNDS not EQUITIES
Is there an alternative field I could use in the Yahoo Finance page please?
The data available in the UK is pretty good.
I also use the following sites – I show examples of the Jupiter European pages for your information
- http://funds.investorschronicle.co.uk/uk/Tearsheet/Summary?s=GB0006664683:GBX The Financial Times site
- http://www.morningstar.co.uk/uk/funds/snapshot/snapshot.aspx?id=F0GBR04C3Z Morningstar UK
- http://www.hl.co.uk/funds/fund-discounts,-prices--and--factsheets/search-results/j/jupiter-european-class-i-income This is the site I used to manage my portfolio (excellent by the way!)
Any advice would be most appreciated.
Robin
Robin Saunders, t : 01252 836745 m : 07831 834989 e : robin@enexus.co.uk
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: 22 July 2015 01:31
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Help for a new user in the United Kingdom
Can you give me some examples of ticker symbols that aren't populated? The three examples you gave me earlier all had values.
The element numbers aren't generally for volatile items like a current price.
There are other functions you can use. However, if you have a lot of ticker symbols, data retrieval may be slow. The advantage of the RCHGetYahooQuotes() function is that you can get multiple data items on up to 200 ticker symbols with a single Internet access.
The other functions I use quite often are RCHGetTableCell() and smfGetTagContent(). But when you resort to such web page scraping functions, you generally need at least one Internet access per ticker symbol. Even at a quick response time of a half-second per web page, you can see how quickly elapsed time can climb with hundreds of ticker symbols. And, even on a fast web site, you'll occasionally run into a 5 to 15 second delay on a single web page.
The other issue here is finding a good source of the data. I don't use UK data, so my advice on finding a good data source for them will be next to useless. :(
On Tue, Jul 21, 2015 at 4:46 PM, robin301249@yahoo.co.uk [smf_addin] <smf_addin@yahoogroups.com> wrote:
Right, I am making progress and think I am understanding the basics, however, as in your example there are some data elements ((Latest Price -l1 above) that are not populated in Yahoo Finance.
Are there any other sources I can use please? I note that this field is 'obsolete&#
Any help would be appreciated
Attachment(s) from Robin Saunders
1 of 1 File(s)
Fri Jul 24, 2015 5:48 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It looks like Yahoo simply isn't carrying (or updating) data on those
funds. You could pick up the latest NAV from one of your cited web pages.
For example, something like:
=RCHGetTableCell("
http://funds.investorschronicle.co.uk/uk/Tearsheet/Summary?s=GB0006664683:GBX
",
1,"View PDF","<tr")
On Fri, Jul 24, 2015 at 7:12 AM, 'Robin Saunders' robin301249@... wrote:
>
> I have now applied the RCHGetYahooQuotes() function to my general
> spreadsheet and identified those Tickers not returning a Current Price –
> interestingly they all return a Company Name.
>
> I attach a sample spreadsheet showing the problems….
>
>
>
> I have noted that if I look at the Current Price detail on the Yahoo
> Finance page that too is Zero.
>
> For example - https://uk.finance.yahoo.com/q/bc?s=GB0006664683.L for
> Jupiter European
>
> Please note – all the errors are for FUNDS not EQUITIES
>
> Is there an alternative field I could use in the Yahoo Finance page please?
>
>
>
> The data available in the UK is pretty good.
>
> I also use the following sites – I show examples of the Jupiter European
> pages for your information
>
> -
> http://funds.investorschronicle.co.uk/uk/Tearsheet/Summary?s=GB0006664683:GBX
> The Financial Times site
>
> -
> http://www.morningstar.co.uk/uk/funds/snapshot/snapshot.aspx?id=F0GBR04C3Z
> Morningstar UK
>
> -
> http://www.hl.co.uk/funds/fund-discounts,-prices--and--factsheets/search-results/j/jupiter-european-class-i-income
> This is the site I used to manage my portfolio (excellent by the way!)
>
>
>
> Any advice would be most appreciated.
>
>
>
funds. You could pick up the latest NAV from one of your cited web pages.
For example, something like:
=RCHGetTableCell("
http://funds.investorschronicle.co.uk/uk/Tearsheet/Summary?s=GB0006664683:GBX
",
1,"View PDF","<tr")
On Fri, Jul 24, 2015 at 7:12 AM, 'Robin Saunders' robin301249@... wrote:
>
> I have now applied the RCHGetYahooQuotes() function to my general
> spreadsheet and identified those Tickers not returning a Current Price –
> interestingly they all return a Company Name.
>
> I attach a sample spreadsheet showing the problems….
>
>
>
> I have noted that if I look at the Current Price detail on the Yahoo
> Finance page that too is Zero.
>
> For example - https://uk.finance.yahoo.com/q/bc?s=GB0006664683.L for
> Jupiter European
>
> Please note – all the errors are for FUNDS not EQUITIES
>
> Is there an alternative field I could use in the Yahoo Finance page please?
>
>
>
> The data available in the UK is pretty good.
>
> I also use the following sites – I show examples of the Jupiter European
> pages for your information
>
> -
> http://funds.investorschronicle.co.uk/uk/Tearsheet/Summary?s=GB0006664683:GBX
> The Financial Times site
>
> -
> http://www.morningstar.co.uk/uk/funds/snapshot/snapshot.aspx?id=F0GBR04C3Z
> Morningstar UK
>
> -
> http://www.hl.co.uk/funds/fund-discounts,-prices--and--factsheets/search-results/j/jupiter-european-class-i-income
> This is the site I used to manage my portfolio (excellent by the way!)
>
>
>
> Any advice would be most appreciated.
>
>
>
Fri Jul 24, 2015 10:46 pm (PDT) . Posted by:
c92801
Hi randy,
I am new here. I was not able to find smf add in.
Could you send me link thru email please?
CP
I am new here. I was not able to find smf add in.
Could you send me link thru email please?
CP
Sat Jul 25, 2015 12:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
From the description of the group:
For the Add-in, Documentation, Templates, Tips and FAQs, visit
http://ogres-crypt.com/SMF
That's also in the "README" files in the FILES area of the Yahoo group. It
should have been in the "Welcome to the group" message.
On Fri, Jul 24, 2015 at 10:23 PM, c92801@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I am new here. I was not able to find smf add in.
>
> Could you send me link thru email please?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit
http://ogres-crypt.com/SMF
That's also in the "README" files in the FILES area of the Yahoo group. It
should have been in the "Welcome to the group" message.
On Fri, Jul 24, 2015 at 10:23 PM, c92801@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I am new here. I was not able to find smf add in.
>
> Could you send me link thru email please?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar