Kamis, 07 Januari 2016

[smf_addin] Digest Number 3600

14 Messages

Digest #3600
1a
1b
Re: Documentation link is broken by "Randy Harmelink" rharmelink
2a
3a
Google data source not available anymore? by c2adf9311e2c386ea6b50154ae931d42
3b
Re: Google data source not available anymore? by "Randy Harmelink" rharmelink
4b
4f
5a
Brand new - IBD question by "Gordon Pedersen"
5b
Re: Brand new - IBD question by "Randy Harmelink" rharmelink

Messages

Wed Jan 6, 2016 7:19 am (PST) . Posted by:

nogueira.nuno

Hello,

http://ogres-crypt.com/SMF/ http://ogres-crypt.com/SMF/

Is returning an error.

Where can I find the documentation of the add-in?

Thank you.


Wed Jan 6, 2016 7:20 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The link is working fine here. Might have been a temporary glitch? That is
the only location of the documentation.

On Wed, Jan 6, 2016 at 4:14 AM, nogueira.nuno@... wrote:

>
>
> http://ogres-crypt.com/SMF/
>
> Is returning an error.
>
> Where can I find the documentation of the add-in?
>
>

Wed Jan 6, 2016 7:47 am (PST) . Posted by:

nogueira.nuno

Yep, now it is working also here!

Wed Jan 6, 2016 10:37 am (PST) . Posted by:

freefaller6

Hi Amando, did you ever figure out a way to calcluate the probabilities with a spreadsheet instead of using ToS? Thanks,
Brent

Wed Jan 6, 2016 12:13 pm (PST) . Posted by:

c2adf9311e2c386ea6b50154ae931d42

Can you please help?? Is google no longer providing data? The spreadsheet is not working anymore. Financial_Reporting_Google.xls with inputs such as
Short Term Investments Error

where Error is


=RCHGetElementNumber(Ticker, 3614)





Wed Jan 6, 2016 3:27 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Try the new smf-elements-3.txt file from the "Elements" page from the
website:

http://ogres-crypt.com/SMF/Elements/smf-elements-3.txt

Last month, I changed all of the "http" protocols to "https"...

On Wed, Jan 6, 2016 at 1:13 PM, sdglobe@... wrote:

>
> Can you please help?? Is google no longer providing data? The spreadsheet
> is not working anymore.
> Financial_Reporting_Google.xls with inputs such as
>
> Short Term Investments Error
> where Error is
>
> =RCHGetElementNumber(Ticker, 3614)
>

Wed Jan 6, 2016 5:48 pm (PST) . Posted by:

mark.boogaers

All,

Anyone who could assist with this. I am looking to retrieve stock split and dividend info for stocks in my portfolio automatically from Yahoo.


With B7 being my purchase date and J4 the ticker.


Using
=RCHGetYahooHistory(J4,YEAR($B7),MONTH($B7),DAY($B7),YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()),"v","C",0,2,1)
to get the dividend date. I am guessing this gives the last dividend date in case of multiple.


Then using something I found in another topic to get the total dividend.
=SUM(INDEX(RCHGetYahooHistory(J4,YEAR($B7),MONTH($B7),DAY($B7),YEAR($B16),MONTH($B16),DAY($B16),"v",,0,,,20,2),,2))

I dont really understand how this works, but it does work.(B16 has the last trade date of the stock)


I am trying to get same for stock splits. Anyone any idea? I tried a way around direct retrieval by using the adjusted vs closing prices, but that is not accurate enough.


Yahoo's page for this stock is 0138.KL Historical Prices | MY E.G. SERVICES BHD Stock - Yahoo! Finance http://finance.yahoo.com/q/hp?s=0138.KL+Historical+Prices


0138.KL Historical Prices | MY E.G. SERVICES BHD Stock - Yahoo! Finance http://finance.yahoo.com/q/hp?s=0138.KL+Historical+Prices Discover historical prices for 0138.KL stock on Yahoo! Finance. View daily, weekly or monthly format back to when MY E.G. SERVICES BHD stock was issued.



View on finance.yahoo.com http://finance.yahoo.com/q/hp?s=0138.KL+Historical+Prices
Preview by Yahoo




If anyone has any suggestion please let me know.


Mark

Wed Jan 6, 2016 6:53 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

How about getting split info from MorningStar:

http://performance.morningstar.com/Performance/stock/split-history.action?t=MMM

I have no idea of their coverage on foreign stocks. As far as I know, the
only way to get all the splits from Yahoo would be to retrieve every page
of historical quotes and looks for them. Not a good process. I used to get
it from the basic charts page, but Yahoo doesn't have that any more.

Hmmm. The non-US sites still have the basic charts. For now, anyway. For
example:

https://uk.finance.yahoo.com/q/bc?s=0138.KL

Note the splits just under the chart. They can be retrieved with this in
cell C1, and copy down:

=smfGetTagContent("https://uk.finance.yahoo.com/q/bc?s=0138.KL
","nobr",ROWS(C$1:C1),"Splits:")

On Wed, Jan 6, 2016 at 6:48 PM, mark.boogaers@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Anyone who could assist with this. I am looking to retrieve stock split
> and dividend info for stocks in my portfolio automatically from Yahoo.
>
> With B7 being my purchase date and J4 the ticker.
>
> Using
>
> =RCHGetYahooHistory(J4,YEAR($B7),MONTH($B7),DAY($B7),YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()),"v","C",0,2,1)
> to get the dividend date. I am guessing this gives the last dividend date
> in case of multiple.
>
> Then using something I found in another topic to get the total dividend.
>
> =SUM(INDEX(RCHGetYahooHistory(J4,YEAR($B7),MONTH($B7),DAY($B7),YEAR($B16),MONTH($B16),DAY($B16),"v",,0,,,20,2),,2))
> I dont really understand how this works, but it does work.(B16 has the
> last trade date of the stock)
>
> I am trying to get same for stock splits. Anyone any idea? I tried a way
> around direct retrieval by using the adjusted vs closing prices, but that
> is not accurate enough.
>
> Yahoo's page for this stock is 0138.KL Historical Prices | MY E.G.
> SERVICES BHD Stock - Yahoo! Finance
> <http://finance.yahoo.com/q/hp?s=0138.KL+Historical+Prices>
>

Wed Jan 6, 2016 7:41 pm (PST) . Posted by:

"Robbie Geary" rgearyiii

On Thu, Jan 7, 2016 at 1:53 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> How about getting split info from MorningStar:
>
>
> http://performance.morningstar.com/Performance/stock/split-history.action?t=MMM
>

Nice. Can you produce a similar URL that shows just the dividend and
spin-off information shown at
http://performance.morningstar.com/stock/performance-return.action?p=dividend_split_page&t=FCAU®ion=usa&culture=en-US
?

--
Robbie Geary

Wed Jan 6, 2016 7:42 pm (PST) . Posted by:

"Robbie Geary" rgearyiii

On Thu, Jan 7, 2016 at 2:41 PM, Robbie Geary <rgearyiii@gmail.com> wrote:

>
>
> On Thu, Jan 7, 2016 at 1:53 PM, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>>
>>
>> How about getting split info from MorningStar:
>>
>>
>> http://performance.morningstar.com/Performance/stock/split-history.action?t=MMM
>>
>
> Nice. Can you produce a similar URL that shows just the dividend and
> spin-off information shown at
> http://performance.morningstar.com/stock/performance-return.action?p=dividend_split_page&t=FCAU®ion=usa&culture=en-US
> ?
>

URL*s*, rather.

Scraping data from Morningstar is generally pretty slow, but that split
page loads pretty quickly.

--
Robbie Geary

Wed Jan 6, 2016 7:45 pm (PST) . Posted by:

"Robbie Geary" rgearyiii

On Thu, Jan 7, 2016 at 2:42 PM, Robbie Geary <rgearyiii@gmail.com> wrote:

>
>
> On Thu, Jan 7, 2016 at 2:41 PM, Robbie Geary <rgearyiii@gmail.com> wrote:
>
>>
>>
>> On Thu, Jan 7, 2016 at 1:53 PM, Randy Harmelink rharmelink@gmail.com
>> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>>
>>>
>>>
>>> How about getting split info from MorningStar:
>>>
>>>
>>> http://performance.morningstar.com/Performance/stock/split-history.action?t=MMM
>>>
>>
>> Nice. Can you produce a similar URL that shows just the dividend and
>> spin-off information shown at
>> http://performance.morningstar.com/stock/performance-return.action?p=dividend_split_page&t=FCAU®ion=usa&culture=en-US
>> ?
>>
>
> URL*s*, rather.
>

Answered my own questions:

http://performance.morningstar.com/Performance/stock/dividend-history.action?t=MMM
http://performance.morningstar.com/Performance/stock/spinoff-history.action?t=MMM

--
Robbie Geary

Wed Jan 6, 2016 8:04 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

More dividend history can be achieved with parameters:

http://performance.morningstar.com/Performance/stock/split-history.action?t=MMM
http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=MMM
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=MMM
http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=MMM
http://performance.morningstar.com/Performance/stock/spinoff-history.action?&t=MMM

On Wed, Jan 6, 2016 at 8:45 PM, Robbie Geary rgearyiii@... wrote:

>
> Answered my own questions:
>
>
> http://performance.morningstar.com/Performance/stock/dividend-history.action?t=MMM
>
> http://performance.morningstar.com/Performance/stock/spinoff-history.action?t=MMM
>
>

Wed Jan 6, 2016 10:40 pm (PST) . Posted by:

"Gordon Pedersen"

​HI,

Just downloaded first time SMF Jan 5. Today playing w/tutorial at
http://seekingalpha.com/instablog/326478-derek-a-barrett/1414481-automating-alpha-getting-started-with-stock-market-functions-smf-add-in-for-excel
.

My example Debt/Equity formula results in "Error". Formula is:
=RCHGetElementNumber(A2, 2077)​. It uses IBD and I'd rather learn how to
make ibd work sooner vs later.

I see a new smf-elements-9.txt on ogres-crypt site. Size there is given as
43685. The "9" file I got yesterday is size 85554.

Is it right to download ogres-crypt file and replace my local file?

Gordon

Wed Jan 6, 2016 11:02 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Yes, it is correct to replace your local smf-elements-9.txt file with one
from the Internet when they are updated.

However, the web page listing was incorrect -- the file size is 72K. Not
sure why you got 85K? I just made sure earlier today that all of the files
on the "Elements" web page were up-to-date. I don't know if you got your
file from there or from the "Works in Progress" web page (which should be
correct, but I just removed it from there because it's now on the "Element"
web page).

You can check your definition with:

=RCHGetElementNumber("Definition",2077)

Right now, I get this:

IBD;Debt/Equity Ratio;=RCHGetTableCell("
http://research.investors.com/stock-checkup/xxxx-~~~~~.aspx",1,">Debt/Equity
Ratio")

Some sites, like investors.com, have security on them. In order for the
add-in to be able to get to the data, you need to create an IE security
cookie that EXCEL and the add-in can use to access the web site. For IBD,
that means logging into the web site using either the EXCEL Web Query
dialog, because they consider each form of browser or other tool as an
individual connection. For example, if I'm using the web site with the
add-in, and then visit the web site with my FireFox browser, I often need
to log into the web site again.

On Wed, Jan 6, 2016 at 9:38 PM, Gordon Pedersen gordon@...wrote:

>
> Just downloaded first time SMF Jan 5. Today playing w/tutorial at
> http://seekingalpha.com/instablog/326478-derek-a-barrett/1414481-automating-alpha-getting-started-with-stock-market-functions-smf-add-in-for-excel
> .
>
> My example Debt/Equity formula results in "Error". Formula is:
> =RCHGetElementNumber(A2, 2077)​. It uses IBD and I'd rather learn how to
> make ibd work sooner vs later.
>
> I see a new smf-elements-9.txt on ogres-crypt site. Size there is given
> as 43685. The "9" file I got yesterday is size 85554.
>
> Is it right to download ogres-crypt file and replace my local file?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar