Senin, 07 April 2014

[smf_addin] Digest Number 3034

10 Messages

Digest #3034
1b
Re: Google numbers 3072 Errors by "Randy Harmelink" rharmelink
1d
Re: Google numbers 3072 Errors by "Randy Harmelink" rharmelink
2a
Re: Obscure (?) UK Funds by simon.kemp@rocketmail.com
3a
Re: UK stocks by simon.kemp@rocketmail.com
3b
Re: UK stocks by "Randy Harmelink" rharmelink
4b
Re: Difficulty downloading SMF Add-in by "Randy Harmelink" rharmelink

Messages

Sun Apr 6, 2014 12:51 pm (PDT) . Posted by:

almondtree

http://ogres-crypt.com/SMF/Templates/SMF-Template-Google-Income-Statement-Tables.xls http://ogres-crypt.com/SMF/Templates/SMF-Template-Google-Income-Statement-Tables.xls


Template above all errors
I use 3072, 3142, 3042, 3102, 2992 now is all errors. Updated SMF latest version. I only use these once every 6 months. . edited links C:\ProgramFiles\Smf Add-In, Excel 2010. I tried 967, 2, 25 return some numbers some obsolete. I like GooGle numbers.
Side note ordered from Amazon USB 3.0 PCI-e Card and front panel. To be used with 1tb sub 3.0 backup drive. DVD Disk Backup(some of them did'nt work)saved my bacon on hard drive die off.

Sun Apr 6, 2014 1:13 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The template is working fine for me, using ticker symbol MMM. What do you
get with:

=RCHGetElementNumber("MMM", 3308)
=smfGetAParms(3308)
=RCHGetElementNumber("Version")
=RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=MMM
",1,"INCANNUALDIV",">Revenue")
=RCHGetWebData("http://www.google.com/finance?fstype=ii&q=MMM
",">Revenue",50)
=RCHGetWebData("http://www.google.com/finance?fstype=ii&q=MMM",1,30)
=RCHGetTableCell("https://www.google.com/finance?fstype=ii&q=MMM
",1,"INCANNUALDIV",">Revenue")
=RCHGetWebData("https://www.google.com/finance?fstype=ii&q=MMM
",">Revenue",50)
=RCHGetWebData("https://www.google.com/finance?fstype=ii&q=MMM",1,30)

How did you edit the links?

On Sun, Apr 6, 2014 at 12:51 PM, <almondtree@yahoo.com> wrote:

>
> http://ogres-crypt.com/SMF/Templates/SMF-Template-Google-Income-Statement-Tables.xls
>
> Template above all errors
>
> I use 3072, 3142, 3042, 3102, 2992 now is all errors. Updated SMF latest
> version. I only use these once every 6 months. . edited links
> C:\ProgramFiles\Smf Add-In, Excel 2010. I tried 967, 2, 25 return some
> numbers some obsolete. I like GooGle numbers.
>

Sun Apr 6, 2014 7:27 pm (PDT) . Posted by:

almondtree

=RCHGetElementNumber("MMM",3308)
=smfGetAParms(3308)
=RCHGetElementNumber("Version")
=RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=MMM",1,"INCANNUALDIV",">Revenue") http://www.google.com/finance?fstype=ii&q=MMM
=RCHGetWebData("http://www.google.com/finance?fstype=ii&q=MMM",">Revenue",50) http://www.google.com/finance?fstype=ii&q=MMM
=RCHGetWebData("http://www.google.com/finance?fstype=ii&q=MMM",1,30)
=RCHGetTableCell("https://www.google.com/finance?fstype=ii&q=MMM",1,"INCANNUALDIV",">Revenue") https://www.google.com/finance?fstype=ii&q=MMM
=RCHGetWebData("https://www.google.com/finance?fstype=ii&q=MMM",">Revenue",50)
=RCHGetWebData("https://www.google.com/finance?fstype=ii&q=MMM",1,30)

Results:
Error
Google;Annual Income Statement -- Revenue -- FY1;http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCANNUALDIV;>Revenue; ; ;0;</TABLE;0;0
Stock Market Functions add-in, Version 2.1.2014.01.30 (C:\Program Files\SMF Add-In; ; 1)
Error http://www.google.com/finance?fstype=ii&q=MMM
Error http://www.google.com/finance?fstype=ii&q=MMM
Error
30871 https://www.google.com/finance?fstype=ii&q=MMM
>Revenue</td><td class="r">7,569.00</td><td class=
<!DOCTYPE html><html><head><sc

Sun Apr 6, 2014 8:14 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It appears your machine isn't handling Google's web page redirections. The
element definitions use this URL:

http://www.google.com/finance?fstype=ii&q=MMM

...but Google is redirecting that to:

https://www.google.com/finance?fstype=ii&q=MMM

...just changing the "http" protocol to "https".

On Sun, Apr 6, 2014 at 7:27 PM, <almondtree@yahoo.com> wrote:

>
>
> =RCHGetElementNumber("MMM",3308)
>
> =smfGetAParms(3308)
>
> =RCHGetElementNumber("Version")
>
> *=RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=MMM",1,"INCANNUALDIV",">Revenue")
> <http://www.google.com/finance?fstype=ii&q=MMM>*
>
> *=RCHGetWebData("http://www.google.com/finance?fstype=ii&q=MMM",">Revenue",50)
> <http://www.google.com/finance?fstype=ii&q=MMM>*
>
> =RCHGetWebData("http://www.google.com/finance?fstype=ii&q=MMM",1,30)
>
> *=RCHGetTableCell("https://www.google.com/finance?fstype=ii&q=MMM",1,"INCANNUALDIV",">Revenue")
> <https://www.google.com/finance?fstype=ii&q=MMM>*
>
> =RCHGetWebData("https://www.google.com/finance?fstype=ii&q=MMM
> ",">Revenue",50)
>
> =RCHGetWebData("https://www.google.com/finance?fstype=ii&q=MMM",1,30)
>
>
>
> Results:
>
> Error
>
> Google;Annual Income Statement -- Revenue -- FY1;
> http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCANNUALDIV;>Revenue;
> ; ;0;</TABLE;0;0
>
> Stock Market Functions add-in, Version 2.1.2014.01.30 (C:\Program
> Files\SMF Add-In; ; 1)
>
> *Error <http://www.google.com/finance?fstype=ii&q=MMM>*
>
> *Error <http://www.google.com/finance?fstype=ii&q=MMM>*
>
> Error
>
> *30871 <https://www.google.com/finance?fstype=ii&q=MMM>*
>
> >Revenue</td><td class="r">7,569.00</td><td class=
>
> <!DOCTYPE html><html><head><sc
>
>
>
>

Sun Apr 6, 2014 10:09 pm (PDT) . Posted by:

almondtree

Problem solved: Tips and FAQs, Links, excel 2010


mironm http://seekingalpha.com/user/6873981/comments Comment (1) http://seekingalpha.com/user/6873981/comments

Derek, Ron, Chuck,

From the SMF message board, the IE setting needing to be changed are:

In Internet Explorer : Tools, Internet Options, Security, Custom Level button (for the zone that's currently highlighted); Find the 'Access Data Sources Across Domains' option and set to 'Enable'. Click OK to save the settings change.

This was useful for getting advfn data from outside the US (in my case Australia)

(thanks to laveys for providing the solution)

Miron
5 Feb 2013, 02:46 PM




Pasted from <http://seekingalpha.com/instablog/326478-derek-a-barrett/1414481-automating-alpha-getting-started-with-stock-marke http://seekingalpha.com/instablog/326478-derek-a-barrett/1414481-automating-alpha-getting-started-with-stock-market-functions-smf-add-in-for-excel
Thanks Randy

Sun Apr 6, 2014 1:14 pm (PDT) . Posted by:

simon.kemp@rocketmail.com

Hi Nick

I am new to all this and I am trying to do, what you look like you have achieved - are you willing or able to share your set up for the UK ??
Thanks Simon

Sun Apr 6, 2014 1:14 pm (PDT) . Posted by:

simon.kemp@rocketmail.com

Hi
I am new to all this and based in the UK and would like to use this function. Have downloaded etc the info and installed, and it works for US stocks.
No I want to be able to use UK stocks etc but i can not figure where this bit fits
=smfGetTagContent("http://www.londonstockexchange.com/exchange/searchengine/search.html?lang=en&x=0&y=0&q=AAA","td",1,"Total Results:",">Symbol","AAA")

Any help appreciated -thanks

Sun Apr 6, 2014 1:24 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That gets you the link, the URL, for the data that belongs to ticker symbol
AAA. That is:

<a href="
http://www.londonstockexchange.com/exchange/prices-and-markets/stocks/summary/company-summary.html?fourWayKey=VGG017801082GBGBXASQ1&lang=en">All
Asia Asset Capital Limited Ord Npv (Di)</a>

You'd extract the URL out of there, and then use that URL in other
functions to get the desired data. For example::

D16: =smfGetTagContent("
http://www.londonstockexchange.com/exchange/searchengine/search.html?q=AAA","td",1,"Total
Results:",">Symbol","AAA")
D17: =smfStrExtr(D16,"""","""")
D18: =RCHGetTableCell(D17,1,"FTSE Sector")

...would get you the FTSE Sector. This roundabout method is needed because
you can't use the ticker symbol to get directly to the data page.

On Sun, Apr 6, 2014 at 1:07 PM, <simon.kemp@rocketmail.com> wrote:

>
> I am new to all this and based in the UK and would like to use this
> function. Have downloaded etc the info and installed, and it works for US
> stocks.
> No I want to be able to use UK stocks etc but i can not figure where this
> bit fits
> =smfGetTagContent("
> http://www.londonstockexchange.com/exchange/searchengine/search.html?lang=en&x=0&y=0&q=AAA","td",1,"Total
> Results:",">Symbol","AAA")
>
> Any help appreciated -thanks
>

Sun Apr 6, 2014 4:32 pm (PDT) . Posted by:

gaeisen

HI. A New User Question:

I am having trouble downloading the SMF Add-in, for a peculiar reason.

I inherited a spreadsheet to maintain which uses SMF. I was able to download SMF Add-in to my hard drive at C:\SMF Add-in. However, the spreadsheet was based on loading SMF in a different directory.

All the cell references start with:
='C:\Program Files\SMF Add-in\RCH_Stock_Market_Functions.xla'


So, I set up a sub-directory in Program Files called SMF Add-in, and cut/pasted all the files I had downloaded into that directory. However, the spreadsheet would not recognize the program placed in that directory, even though the syntax was equivalent to each other. When I tried to update the spreadsheet I got the "#NAME" response.
(I enabled the add-in manager (alt+t+i) and checked the box.)

I figured I might have done something wrong at original download, so I deleted the entire Add-in completely and went back to the download page. When I tried to download, I specified the C:\Program Files\SMF Add-in directory location, but I received an error message - see below (I have administrator status on this PC). After multiple tries, I reverted to downloading to the original directory –
C:\SMF Add-in

That download was successful. Further, if I go into the spreadsheet I am able to change the cell reference in each cell, simply deleting the portion that says \Program Files and Excel returns the correct data requested. However, other people are using this spreadsheet, and it seems to work for them using the Program Files directory. I want to avoid telling others they need to change their downloaded add-in, since they are users not techies, and "they were here first".

So, what is the trick to getting the Add-in to download to the C:\Program Files\SMF Add-in directory location?

I'm running a 3-year old HP PC with Windows 7, Excel 2010, and I'm downloading from Yahoo using Google Chrome for my browser.

Since this is a shared workbook, I suspect once I get the add-in downloaded into program files, I'll face the issues described here>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/11346 https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/11346

Oh – the error message I got looked like this:

! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30 (1).zip: Cannot create smf-elements-6.txt
Access is denied.
! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30 (1).zip: Cannot create smf-elements-7.txt
Access is denied.
! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30 (1).zip: Cannot create smf-elements-8.txt
Access is denied.
! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30 (1).zip: Cannot create smf-elements-1.txt
Access is denied.
! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30 (1).zip: Cannot create smf-elements-2.txt
Access is denied.
! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30 (1).zip: Cannot create smf-elements-4.txt
Access is denied.
! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30 (1).zip: Cannot create smf-elements-5.txt
Access is denied.
! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30 (1).zip: Cannot create smf-elements-0.txt
Access is denied.
! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30 (1).zip: Cannot create smf-elements-3.txt
Access is denied.
! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30 (1).zip: Cannot create smf-elements-9.txt
Access is denied.
! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30 (1).zip: Cannot create smf-elements-info.txt
Access is denied.
! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30 (1).zip: Cannot create RCHGetElementNumber-Element-Definitions.xls
Access is denied.
! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30 (1).zip: Cannot create RCH_Stock_Market_Functions.xla
Access is denied.

Thanks.

Greg Eisen

Sun Apr 6, 2014 4:40 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Don't change the location of your add-in based on a workbook you open. It
will have a path based on whatever location the saver of the workbook had
for THEIR add-in. So, any workbook could literally expect to have the
add-in in almost ANY location.

Instead, fix the locations in your workbook. Once you save it, it will save
the location of YOUR add-in. So the next time you open it, you won't have
the same issue.

I'm currently using the C:\SMF Add-in folder, because Vista wouldn't allow
me to change the XLA file when it was located in the Program Files folder.
All workbooks on the website will use that location, since I am typically
updating them before uploading them to the web site. That means they are
saved with MY add-in location.

Windows 7 may also be finicky about what can happen in the Program Files
directory.

The easiest thing is just to use the smfFixLinks macro whenever you have a
hard-coded location on your functions. I have it assigned to a toolbar
button and use it regularly.

On Sun, Apr 6, 2014 at 3:06 PM, <g.eisen@comcast.net> wrote:

> HI. A New User Question:
>
> I am having trouble downloading the SMF Add-in, for a peculiar reason.
>
> I inherited a spreadsheet to maintain which uses SMF. I was able to
> download SMF Add-in to my hard drive at *C:\SMF Add-in*. However, the
> spreadsheet was based on loading SMF in a different directory.
>
> All the cell references start with:
>
> *='C:\Program Files\SMF Add-in\RCH_Stock_Market_Functions.xla'*
>
> So, I set up a sub-directory in Program Files called SMF Add-in, and
> cut/pasted all the files I had downloaded into that directory. However,
> the spreadsheet would not recognize the program placed in that directory,
> even though the syntax was equivalent to each other. When I tried to update
> the spreadsheet I got the "#NAME" response.
>
> (I enabled the add-in manager (alt+t+i) and checked the box.)
>
> I figured I might have done something wrong at original download, so I
> deleted the entire Add-in completely and went back to the download page.
> When I tried to download, I specified the *C:\Program Files\SMF Add-in*
> directory location, but I received an error message - see below (I have
> administrator status on this PC). After multiple tries, I reverted to
> downloading to the original directory –
>
> *C:\SMF Add-in *
>
> That download was successful. Further, if I go into the spreadsheet I am
> able to change the cell reference in each cell, simply deleting the portion
> that says *\Program Files* and Excel returns the correct data requested.
> However, other people are using this spreadsheet, and it seems to work for
> them using the Program Files directory. I want to avoid telling others they
> need to change their downloaded add-in, since they are users not techies,
> and "they were here first".
>
> So, what is the trick to getting the Add-in to download to the *C:\Program
> Files\SMF Add-in* directory location?
>
> I'm running a 3-year old HP PC with Windows 7, Excel 2010, and I'm
> downloading from Yahoo using Google Chrome for my browser.
>
> Since this is a shared workbook, I suspect once I get the add-in
> downloaded into program files, I'll face the issues described here>
>
> https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/11346
>
> Oh – the error message I got looked like this:
>
> ! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30
> (1).zip: Cannot create smf-elements-6.txt
>
> Access is denied.
>
> ! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30
> (1).zip: Cannot create smf-elements-7.txt
>
> Access is denied.
>
> ! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30
> (1).zip: Cannot create smf-elements-8.txt
>
> Access is denied.
>
> ! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30
> (1).zip: Cannot create smf-elements-1.txt
>
> Access is denied.
>
> ! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30
> (1).zip: Cannot create smf-elements-2.txt
>
> Access is denied.
>
> ! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30
> (1).zip: Cannot create smf-elements-4.txt
>
> Access is denied.
>
> ! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30
> (1).zip: Cannot create smf-elements-5.txt
>
> Access is denied.
>
> ! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30
> (1).zip: Cannot create smf-elements-0.txt
>
> Access is denied.
>
> ! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30
> (1).zip: Cannot create smf-elements-3.txt
>
> Access is denied.
>
> ! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30
> (1).zip: Cannot create smf-elements-9.txt
>
> Access is denied.
>
> ! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30
> (1).zip: Cannot create smf-elements-info.txt
>
> Access is denied.
>
> ! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30
> (1).zip: Cannot create RCHGetElementNumber-Element-Definitions.xls
>
> Access is denied.
>
> ! C:\Users&#92;Greg&#92;Downloads&#92;RCH_Stock_Market_Functions-2.1.2014.01.30
> (1).zip: Cannot create RCH_Stock_Market_Functions.xla
>
> Access is denied.
>
>
>
> Thanks.
>
>
>
> Greg Eisen
>
>
>
>
Diposting oleh EXCEL FEED LEARNING di 01.23

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)