Minggu, 25 Maret 2012

[smf_addin] Digest Number 2156

Messages In This Digest (9 Messages)

Messages

1a.

Re: How do you reinstall the add in?

Posted by: "nlavery" toby.avery@gmail.com   nlavery

Sat Mar 24, 2012 4:16 am (PDT)





Completely removing all old copies of the SMF .xla add-in and then downloading and installing a new copy worked for me after trying everything else. Apparently with just re-installing, Excel got confused and locked on on an older version of the add-in.

Toby

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> wrote:
>
> > **
> >
> > Many thanks, but unfortunately that doesn't solve the problem. Do you have
> > any other ideas?
> > ------------------------------
> > *From: * Randy Harmelink <rharmelink@...>
> > *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@...> 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 (5)
2a.

smfGetCSVFile function loads csv file header line only

Posted by: "ajhosking" andrew.hosking@bankofamerica.com   ajhosking

Sat Mar 24, 2012 5:01 am (PDT)




Randy, I'm having trouble loading a csv file into an array using the
smfGetCSVFile function.

I'm trying to access historical price information from the
tradingroom.com.au site and the smfGetCSVFile works for most symbols on
the site, but there are certain symbols where the function will return
the header line but not the rest of the file.

An example of this is for the QUB ticker and the code I'm using is:

vdata =
smfGetCSVFile("http://www.tradingroom.com.au/apps/qt/csv/pricehistory.ac\
?section=yearly_price_download&code=QUB", ",", 265, 7)

I can open the file fine in excel by either downloading it or doing a
data import from the web directly using the url and in notepad it looks
like a regular csv file.

Any thoughts?

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

Re: smfGetCSVFile function loads csv file header line only

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

Sat Mar 24, 2012 6:25 am (PDT)



Not sure what to tell you.

I just cut and pasted your code directly into a VBA module and it worked
fine for me -- the vData array contained 254 rows of actual data, with the
remaining rows left blank.

Could it be an issue with the site? For example, recently I've gotten empty
responses from Yahoo for RCHGetYahooHistory(). I know it's not an add-in
issue, because I've also gotten it in my browser from time to time. It will
tell me there is no history for a ticker, but if I refresh the web page in
the browser, data shows up. So it could be that Yahoo has one or two
servers that don't have the data.

On Sat, Mar 24, 2012 at 5:01 AM, ajhosking <andrew.hosking@bankofamerica.com
> wrote:

>
> Randy, I'm having trouble loading a csv file into an array using the
> smfGetCSVFile function.
>
> I'm trying to access historical price information from the
> tradingroom.com.au site and the smfGetCSVFile works for most symbols on
> the site, but there are certain symbols where the function will return the
> header line but not the rest of the file.
>
> An example of this is for the QUB ticker and the code I'm using is:
>
> vdata = smfGetCSVFile("
> http://www.tradingroom.com.au/apps/qt/csv/pricehistory.ac?section=yearly_price_download&code=QUB",
> ",", 265, 7)
>
> I can open the file fine in excel by either downloading it or doing a data
> import from the web directly using the url and in notepad it looks like a
> regular csv file.
>
> Any thoughts?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3.

Trouble loading a file into an array using the smfGetCSVFile functio

Posted by: "ajhosking" andrew.hosking@bankofamerica.com   ajhosking

Sat Mar 24, 2012 7:47 am (PDT)



I had posted a message earlier toady regrading a challenge loading a file into an array using the smfGetCSVFile function on the tradingroom.com.au site.

It's not posted yet and I have additional information to add before you take a look at it. It appears to be an intermitant issue. I have also used the smfforacerecalculation function as well to reset the data array, but this doesn't appear to resolve the issue.

I notice that the smfGetCSVFile function uses the RCHGetURLData1 function to retrieve the data and that there are no fnwait or .busy or readystate checks in this function. It is possible this is a timing issue(given the url is in Australia and not as swift as sites like Yahoo!)? And if so what could I do to circumvent this?

Thank you and like so many others you have created a wonderful toolset.

Andrew

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

bye bye smartmoney

Posted by: "B B" kokdari82@yahoo.com   kokdari82

Sat Mar 24, 2012 11:39 am (PDT)



the new changes to the website has eliminated 10 years of financials. They now only offer 5 years. Another one bites the dust.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
5a.

HardCoat cell that has formula once the formula returns a value if c

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

Sat Mar 24, 2012 1:53 pm (PDT)



I have a question regarding the SMFAddin. An example of my spreadsheet is in the "attachments" area with the file name "Hard Coat Stock Price Trial1.xlsx".

I currently have the example spreadsheet set up to retrieve stock prices using the SMFaddin formula, but......I am looking for a way, adding to my formula or using a macro, to be able to hard coat those same cells that return a stock price (after they calculate and return a price) if today's date is greater than the dates that stock prices are retrieved.

I have the smfaddin formula set up so that it prevents it from running and retrieving stock prices for dates that are greater than today's date(since only 1000 retrievals can be run at once, and errors will occur trying to retrieve stock prices on days that have not yet occurred), by simply using an IF statement. But I can't figure out how to hard coat the prior days stock prices, without having to do it manually for every day of the year.

For this process to work, do I have to use a macro? If so, can anyone tell me what the VBA code would look like to accomplish such a task?

Also, is there a way to raise the 1,000 retrieval limit?

Thanks in advance.

Rob

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

Re: HardCoat cell that has formula once the formula returns a value

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

Sat Mar 24, 2012 2:01 pm (PDT)



I don't see the example spreadsheet.

The 1000-web page limit will not be raised. For the type of thing it sounds
like you are doing, you should be using a different tool. For example,
StockFetcher or StockScreen123. The add-in is NOT intended for database
building and large-scale screening of stocks. It's meant for ad hoc data
analysis. You should be using other methods to winnow down the number of
stocks you are looking at, before burdening the free data sources with data
requests. As we've seen from MorningStar, it's simply enough for them to
make the add-in unable to retrieve data.

On Sat, Mar 24, 2012 at 1:53 PM, rb_luther <rb_luther@yahoo.com> wrote:

> I have a question regarding the SMFAddin. An example of my spreadsheet is
> in the "attachments" area with the file name "Hard Coat Stock Price
> Trial1.xlsx".
>
> I currently have the example spreadsheet set up to retrieve stock prices
> using the SMFaddin formula, but......I am looking for a way, adding to my
> formula or using a macro, to be able to hard coat those same cells that
> return a stock price (after they calculate and return a price) if today's
> date is greater than the dates that stock prices are retrieved.
>
> I have the smfaddin formula set up so that it prevents it from running and
> retrieving stock prices for dates that are greater than today's date(since
> only 1000 retrievals can be run at once, and errors will occur trying to
> retrieve stock prices on days that have not yet occurred), by simply using
> an IF statement. But I can't figure out how to hard coat the prior days
> stock prices, without having to do it manually for every day of the year.
>
> For this process to work, do I have to use a macro? If so, can anyone tell
> me what the VBA code would look like to accomplish such a task?
>
> Also, is there a way to raise the 1,000 retrieval limit?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
5c.

Re: HardCoat cell that has formula once the formula returns a value

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

Sat Mar 24, 2012 2:06 pm (PDT)



Your file just showed up. Oh my goodness, WHY are you retrieving
historical data one day at a time?

On Sat, Mar 24, 2012 at 1:53 PM, rb_luther <rb_luther@yahoo.com> wrote:

> I have a question regarding the SMFAddin. An example of my spreadsheet is
> in the "attachments" area with the file name "Hard Coat Stock Price
> Trial1.xlsx".
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
6.1.

New file uploaded to smf_addin

Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com

Sat Mar 24, 2012 1:56 pm (PDT)




Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/HardCoat Stock Price Formula Trial1.xlsm
Uploaded by : rb_luther <rb_luther@yahoo.com>
Description : Help Needed. See post with the title: HardCoat cell that has formula once the formula returns a value if criteria met

You can access this file at the URL:
http://groups.yahoo.com/group/smf_addin/files/Uploads%20by%20forum%20members/HardCoat%20Stock%20Price%20Formula%20Trial1.xlsm

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,

rb_luther <rb_luther@yahoo.com>


Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (248)
Recent Activity
Visit Your Group
Yahoo! News

Odd News

You won't believe

it, but it's true

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 01.43

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)