Messages In This Digest (13 Messages)

1a.: Re: How do you reinstall the add in? From: liquorishallsorts@yahoo.co.uk
1b.: Re: How do you reinstall the add in? From: Randy Harmelink

2a.: Bllomberg...again! From: bushpilote@yahoo.ca
2b.: Re: Bllomberg...again! From: Randy Harmelink

3a.: Spread Sheet locking up From: broberts1745
3b.: Re: Spread Sheet locking up From: Randy Harmelink

4a.: Upgrading to real-time quotes From: thomas91112
4b.: Re: Upgrading to real-time quotes From: Randy Harmelink
4c.: Re: Upgrading to real-time quotes From: Michael Thomas
4d.: Re: Upgrading to real-time quotes From: Randy Harmelink

5a.: elementNumber documentation From: allencherril@sbcglobal.net
5b.: Re: elementNumber documentation From: Randy Harmelink
5c.: Re: elementNumber documentation From: sudhir agarwal

View All Topics | Create New Topic

Messages

1a.: Re: How do you reinstall the add in?

Posted by: "liquorishallsorts@yahoo.co.uk" liquorishallsorts@yahoo.co.uk liquorishallsorts

Fri Mar 23, 2012 2:49 am (PDT)

Many thanks, but unfortunately that doesn't solve the problem. Do you have any other ideas?

-----Original Message-----
From: Randy Harmelink <rharmelink@gmail.com>
Sender: smf_addin@yahoogroups.com
Date: Thu, 22 Mar 2012 09:25:40
To: <smf_addin@yahoogroups.com>
Reply-To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] How do you reinstall the add in?

Try this process, which has cleared up some issues for others in the past:

1. Go to the add-in manager and uncheck the add-in.
2. Exit EXCEL (which should remove any references to the add-in from the
registry)
3. Restart EXCEL
4. Go to the add-in manager and put the add-in back into the list
5. Exit EXCEL (to save the new settings)
6. Restart EXCEL

On Thu, Mar 22, 2012 at 9:09 AM, liquorishallsorts <
liquorishallsorts@yahoo.co.uk> wrote:

> I successfully installed the add in (in Excel 2007) but it has now stopped
> working. When I re-open the spreadsheet I get a message saying Excel found
> unreadable content, and then that it was able to open the file by removing
> the following:
>
> Removed Feature: External formula reference from
> /xl/externalLinks/externalLink1.xml part (Cached values from external
> formula reference)
> Removed Records: Formula from /xl/worksheets/sheet1.xml part
> Removed Records: Formula from /xl/calcChain.xml part (Calculation
> properties)
>
> If I input =RCHGetYahooQuotes("ABF.L",l1,"uk") in a cell in a new
> spreadsheet, then after closing and reopening it, it is replaced with
> ='C:\Users\Myusername\AppData\Local\Microsoft\Windows\Temporary Internet
> Files\Content.IE5\M9633UGU\RCH_Stock_Market_Functions[1].xla'!rchgetyahooquotes("abf.l",L1,"uk")
> and the cell is empty.
>
> I think the add in may have got corrupted (by deleting temporary internet
> files maybe?) but I can't see how to remove it to re-install it.
>
> Any help appreciated.
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
1b.: Re: How do you reinstall the add in?

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Fri Mar 23, 2012 9:00 am (PDT)

It didn't solve the problem on a NEW workbook, or with the old? If the old
is corrupted, changing the add-in won't fix the workbook.

If the add-in itself is corrupted, you should delete all the files and
replace them, in between steps (2) and (3).

Note that the reference to Temporary Internet Files will not be fixed by
anything we do -- it is a hard-copied location within the saved workbook.
It can only be fixed manually -- see the "Location Errors" entry in the
"Links" area of the group.

On Fri, Mar 23, 2012 at 2:49 AM, <liquorishallsorts@yahoo.co.uk> wrote:

> **
>
> Many thanks, but unfortunately that doesn't solve the problem. Do you have
> any other ideas?
> ------------------------------
> *From: * Randy Harmelink <rharmelink@gmail.com>
> *Sender: * smf_addin@yahoogroups.com
> *Date: *Thu, 22 Mar 2012 09:25:40 -0700
> *To: *<smf_addin@yahoogroups.com>
> *ReplyTo: * smf_addin@yahoogroups.com
> *Subject: *Re: [smf_addin] How do you reinstall the add in?
>
>
>
> Try this process, which has cleared up some issues for others in the past:
>
> 1. Go to the add-in manager and uncheck the add-in.
> 2. Exit EXCEL (which should remove any references to the add-in from
> the registry)
> 3. Restart EXCEL
> 4. Go to the add-in manager and put the add-in back into the list
> 5. Exit EXCEL (to save the new settings)
> 6. Restart EXCEL
>
> On Thu, Mar 22, 2012 at 9:09 AM, liquorishallsorts <
> liquorishallsorts@yahoo.co.uk> wrote:
>
>> I successfully installed the add in (in Excel 2007) but it has now
>> stopped working. When I re-open the spreadsheet I get a message saying
>> Excel found unreadable content, and then that it was able to open the file
>> by removing the following:
>>
>> Removed Feature: External formula reference from
>> /xl/externalLinks/externalLink1.xml part (Cached values from external
>> formula reference)
>> Removed Records: Formula from /xl/worksheets/sheet1.xml part
>> Removed Records: Formula from /xl/calcChain.xml part (Calculation
>> properties)
>>
>> If I input =RCHGetYahooQuotes("ABF.L",l1,"uk") in a cell in a new
>> spreadsheet, then after closing and reopening it, it is replaced with
>> ='C:\Users\Myusername\AppData\Local\Microsoft\Windows\Temporary Internet
>> Files\Content.IE5\M9633UGU\RCH_Stock_Market_Functions[1].xla'!rchgetyahooquotes("abf.l",L1,"uk")
>> and the cell is empty.
>>
>> I think the add in may have got corrupted (by deleting temporary internet
>> files maybe?) but I can't see how to remove it to re-install it.
>>
>> Any help appreciated.
>>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

2a.: Bllomberg...again!

Posted by: "bushpilote@yahoo.ca" bushpilote@yahoo.ca bushpilote

Fri Mar 23, 2012 6:34 am (PDT)

Hi Randy,
I'd appreciate it if you would help me construct a formula to get the last price for ".TEDSP:IND". This has been covered before but the solution offered doesn't work anymore.

The following formula:=0+smfGetTagContent("http://www.bloomberg.com/quote/move:ind","span",1,">move:IND" gives me the last price for the MOVE Index and #VALUE! for ".TEDSP:IND".

The only explanation that I can up with for this is that the last price's element for each security on the Bloomberg site are different:
MOVE:IND = 
.TEDSP:IND = ,,,<\span>

If that's the case then how do I tweak the formula to get the last price for the TED spread?

Using the advanced mode from web in Excel 2007 will get me the last price and the daily change but I prefer working with your add-in.

Thanks.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.: Re: Bllomberg...again!

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Fri Mar 23, 2012 9:09 am (PDT)

The problem with .TEDSP:IND is that they have an orphaned tag within
the price span. That is, this:

=smfGetTagContent("http://www.bloomberg.com/quote/.tedsp:ind
","span",1,">.TEDSP:IND")

...returns this:

0.41 

So adding zero to that gives a #VALUE! error. But you can use SUBSTITUTE()
to remove the string:

=0+SUBSTITUTE(smfGetTagContent("http://www.bloomberg.com/quote/.tedsp:ind
","span",1,">.TEDSP:IND"),"","")

I don't know why they code the pages inconsistently.

On Fri, Mar 23, 2012 at 6:33 AM, <bushpilote@yahoo.ca> wrote:

>
> I'd appreciate it if you would help me construct a formula to get the last
> price for ".TEDSP:IND". This has been covered before but the solution
> offered doesn't work anymore.
>
> The following formula:=0+smfGetTagContent("
> http://www.bloomberg.com/quote/move:ind","span",1,">move:IND" gives me
> the last price for the MOVE Index and #VALUE! for ".TEDSP:IND".
>
> The only explanation that I can up with for this is that the last price's
> element for each security on the Bloomberg site are different:
> MOVE:IND = 
> .TEDSP:IND = ,,,<\span>
>
> If that's the case then how do I tweak the formula to get the last price
> for the TED spread?
>
> Using the advanced mode from web in Excel 2007 will get me the last price
> and the daily change but I prefer working with your add-in.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

3a.: Spread Sheet locking up

Posted by: "broberts1745" broberts1745@yahoo.com broberts1745

Fri Mar 23, 2012 10:21 am (PDT)

My excel spread sheet is getting locked up on certain names "calculating cells: 0%" never increasing and on the top of the excel title bar reads "(Not Responding)"

Is there a way to find out what is causing the spread sheet to lock-up?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.: Re: Spread Sheet locking up

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Fri Mar 23, 2012 11:31 am (PDT)

Sounds like you're retrieving too much data. How many formulas do you have?

Another possibility is that one of the web sites you're getting data from
is unavailable. Then, the add-in formulas need to "time out" for each new
web page.

On Fri, Mar 23, 2012 at 10:20 AM, broberts1745 <broberts1745@yahoo.com>wrote:

> My excel spread sheet is getting locked up on certain names "calculating
> cells: 0%" never increasing and on the top of the excel title bar reads
> "(Not Responding)"
>
> Is there a way to find out what is causing the spread sheet to lock-up?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

4a.: Upgrading to real-time quotes

Posted by: "thomas91112" thomas91112@yahoo.com thomas91112

Fri Mar 23, 2012 2:44 pm (PDT)

Have an SMF Excel spreadsheet with GetYahooQuotes that I would like to go with real-time quotes. Signed up for Yahoo Finance Market Tracker service (real-time quote product) but they don't say how to link it to an Excel file and SMF. Given your familiarity with Yahoo Finance and SMF, how do I go about making the link?

Thanks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4b.: Re: Upgrading to real-time quotes

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Fri Mar 23, 2012 3:32 pm (PDT)

As I understand it, you just need to log in and you get the real time
quotes instead of delayed quotes automatically. However, you must log in
with either the EXCEL Web Query process or with IE, as something like
FireFox will not create the proper security cookies for EXCEL and the
add-in.

On Fri, Mar 23, 2012 at 2:44 PM, thomas91112 <thomas91112@yahoo.com> wrote:

> Have an SMF Excel spreadsheet with GetYahooQuotes that I would like to go
> with real-time quotes. Signed up for Yahoo Finance Market Tracker service
> (real-time quote product) but they don't say how to link it to an Excel
> file and SMF. Given your familiarity with Yahoo Finance and SMF, how do I
> go about making the link?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4c.: Re: Upgrading to real-time quotes

Posted by: "Michael Thomas" thomas91112@yahoo.com thomas91112

Fri Mar 23, 2012 4:02 pm (PDT)

Web Query is asking for a URL - any ideas?

--- On Fri, 3/23/12, Randy Harmelink <rharmelink@gmail.com> wrote:

From: Randy Harmelink <rharmelink@gmail.com>
Subject: Re: [smf_addin] Upgrading to real-time quotes
To: smf_addin@yahoogroups.com
Date: Friday, March 23, 2012, 3:32 PM

As I understand it, you just need to log in and you get the real time quotes instead of delayed quotes automatically. However, you must log in with either the EXCEL Web Query process or with IE, as something like FireFox will not create the proper security cookies for EXCEL and the add-in.

On Fri, Mar 23, 2012 at 2:44 PM, thomas91112 <thomas91112@yahoo.com> wrote:

Have an SMF Excel spreadsheet with GetYahooQuotes that I would like to go with real-time quotes. Signed up for Yahoo Finance Market Tracker service (real-time quote product) but they don't say how to link it to an Excel file and SMF. Given your familiarity with Yahoo Finance and SMF, how do I go about making the link?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4d.: Re: Upgrading to real-time quotes

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Fri Mar 23, 2012 5:44 pm (PDT)

I don't have real-time quotes, so I don't know where you need to log in.

On Fri, Mar 23, 2012 at 4:02 PM, Michael Thomas <thomas91112@yahoo.com>wrote:

>
> Web Query is asking for a URL - any ideas?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

5a.: elementNumber documentation

Posted by: "allencherril@sbcglobal.net" allencherril@sbcglobal.net allencherril@sbcglobal.net

Fri Mar 23, 2012 5:50 pm (PDT)

Hello,

Is there any documentation which lists elementNumbers and their corresponding values? (For example, what are the elementNumbers corresponding to Current Liabilities, Total Liabilities, etc.?)

Sorry if this is a really basic question--I'm new to this group and the add-in, which is amazing by the way!

Thanks!

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
5b.: Re: elementNumber documentation

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Fri Mar 23, 2012 5:53 pm (PDT)

There was an XLS file in the ZIP archive you downloaded that has the
list...you can filter that list and search for things of interest.

On Fri, Mar 23, 2012 at 5:48 PM, allencherril@sbcglobal.net <
allencherril@sbcglobal.net> wrote:

> Is there any documentation which lists elementNumbers and their
> corresponding values? (For example, what are the elementNumbers
> corresponding to Current Liabilities, Total Liabilities, etc.?)
>
> Sorry if this is a really basic question--I'm new to this group and the
> add-in, which is amazing by the way!
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
5c.: Re: elementNumber documentation

Posted by: "sudhir agarwal" Agarwal.sudhir@gmail.com sudhir_agarwal1

Fri Mar 23, 2012 8:56 pm (PDT)

[Attachment(s) from sudhir agarwal included below]

Attached is the document you are looking for.
You will find thsi in the File section also.
Please visit the file section. Whenever the Addin is updated the document
is also updated so in future you should refer to that location.
Hope this helps.

Sudhir

On Fri, Mar 23, 2012 at 8:48 PM, allencherril@sbcglobal.net <
allencherril@sbcglobal.net> wrote:

> **
>
>
> Hello,
>
> Is there any documentation which lists elementNumbers and their
> corresponding values? (For example, what are the elementNumbers
> corresponding to Current Liabilities, Total Liabilities, etc.?)
>
> Sorry if this is a really basic question--I'm new to this group and the
> add-in, which is amazing by the way!
>
> Thanks!
>
>
>

Attachment(s) from sudhir agarwal

1 of 1 File(s)

Details of RCH Elements.xlsx

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

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

Sabtu, 24 Maret 2012

Messages In This Digest (13 Messages)

Messages

Posted by: "liquorishallsorts@yahoo.co.uk" liquorishallsorts@yahoo.co.uk liquorishallsorts

Fri Mar 23, 2012 2:49 am (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Fri Mar 23, 2012 9:00 am (PDT)

Posted by: "bushpilote@yahoo.ca" bushpilote@yahoo.ca bushpilote

Fri Mar 23, 2012 6:34 am (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Fri Mar 23, 2012 9:09 am (PDT)

Posted by: "broberts1745" broberts1745@yahoo.com broberts1745

Fri Mar 23, 2012 10:21 am (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Fri Mar 23, 2012 11:31 am (PDT)

Posted by: "thomas91112" thomas91112@yahoo.com thomas91112

Fri Mar 23, 2012 2:44 pm (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Fri Mar 23, 2012 3:32 pm (PDT)

Posted by: "Michael Thomas" thomas91112@yahoo.com thomas91112

Fri Mar 23, 2012 4:02 pm (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Fri Mar 23, 2012 5:44 pm (PDT)

Posted by: "allencherril@sbcglobal.net" allencherril@sbcglobal.net allencherril@sbcglobal.net

Fri Mar 23, 2012 5:50 pm (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Fri Mar 23, 2012 5:53 pm (PDT)

Posted by: "sudhir agarwal" Agarwal.sudhir@gmail.com sudhir_agarwal1

Fri Mar 23, 2012 8:56 pm (PDT)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me