12 Messages
Digest #3675
4b
Re: morningstar style market cap into smfUpdateDownloadTable macro 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?
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?
>
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
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
>
>
>
>
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
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.
>
>
>
>
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@
>
> Hi Randy – I am struggling to use it for options. I've been trying to use
> this one "=smfGetOptionQuotes
> [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.
>
>
>
>
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@
>
> Hi Randy – I am struggling to use it for options. I've been trying to use
> this one "=smfGetOptionQuotes
> [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.
>
=smfGetOptionQuotes
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\"":\""","\")
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.
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,"
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 smfUpdateDownloadTa
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\"":\""","\")
>
> 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).
>
>
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,"
>
> 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 smfUpdateDownloadTa
> 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:
Posting Komentar