Jumat, 15 Maret 2013

[smf_addin] Digest Number 2546[1 Attachment]

15 New Messages

Digest #2546
2a
Re: problem with yahoo ownership by "weekeewawa" weekeewawa
3.1
Re: RCHGetWebData by "iamruf" iamruf
3.2
Re: RCHGetWebData by "Randy Harmelink" rharmelink
3.3
Re: RCHGetWebData by "iamruf" iamruf
3.4
Re: RCHGetWebData by "Randy Harmelink" rharmelink
4a
4b
Re: problem extracting yahoo historical data by "Randy Harmelink" rharmelink
5a
5b
Re: RCHGetElementNumber for Morningstar by "Randy Harmelink" rharmelink

Messages

Fri Mar 15, 2013 7:47 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

I use multiple machines and I want to share the SMF ADDIN excel files across multiple computers by storing all the files on one drive.

When I save on one machine and open the file from a different machine the links are referencing the machine where the files are stored.
The link path are different on each machine even though it is the same hard drive.

It appears it is looking for the Addin to be on the same drive as the files.

If I use a flash drive to hold the excel file I don't have the problem. But it is a pain having to move the flash drive from machine to machine since they are in different rooms.

I have been fighting this problem and going through the changing of the path every time and it is something I would like to avoid if possible.

Any thoughts on how I go about setting things up so I don't have to keep changing the ADDIN links every time?

My configuration is

Computer Operating System
Kermit1 Vista 64 bit
Kermit2 XP 32 bit
Kermit3 Windows 7 32 bit
Kermit4 Windows 7 3 2bit

Currently the SMF ADDIN is installed on each machine on the C drive in folder SMFADDIN.
While the excel files are stored on Kermit1 in folder SMFADDIN-EXCEL


Thanks, Kermit

Fri Mar 15, 2013 7:53 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You're going to have the problem as long as the link paths are different.
That is what EXCEL stores when it saves the workbook. You'd need to assign
the network drive as the same designated path on each machine for it to be
seamless.

On Fri, Mar 15, 2013 at 7:47 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> I use multiple machines and I want to share the SMF ADDIN excel files
> across multiple computers by storing all the files on one drive.****
>
> ** **
>
> When I save on one machine and open the file from a different machine the
> links are referencing the machine where the files are stored. ****
>
> The link path are different on each machine even though it is the same
> hard drive. ****
>
> ** **
>
> It appears it is looking for the Addin to be on the same drive as the
> files. ****
>
> ** **
>
> If I use a flash drive to hold the excel file I don't have the problem.
> But it is a pain having to move the flash drive from machine to machine
> since they are in different rooms. ****
>
> ** **
>
> I have been fighting this problem and going through the changing of the
> path every time and it is something I would like to avoid if possible. ***
> *
>
> ** **
>
> Any thoughts on how I go about setting things up so I don't have to keep
> changing the ADDIN links every time?****
>
> ** **
>
> My configuration is ****
>
> ** **
>
> Computer Operating System****
>
> Kermit1 Vista 64 bit ****
>
> Kermit2 XP 32 bit****
>
> Kermit3 Windows 7 32 bit****
>
> Kermit4 Windows 7 3 2bit****
>
> ** **
>
> Currently the SMF ADDIN is installed on each machine on the C drive in
> folder SMFADDIN.****
>
> While the excel files are stored on Kermit1 in folder SMFADDIN-EXCEL****
>
>
>

Fri Mar 15, 2013 2:16 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

I'll give it a shot but I don't think that will work. I'll let you know the results.


Probably try it over the week-end. Right now I'm putting final touches on my presentations for our local traders meeting tomorrow.
For that I'll put the files I need on a flash drive.

Thanks

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Friday, March 15, 2013 10:53 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Is there any way to share SMF ADDIN files between computers


You're going to have the problem as long as the link paths are different. That is what EXCEL stores when it saves the workbook. You'd need to assign the network drive as the same designated path on each machine for it to be seamless.
On Fri, Mar 15, 2013 at 7:47 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:

I use multiple machines and I want to share the SMF ADDIN excel files across multiple computers by storing all the files on one drive.

When I save on one machine and open the file from a different machine the links are referencing the machine where the files are stored.
The link path are different on each machine even though it is the same hard drive.

It appears it is looking for the Addin to be on the same drive as the files.

If I use a flash drive to hold the excel file I don't have the problem. But it is a pain having to move the flash drive from machine to machine since they are in different rooms.

I have been fighting this problem and going through the changing of the path every time and it is something I would like to avoid if possible.

Any thoughts on how I go about setting things up so I don't have to keep changing the ADDIN links every time?

My configuration is

Computer Operating System
Kermit1 Vista 64 bit
Kermit2 XP 32 bit
Kermit3 Windows 7 32 bit
Kermit4 Windows 7 3 2bit

Currently the SMF ADDIN is installed on each machine on the C drive in folder SMFADDIN.
While the excel files are stored on Kermit1 in folder SMFADDIN-EXCEL


Fri Mar 15, 2013 2:29 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

I am sure the problem is me but I can't figure out why it is failing on some symbols and working on most.
I'm hoping you can spot my error
Using only these 4 symbols 2 return misinformation


Symbol
Price Indicator -- 15 Day Trend
Price Indicator -- 45 Day Trend
Price Indicator -- 100 Day Trend


win
bullish
bearish
bullish
red cells should be bearish not bullish.

ibm
bullish
bullish
bullish


AMTG
bearish
bullish
bullish


agnc
bullish
bullish
bullish


Column "B" contains =smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"15 Day Trend","images&quot;)
Column "C" contains =smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"45 Day Trend","images&quot;)
Column "D" contains =smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"100 Day Trend","images&quot;)

I am using this method to pull the information because elements 811 -813 still do not work on my desktop or laptop.

Thanks,
Kermit


Attachments with this message:
1 of 1 File(s)

Fri Mar 15, 2013 2:51 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

As is, your "100-day trend" string will grab the 100-day trend from the
"volume/momentum" tab instead of the "moving average/volatility&quot; tab.

That's why I use "moving average/vol" as my first search string, to
position me on the proper tab.

On Fri, Mar 15, 2013 at 2:29 PM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> I am sure the problem is me but I can't figure out why it is failing on
> some symbols and working on most.
>
> I'm hoping you can spot my error
>
> Using only these 4 symbols 2 return misinformation
>
>
>
> *Symbol*
>
> *Price Indicator -- 15 Day Trend*
>
> *Price Indicator -- 45 Day Trend*
>
> *Price Indicator -- 100 Day Trend*
>
> win
>
> bullish
>
> bearish
>
> bullish
>
> red cells should be bearish not bullish.
>
> ibm
>
> bullish
>
> bullish
>
> bullish
>
> AMTG
>
> bearish
>
> bullish
>
> bullish
>
> agnc
>
> bullish
>
> bullish
>
> bullish
>
>
>
> Column "B" contains =smfGetTagContent("
> http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"15 Day
> Trend","images&quot;)
>
> Column "C" contains =smfGetTagContent("
> http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"45 Day
> Trend","images&quot;)
>
> Column "D" contains =smfGetTagContent("
> http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"100 Day
> Trend","images&quot;)
>
>
>
> I am using this method to pull the information because elements 811 -813
> still do not work on my desktop or laptop.
>
>
>

Fri Mar 15, 2013 8:15 am (PDT) . Posted by:

"weekeewawa" weekeewawa

works perfectly!

thanks randy

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> See: http://finance.groups.yahoo.com/group/smf_addin/message/21680
>
> On Thu, Mar 14, 2013 at 2:38 AM, weekeewawa <weekeewawa@...> wrote:
>
> > additonally, there is a problem,
> >
> > in the =RCHGetHTMLTable("http://finance.yahoo.com/q/mh?s=MMM",">Top
> > Institutional",-1,"",2)
> >
> > code for example. the s=MMM refers to 3M
> >
> > however, i have a ticker at Cell A1 where i key in the symbol in it
> >
> > how do i refer the Cell A1 to the code?
> >
>

Fri Mar 15, 2013 8:30 am (PDT) . Posted by:

"iamruf" iamruf

Hi Randy,
I have been using these Web sites and formulas to extract data.
They have stopped working.
Can you please review?
Thanks

=RCHGetWebData("http://tmx.quotemedia.com/json/getQuotesMini.json.php?jsoncallba\ck=jsonp1358089488792&symbols=BIP101&amp;webmasterId=101020&_=1358089550952&quot;,1,1000)
=VALUE(MID(C2,FIND("last",C2)+7,5))

and

http://app.quotemedia.com/quotetools/fundataModule.go?overviewChartLink=off&ents=wmonly&showCommas=true&toolWidth=740&webmasterId=101020&chgrd=D8DCE5&;chbdr=D8DCE5&amp;chfill2=6d9641&chfill=cc6d9641&amp;chln=313942&chaaon=true&cp=off&symbol=BIP101&amp;hiddenTabs=topnav&action=showDetailedQuote&targetURL=http://tmx.quotemedia.com/funds-ca-quote.php&locale=en
=smfGetTagContent(D2,"div",1,"Eligiblity:")
=RCHGetTableCell(D2,0,"This Fund")

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The RCHGetWebData() is just returning this JavaScript data:
>
> ( { "copyright&quot;:"Copyright (c) 2013 QuoteMedia, Inc.", "symbolcount&quot;:1,
> "quotedata&quot;:[ { "symbol":"AGF2107&quot;, "datatype";:"mutual fund",
> "entitlement&quot;:"EOD", "delaymin";:null,
> "datetime";:"2013-01-17T20:00:00-05:00", "pricedata&quot;:{ "last":"15.81",
> "change":"0.11", "changepercent":"0.700637", "sharevolume&quot;:"0" } } ] } );
>
> So items out of that can be extracted.
>
> But I don't see any of the additional items you mention shown there, and if
> I remember correctly, the main page was dynamically displayed, so the data
> couldn't be extracted there either.
>
> If the data you want is available elsewhere, I'm not aware of it.
>
> Hmmm. Took another look. Raw data appears to be here:
>
> http://app.quotemedia.com/quotetools/fundataModule.go?overviewChartLink=off&ents=wmonly&showCommas=true&toolWidth=740&webmasterId=101020&chgrd=D8DCE5&;chbdr=D8DCE5&amp;chfill2=6d9641&chfill=cc6d9641&amp;chln=313942&chaaon=true&cp=off&symbol=AGF2107&amp;hiddenTabs=topnav&action=showDetailedQuote&targetURL=http://tmx.quotemedia.com/funds-ca-quote.php&locale=en
>
> ...so you could extract it from there. For example, if that URL is in cell
> C2:
>
> =smfGetTagContent($C$2,"div",1,"Type:")
> =0+smfGetTagContent($C$2,"div",1,"High:")
>
> On Fri, Jan 18, 2013 at 8:23 AM, iamruf <iamruf@...> wrote:
>
> > Hi Randy,
> > The formula at the bottom is getting prices although I don`t understand
> > how it works.
> > Is it possible to adapt the formula to get other data on this page.
> > Fund Type: Global Equity
> > 52 Week High: 16.05
> > 52 Week Low: 14.34
> > YTD Return (as of December 31, 2012): 11.69%
> > Load Type: Choice of Front or Back
> > MER: 2.94%
> > Eligiblity: RRSP
> > Who Should Invest
> > Consider this Fund if: the tax consequences of a mutual fund corporation
> > are more suitable to your investment program or that of your registered
> > plan; you want the growth potential of equity securities of foreign
> > companies; you're investing for the longer term; you tolerate medium risk;
> > with respect to Series T and Series V securities, you prefer monthly
> > distribution of capital.(This is a box varies in length)
> >
> > =RCHGetWebData("
> > http://tmx.quotemedia.com/json/getQuotesMini.json.php?jsoncallba\ck=jsonp1358089488792&symbols=AGF2107&amp;webmasterId=101020&_=1358089550952
> > ",1,1000)
> >
>

Fri Mar 15, 2013 8:35 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't see anything to extract on either of the URLs you're using.

On Fri, Mar 15, 2013 at 8:30 AM, iamruf <iamruf@yahoo.com> wrote:

> Hi Randy,
> I have been using these Web sites and formulas to extract data.
> They have stopped working.
> Can you please review?
> Thanks
>
> =RCHGetWebData("
> http://tmx.quotemedia.com/json/getQuotesMini.json.php?jsoncallba\ck=jsonp1358089488792&symbols=BIP101&amp;webmasterId=101020&_=1358089550952
> ",1,1000)
> =VALUE(MID(C2,FIND("last",C2)+7,5))
>
> and
>
>
> http://app.quotemedia.com/quotetools/fundataModule.go?overviewChartLink=off&ents=wmonly&showCommas=true&toolWidth=740&webmasterId=101020&chgrd=D8DCE5&;chbdr=D8DCE5&amp;chfill2=6d9641&chfill=cc6d9641&amp;chln=313942&chaaon=true&cp=off&symbol=BIP101&amp;hiddenTabs=topnav&action=showDetailedQuote&targetURL=http://tmx.quotemedia.com/funds-ca-quote.php&locale=en
> =smfGetTagContent(D2,"div",1,"Eligiblity:")
> =RCHGetTableCell(D2,0,"This Fund")
>

Fri Mar 15, 2013 9:19 am (PDT) . Posted by:

"iamruf" iamruf

Hi Randy,
Yes, you found these two URL's for me back on Jan 18 (working then).
Have they been changed?
Thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I don't see anything to extract on either of the URLs you're using.
>
> On Fri, Mar 15, 2013 at 8:30 AM, iamruf <iamruf@...> wrote:
>
> > Hi Randy,
> > I have been using these Web sites and formulas to extract data.
> > They have stopped working.
> > Can you please review?
> > Thanks
> >
> > =RCHGetWebData("
> > http://tmx.quotemedia.com/json/getQuotesMini.json.php?jsoncallba\ck=jsonp1358089488792&symbols=BIP101&amp;webmasterId=101020&_=1358089550952
> > ",1,1000)
> > =VALUE(MID(C2,FIND("last",C2)+7,5))
> >
> > and
> >
> >
> > http://app.quotemedia.com/quotetools/fundataModule.go?overviewChartLink=off&ents=wmonly&showCommas=true&toolWidth=740&webmasterId=101020&chgrd=D8DCE5&;chbdr=D8DCE5&amp;chfill2=6d9641&chfill=cc6d9641&amp;chln=313942&chaaon=true&cp=off&symbol=BIP101&amp;hiddenTabs=topnav&action=showDetailedQuote&targetURL=http://tmx.quotemedia.com/funds-ca-quote.php&locale=en
> > =smfGetTagContent(D2,"div",1,"Eligiblity:")
> > =RCHGetTableCell(D2,0,"This Fund")
> >
>

Fri Mar 15, 2013 9:26 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Apparently. I no longer have the info on what you were trying to extract,
and from where.

On Fri, Mar 15, 2013 at 9:19 AM, iamruf <iamruf@yahoo.com> wrote:

>
> Yes, you found these two URL's for me back on Jan 18 (working then).
> Have they been changed?
>

Fri Mar 15, 2013 10:14 am (PDT) . Posted by:

"weekeewawa" weekeewawa

hi,

when i was entering the formula below
=RCHGetYahooHistory("IBM",2007,1,3,2008,1,3,w,"DOHLCVA&quot;,0)

i have encountered a #VALUE# error, is there any problem with it?

also,

in the formula, what should be input in the ''IBM&#39;' column to point it to a specific cell, eg, Cell A1

lastly, in the syntax,

what exactly is [Header Line] and [Resort]

thanks

Fri Mar 15, 2013 1:10 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Unless w is a named range, it is what is causing your problem. Otherwise,
It needs to be a string literal, with double quotes around it.

Did you check the documentation on the function for those other parameters?

To point to a cell, you do just like you would in any other function. Just
use the cell reference in place of the literal.

On Fri, Mar 15, 2013 at 10:14 AM, weekeewawa <weekeewawa@yahoo.com> wrote:

>
> when i was entering the formula below
> =RCHGetYahooHistory("IBM",2007,1,3,2008,1,3,w,"DOHLCVA&quot;,0)
>
> i have encountered a #VALUE# error, is there any problem with it?
>
> also,
>
> in the formula, what should be input in the ''IBM&#39;' column to point it to
> a specific cell, eg, Cell A1
>
> lastly, in the syntax,
>
> what exactly is [Header Line] and [Resort]
>

Fri Mar 15, 2013 11:40 am (PDT) . Posted by:

"Mark" mballard34a

Hi,

None of the Morningstar elements that I use are retrieving data, for example, =RCHGetElementNumber(Ticker,881)which normally grabs the Growth Grade or =RCHGetElementNumber(Ticker,877)which normally grabs the Industry name.

I am just getting "Error" in the cell.

I looked to see if there was an update in the Work In Progress folder and didn't see one. I also note that there are issues with the RCHGet TableCell functions that use the Morningstar Quicktake pages (I've updated my spreadsheet for the new Template that was uploaded recently.

Any thoughts?

I have my Premium Morningstar subscription open in an IE window and am logged in - and that IE has the security setting at the level that accepts all cookies.

Thanks!

mb

Fri Mar 15, 2013 1:14 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Did you log in BEFORE you used the function? Otherwise, you'll still have
the pre-login web page stored in the add-in. You'd need to use the
smfForceRecalculation macro to purge the saved web page and get a new one.
See the LINKS area of the group for more info on that macro.

Another possibility is that EXCEL uses a different version of IE than the
one you use as a browser. It's one reason I suggest people log in using the
EXCEL Web Query dialog instead of with their browser.

On Fri, Mar 15, 2013 at 11:40 AM, Mark <ballard@bankchampaign.com> wrote:

>
> None of the Morningstar elements that I use are retrieving data, for
> example, =RCHGetElementNumber(Ticker,881)which normally grabs the Growth
> Grade or =RCHGetElementNumber(Ticker,877)which normally grabs the Industry
> name.
>
> I am just getting "Error" in the cell.
>
> I looked to see if there was an update in the Work In Progress folder and
> didn't see one. I also note that there are issues with the RCHGet
> TableCell functions that use the Morningstar Quicktake pages (I've updated
> my spreadsheet for the new Template that was uploaded recently.
>
> Any thoughts?
>
> I have my Premium Morningstar subscription open in an IE window and am
> logged in - and that IE has the security setting at the level that accepts
> all cookies.
>

Tidak ada komentar:

Posting Komentar