Selasa, 15 Desember 2015

[smf_addin] Digest Number 3582[1 Attachment]

7 Messages

Digest #3582

Messages

Mon Dec 14, 2015 6:11 am (PST) . Posted by:

mark.boogaers

Thanks for the reply.

Appreciate the add-in is made for ad-hoc and not data mining. Not planning to make a business out of it, just a 1 time thing mining bit of data to do some research myself on non US markets.


For some reason it does not jam up on an old computer running. Not sure what you meant by the smfForceRecalculation or how to get that to work.


O have seen the Excel Add-in and API tools on the Gurufocus website, but I am not that familiar and found your add-in easier to work with.


Mon Dec 14, 2015 3:27 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Check the "Tips and FAQs" page for more information on the
smfForceRecalculation and smfUpdateDownloadTable macros. It sounds like
what you're doing would work best as an smfUpdateDownloadTable process,
since it leaves values in the tables and not formulas, which allows you to
do the process piecemeal easily (just highlight the rows you want to update
and run the macro).

I've attached a very small example of an smfUpdateDownloadTable workbook
using several GuruFocus data items.

In general, the process I would use to update:

1. Run the smfForceRecalculation macro to purge all saved web pages
2. Highlight the rows I want to update (otherwise it will update *all* rows)
3. Run the smfUpdateDownloadTable macro (processing status will be shown in
the EXCEL status line)

Try it on just a few rows, even if all you did to the rows was to add the
ticker symbols. It can actually be kind of fun watching it populate empty
rows with data. :)

I have both of those macros assigned to buttons on my EXCEL toolbar so they
are readily accessible whenever I need them.

On Mon, Dec 14, 2015 at 7:11 AM, mark.boogaers@... wrote:

>
> Appreciate the add-in is made for ad-hoc and not data mining. Not planning
> to make a business out of it, just a 1 time thing mining bit of data to do
> some research myself on non US markets.
>
> For some reason it does not jam up on an old computer running. Not sure
> what you meant by the smfForceRecalculation or how to get that to work.
>
> O have seen the Excel Add-in and API tools on the Gurufocus website, but I
> am not that familiar and found your add-in easier to work with.
>
Attachment(s) from Randy Harmelink
1 of 1 File(s)

Mon Dec 14, 2015 10:54 am (PST) . Posted by:

zbgb952

http://www.thestreet.com/r/ratings/reports/ir-screener.html http://www.thestreet.com/r/ratings/reports/ir-screener.html


They appear to be free for now


Mon Dec 14, 2015 11:25 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The two formulas in the message thread I pointed you to before work fine
for me...

=smfStrExtr(RCHGetWebData("
http://www.thestreet.com/quote/AAPL/details/analyst-ratings.html
","LetterGradeRating",100),":""","""")

=smfStrExtr(RCHGetWebData("
http://www.thestreet.com/quote/AAPL/details/analyst-ratings.html
","CurrentRating",100),":""","""")

On Mon, Dec 14, 2015 at 11:54 AM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> http://www.thestreet.com/r/ratings/reports/ir-screener.html
>
> They appear to be free for now
>

Mon Dec 14, 2015 1:17 pm (PST) . Posted by:

"Luca Dal Molin" luca_dalmolin

Thanks a lot Randy!
Luca

On Sunday, December 13, 2015 11:09 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  You may have to make adjustments to your Internet Options to get some web sites to work. For example, check the "Tips and FAQs" web page for AdvFN items. It's my understanding that the cross domains fix for AdvFN also fixes any issue with Google.

Otherwise, I'd need more specifics.

The RCHGetElementNumber() data elements are really just saved versions of other functions, so you could use some of the other functions to go after the data directly.

For financial statements data, be sure to check out the templates. Some are for RCHGetElementNumber() functions, but others use other add-in functions. These days, my preferred financials data source is GuruFocus, but I'm a subscriber. A large chunk of there data is limited to subscribers only.

On Sun, Dec 13, 2015 at 11:06 AM, luca_dalmolin@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

I'm a new member, I installed the add in but apparently I can only get data from Yahoo when I enter the code from RCHGetElementNumber-Element-Definitions. All other codes that refer to other sites generate an error.Can anyone direct me on how to get financial statements from other sites or give me some uselful links where I can get an asnwer?

#yiv1141421134 #yiv1141421134 -- #yiv1141421134ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1141421134 #yiv1141421134ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1141421134 #yiv1141421134ygrp-mkp #yiv1141421134hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1141421134 #yiv1141421134ygrp-mkp #yiv1141421134ads {margin-bottom:10px;}#yiv1141421134 #yiv1141421134ygrp-mkp .yiv1141421134ad {padding:0 0;}#yiv1141421134 #yiv1141421134ygrp-mkp .yiv1141421134ad p {margin:0;}#yiv1141421134 #yiv1141421134ygrp-mkp .yiv1141421134ad a {color:#0000ff;text-decoration:none;}#yiv1141421134 #yiv1141421134ygrp-sponsor #yiv1141421134ygrp-lc {font-family:Arial;}#yiv1141421134 #yiv1141421134ygrp-sponsor #yiv1141421134ygrp-lc #yiv1141421134hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1141421134 #yiv1141421134ygrp-sponsor #yiv1141421134ygrp-lc .yiv1141421134ad {margin-bottom:10px;padding:0 0;}#yiv1141421134 #yiv1141421134actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1141421134 #yiv1141421134activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1141421134 #yiv1141421134activity span {font-weight:700;}#yiv1141421134 #yiv1141421134activity span:first-child {text-transform:uppercase;}#yiv1141421134 #yiv1141421134activity span a {color:#5085b6;text-decoration:none;}#yiv1141421134 #yiv1141421134activity span span {color:#ff7900;}#yiv1141421134 #yiv1141421134activity span .yiv1141421134underline {text-decoration:underline;}#yiv1141421134 .yiv1141421134attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1141421134 .yiv1141421134attach div a {text-decoration:none;}#yiv1141421134 .yiv1141421134attach img {border:none;padding-right:5px;}#yiv1141421134 .yiv1141421134attach label {display:block;margin-bottom:5px;}#yiv1141421134 .yiv1141421134attach label a {text-decoration:none;}#yiv1141421134 blockquote {margin:0 0 0 4px;}#yiv1141421134 .yiv1141421134bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1141421134 .yiv1141421134bold a {text-decoration:none;}#yiv1141421134 dd.yiv1141421134last p a {font-family:Verdana;font-weight:700;}#yiv1141421134 dd.yiv1141421134last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1141421134 dd.yiv1141421134last p span.yiv1141421134yshortcuts {margin-right:0;}#yiv1141421134 div.yiv1141421134attach-table div div a {text-decoration:none;}#yiv1141421134 div.yiv1141421134attach-table {width:400px;}#yiv1141421134 div.yiv1141421134file-title a, #yiv1141421134 div.yiv1141421134file-title a:active, #yiv1141421134 div.yiv1141421134file-title a:hover, #yiv1141421134 div.yiv1141421134file-title a:visited {text-decoration:none;}#yiv1141421134 div.yiv1141421134photo-title a, #yiv1141421134 div.yiv1141421134photo-title a:active, #yiv1141421134 div.yiv1141421134photo-title a:hover, #yiv1141421134 div.yiv1141421134photo-title a:visited {text-decoration:none;}#yiv1141421134 div#yiv1141421134ygrp-mlmsg #yiv1141421134ygrp-msg p a span.yiv1141421134yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1141421134 .yiv1141421134green {color:#628c2a;}#yiv1141421134 .yiv1141421134MsoNormal {margin:0 0 0 0;}#yiv1141421134 o {font-size:0;}#yiv1141421134 #yiv1141421134photos div {float:left;width:72px;}#yiv1141421134 #yiv1141421134photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1141421134 #yiv1141421134photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1141421134 #yiv1141421134reco-category {font-size:77%;}#yiv1141421134 #yiv1141421134reco-desc {font-size:77%;}#yiv1141421134 .yiv1141421134replbq {margin:4px;}#yiv1141421134 #yiv1141421134ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1141421134 #yiv1141421134ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1141421134 #yiv1141421134ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1141421134 #yiv1141421134ygrp-mlmsg select, #yiv1141421134 input, #yiv1141421134 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1141421134 #yiv1141421134ygrp-mlmsg pre, #yiv1141421134 code {font:115% monospace;}#yiv1141421134 #yiv1141421134ygrp-mlmsg * {line-height:1.22em;}#yiv1141421134 #yiv1141421134ygrp-mlmsg #yiv1141421134logo {padding-bottom:10px;}#yiv1141421134 #yiv1141421134ygrp-msg p a {font-family:Verdana;}#yiv1141421134 #yiv1141421134ygrp-msg p#yiv1141421134attach-count span {color:#1E66AE;font-weight:700;}#yiv1141421134 #yiv1141421134ygrp-reco #yiv1141421134reco-head {color:#ff7900;font-weight:700;}#yiv1141421134 #yiv1141421134ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1141421134 #yiv1141421134ygrp-sponsor #yiv1141421134ov li a {font-size:130%;text-decoration:none;}#yiv1141421134 #yiv1141421134ygrp-sponsor #yiv1141421134ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1141421134 #yiv1141421134ygrp-sponsor #yiv1141421134ov ul {margin:0;padding:0 0 0 8px;}#yiv1141421134 #yiv1141421134ygrp-text {font-family:Georgia;}#yiv1141421134 #yiv1141421134ygrp-text p {margin:0 0 1em 0;}#yiv1141421134 #yiv1141421134ygrp-text tt {font-size:120%;}#yiv1141421134 #yiv1141421134ygrp-vital ul li:last-child {border-right:none !important;}#yiv1141421134

Tue Dec 15, 2015 12:39 am (PST) . Posted by:

luca_dalmolin

Hi Randy,

I fixed the problem going to IE options. Now the codes work fine also for Google. I downloaded the Advfn template to get the 10y financial statements. Some tickers work (eg. msft, ba, mmm), some others give me an error message (eg goog, cost). Do you know any specific reason for that?


If I go to the ADVfn website I can get the data fot those tickers that give me error on the spreadsheet. I live in Dubai and I also tried to connect to the US website using a VPN connection.


Thanks again!


Luca

Tue Dec 15, 2015 1:45 am (PST) . Posted by:

"Randy Harmelink" rharmelink

If you live in Dubai, you may need to use the regional AdvFN fix as well,
since AdvFN redirects to a regional URL. That means default exchanges and
such change. I'm not sure how well things work outside the U.S. since the
last few AdvFN updates. I have no way to test regional changes, since it
doesn't happen to me.

Easiest way to check what URL you're getting is to use the EXCEL Web Query
dialog, go to the www.advfn.com URL and see if you get redirected to a
different URL. You can also try that in IE.

On Tue, Dec 15, 2015 at 1:39 AM, luca_dalmolin@... wrote:

>
> I fixed the problem going to IE options. Now the codes work fine also for
> Google. I downloaded the Advfn template to get the 10y financial
> statements. Some tickers work (eg. msft, ba, mmm), some others give me an
> error message (eg goog, cost). Do you know any specific reason for that?
>
> If I go to the ADVfn website I can get the data fot those tickers that
> give me error on the spreadsheet. I live in Dubai and I also tried to
> connect to the US website using a VPN connection.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.08

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)