Messages In This Digest (3 Messages)
- 1a.
- Re: Excel Hanging, [1 Attachment] From: codyklein
- 2a.
- PnF charts - using percentage instead of the traditional box From: Joel
- 2b.
- Re: PnF charts - using percentage instead of the traditional box From: Randy Harmelink
Messages
- 1a.
-
Re: Excel Hanging, [1 Attachment]
Posted by: "codyklein" codyklein@alum.drexel.edu codyklein
Wed Aug 24, 2011 3:10 pm (PDT)
Not sure if this will help but I noticed the following when excel hangs. When I use the command "ping yahoo.com -t" and let it run a few minutes (I stop it by hitting Ctrl c) the timeouts (packet loss?) is always over 3% when excel hangs. I'm talking about larger spreadsheets. When the packet loss is close to 0 the addin works great and never hangs. I assume this is just internet congestion. I've checked everytime the program hangs and the packet loss is always up. I'm sure there are other reasons but this is definitely one of them.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I don't think the workbook is hanging. It's just taking a LONG time to get
> data from Morningstar. One symbol took me 20 seconds. So 57 could take about
> 19 minutes. I was getting such a slow response even when I used the links in
> my browser. As I noted, probably due to their computer problems today.
> Usually, Morningstar would take under a second.
>
> If you have paths in front of your formulas, then the add-in links are not
> being resolved properly. You need to fix them manually (usually just once,
> since the updates will be saved when you save the file) -- see the "Links"
> area of the group for more info.
>
> I am also confused by your statement of "reopening the add-in". At no point
> should you be opening it. You install it with the add-in manager. If you
> don't have it installed with the add-in manager, that would probably explain
> the unresolved links.
>
> On Tue, Aug 23, 2011 at 8:48 PM, Keys Tinney <keystin@...> wrote:
>
> >
> > I can’t figure it out. When I saved and then reopened it changed the
> > formulas like this “=RCHGetElementNumber(F1,4811)†were replaced with
> > “='C:\Program Files\SMF
> > Add-in\RCH_Stock_Market_Functions .xla'!RCHGetElem entNumber( F1,4811)â€
> >
> > ** **
> >
> > I had to open Excel in safe mode to get the file to open, then I recreated
> > the sheet by changing all formulas back to the original and reopening the
> > add-in in the data menu.****
> >
> > ** **
> >
> > After all that, I saved it again and then tried to reopen and it kept
> > hanging. Any ideas? See attached
> >
>
- 2a.
-
PnF charts - using percentage instead of the traditional box
Posted by: "Joel" joel.andrews@lpl.com joelfp2000
Wed Aug 24, 2011 8:22 pm (PDT)
Randy,
Is there anyway in my formula to chnge the graph from a "traditional" scaling method to a "percentage" scaling method?
Here is a sample of my formula.
=rchcreatecomment("http://stockcharts. com/def/servlet/ [pa!b20][d][SharpChartv05. ServletDriver? chart=rsp, pmtbdanrbo f1!3!!!2! 20]&pnf=y" ,99,,,1)
Thanks,
Joel
- 2b.
-
Re: PnF charts - using percentage instead of the traditional box
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Aug 24, 2011 8:29 pm (PDT)
Go to their website, set your parameters, and then use the URL of the image
(not the web page the image is displayed on).
On Wed, Aug 24, 2011 at 8:22 PM, Joel <joel.andrews@lpl.com > wrote:
> Is there anyway in my formula to chnge the graph from a "traditional"
> scaling method to a "percentage" scaling method?
>
> Here is a sample of my formula.
>
> =rchcreatecomment("
> http://stockcharts.com/def/servlet/ [pa!b20][d][SharpChartv05. ServletDriver? chart=rsp, pmtbdanrbo f1!3!!!2! 20]&pnf=y
> ",99,,,1)
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar