Sabtu, 25 Juli 2015

[smf_addin] Digest Number 3468[1 Attachment]

5 Messages

Digest #3468
1.1
2a
Re: Help for a new user in the United Kingdom by "Robin Saunders" robin301249
3a
SMF add in by c92801
3b
Re: SMF add in by "Randy Harmelink" rharmelink

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.

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&#39; in MSN and I cannot see an equivalent field in the RCHGetElementNumber-Element-Definitions file provided in the download.

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

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

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

Tidak ada komentar:

Poskan Komentar