Selasa, 12 April 2016

[smf_addin] Digest Number 3675

12 Messages

Digest #3675
1b
Re: Reuters 5 year financial data disappeared by "Randy Harmelink" rharmelink
2b
Re: Exchange Rate data by data by "Randy Harmelink" rharmelink
3a
Formula for Options by "Rodrigo Barreto" rdbarreto77
3b
Re: Formula for Options by "Randy Harmelink" rharmelink
3c
Re: Formula for Options by "Rodrigo D Barreto" rdbarreto77
3d
Re: Formula for Options by "Randy Harmelink" rharmelink

Messages

Mon Apr 11, 2016 2:20 am (PDT) . Posted by:

timdutoit

Randy thanks for the quick reply

Looks like morningstar has all the data I need.

What is the best spreadsheet to download that pulls it in?

Mon Apr 11, 2016 3:11 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Check out the "Tips and FAQs" web page on the web site. It has a link to an
item on MorningStar that documents how to retrieve their CSV files using
the add-in.

On Mon, Apr 11, 2016 at 2:20 AM, tdutoit@gmx.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Randy thanks for the quick reply
>
> Looks like morningstar has all the data I need.
>
> What is the best spreadsheet to download that pulls it in?
>

Mon Apr 11, 2016 8:14 am (PDT) . Posted by:

lawleesh

Hi Randy


Is there a RCHGetTableCell formula to get exchange rate data by a specific date from this page?


http://fx.sauder.ubc.ca/cgi/fxdata?b=SGD&c=USD http://fx.sauder.ubc.ca/cgi/fxdata?b=SGD&c=USD



thanks









Mon Apr 11, 2016 8:22 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

There's even a template for it in the Yahoo group FILES area:

https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/RCHGetTableCell/

On Mon, Apr 11, 2016 at 8:13 AM, lawrence.leesh@... wrote:

>
> Is there a RCHGetTableCell formula to get exchange rate data by a specific
> date from this page?
>
> http://fx.sauder.ubc.ca/cgi/fxdata?b=SGD&c=USD
>
>
>
>

Mon Apr 11, 2016 2:53 pm (PDT) . Posted by:

"Rodrigo Barreto" rdbarreto77

Hi Randy – I am struggling to use it for options. I've been trying to use this one "=smfGetOptionQuotes(tickerlist, datacodelist, [headers], [source])", but couldn't find a way to make it work for a single Brazilian option. Could you let me know how could I use it to retrieve the last quote for BBASD70 for instance?

BBAS option codes are linked to the stock code BBAS3. D is for April. This option last quote's today was 2.15.

Thanks in advance, Rodrigo Barreto

Mon Apr 11, 2016 4:08 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

None of those ticker symbols gets me to anything usable on Yahoo. I have no
idea which company you're trying to get option quotes for.

However, foreign options may not follow the same patterns I'm using for
US-company options...

On Mon, Apr 11, 2016 at 2:53 PM, Rodrigo Barreto rodrigodbarreto@... wrote:

>
> Hi Randy – I am struggling to use it for options. I've been trying to use
> this one "=smfGetOptionQuotes(tickerlist, datacodelist, [headers],
> [source])", but couldn't find a way to make it work for a single Brazilian
> option. Could you let me know how could I use it to retrieve the last quote
> for BBASD70 for instance?
>
>
>
> BBAS option codes are linked to the stock code BBAS3. D is for April. This
> option last quote's today was 2.15.
>
>
>
>

Mon Apr 11, 2016 4:36 pm (PDT) . Posted by:

"Rodrigo D Barreto" rdbarreto77

OK send me one example for instance for XOM, and will try here something else. Thanks.

Sent from my mobile device

-------- Original Message --------
From:"Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
Sent:Mon, 11 Apr 2016 20:08:32 -0300
To:smf_addin@yahoogroups.com
Subject:Re: [smf_addin] Formula for Options

None of those ticker symbols gets me to anything usable on Yahoo. I have no
idea which company you're trying to get option quotes for.

However, foreign options may not follow the same patterns I'm using for
US-company options...

On Mon, Apr 11, 2016 at 2:53 PM, Rodrigo Barreto rodrigodbarreto@... wrote:

>
> Hi Randy – I am struggling to use it for options. I've been trying to use
> this one "=smfGetOptionQuotes(tickerlist, datacodelist, [headers],
> [source])", but couldn't find a way to make it work for a single Brazilian
> option. Could you let me know how could I use it to retrieve the last quote
> for BBASD70 for instance?
>
>
>
> BBAS option codes are linked to the stock code BBAS3. D is for April. This
> option last quote's today was 2.15.
>
>
>
>

Mon Apr 11, 2016 4:57 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Something like this:

=smfGetOptionQuotes("XOM 4/15 2016 $85 Call","b")

On Mon, Apr 11, 2016 at 4:36 PM, Rodrigo D Barreto rodrigodbarreto@ wrote:

>
> OK send me one example for instance for XOM, and will try here something
> else. Thanks.
>

Mon Apr 11, 2016 9:37 pm (PDT) . Posted by:

aaronwtrammell

Forgive me if this is elsewhere, but a search didn't turn it up.


For an investment tracking spreadsheet, I want to see market cap distribution (i.e., morningstar) of mutual funds I have.
I found the related forum post from a couple of years ago (https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/14064) which has good info and the formulas there will work for me. Specifically, I have used this formula:
=smfStrExtr(RCHGetWebData("http://portfolios.morningstar.com/fund/summary?t="&C4,"Order\"":1",250),"Label\"":\""","&#92;")


I was able to change the $C4 term to a different cell reference to make the formula work for me.
I was wondering if there was a way to incorporate this into the smfUpdateDownloadTable macro? I tried just using the formula (without the equals) and received no result (no #value, or anything).


Thanks for the help.

Mon Apr 11, 2016 9:53 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You just need to get the ticker symbol in there by using the "~~~~~" string
instead of the $C4 reference. For example, try this column definition:

="=smfStrExtr(RCHGetWebData(""
http://portfolios.morningstar.com/fund/summary?t=~~~~~
"",""Order\"""":1"",250),""Label\"""":\"""""",""\"")"

On Mon, Apr 11, 2016 at 8:34 PM, aaronwtrammell@... wrote:

> Forgive me if this is elsewhere, but a search didn't turn it up.
>
> For an investment tracking spreadsheet, I want to see market cap
> distribution (i.e., morningstar) of mutual funds I have.
>
> I found the related forum post from a couple of years ago (
> https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/14064)
> which has good info and the formulas there will work for me. Specifically,
> I have used this formula:
>
> =smfStrExtr(RCHGetWebData("
> http://portfolios.morningstar.com/fund/summary?t=
> "&C4,"Order\"":1",250),"Label\"":\""","&#92;")
>
> I was able to change the $C4 term to a different cell reference to make
> the formula work for me.
>
> I was wondering if there was a way to incorporate this into
> the smfUpdateDownloadTable macro? I tried just using the formula (without
> the equals) and received no result (no #value, or anything).
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar