Selasa, 17 April 2012

[smf_addin] Digest Number 2179

Messages In This Digest (19 Messages)

Messages

1a.

Re: Database

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

Mon Apr 16, 2012 7:12 am (PDT)



For the database, I need to be able to store (1) total return price (OHLC) and (2) price only (OHLC) for monthly data only. Currently I have 5 years whole of data for about 5,000 mutual funds and ETFs. The data will grow on a monthly basis since it uses only monthly data.

If you got something that could help me, I'd like to take a look at it, and hopefully simply my life.

--- In smf_addin@yahoogroups.com, "juranek54" <chad.juranek@...> wrote:
>
> Its not difficult to link excel and access. I do it constantly and they are the two are powerful together. What you need to be concerned about is the problem down the line. How much data are you trying to store and analayze and how fast will that data size grow? Access is a great tool and I use it every day, however, depending on potential data size you might want to consider all options like a SQL server if you are looking at massive data sizes into the future. Access by itself can be limiting.
>
> --- In smf_addin@yahoogroups.com, "lexstar" <lexstar@> wrote:
> >
> > I think I have too much data in my Excel database, and I'm wondering if anyone could help me. I'm wondering if it would be wise to transfer the database into MS Access, and then query those data from Excel to do my analysis (is this even possible? if so, how difficult is it?)
> >
> > If anyone has any ideas, please I need help. Thanks in advance!
> >
>

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

Anyone have problems getting the AdvFN financial statements data?

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

Mon Apr 16, 2012 9:18 am (PDT)



It doesn't seem to work from my end...

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

Re: Anyone have problems getting the AdvFN financial statements data

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

Mon Apr 16, 2012 9:23 am (PDT)



Have you tried the "fix" mentioned in the "Links" area of the group?

On Mon, Apr 16, 2012 at 7:41 AM, vallarinoanalytics <
vallarinoanalytics@yahoo.com> wrote:

> It doesn't seem to work from my end...
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2c.

Re: Anyone have problems getting the AdvFN financial statements data

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

Mon Apr 16, 2012 1:09 pm (PDT)



Hi, Thanks for responding. I'm not sure which fix you are referring to. The Advfn data was working fine until about a week ago when nothing but error would come up. I do not believe I touched anything on my computer. Thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Have you tried the "fix" mentioned in the "Links" area of the group?
>
> On Mon, Apr 16, 2012 at 7:41 AM, vallarinoanalytics <
> vallarinoanalytics@...> wrote:
>
> > It doesn't seem to work from my end...
> >
>

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

Re: Anyone have problems getting the AdvFN financial statements data

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

Mon Apr 16, 2012 1:38 pm (PDT)



If you go to the "Links" area of the Yahoo group, you'll find an item on
AdvFN. It has a fix for something a "Windows Update" causes.

On Mon, Apr 16, 2012 at 1:09 PM, vallarinoanalytics <
vallarinoanalytics@yahoo.com> wrote:

> Hi, Thanks for responding. I'm not sure which fix you are referring to.
> The Advfn data was working fine until about a week ago when nothing but
> error would come up. I do not believe I touched anything on my computer.
> Thanks
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3a.

Unable to get the SMF_addin to work on PC

Posted by: "kmc" pinkyinnj@gmail.com   pinkyinnj

Mon Apr 16, 2012 9:18 am (PDT)



Hi
I've triend on one PC and one Latop to get add-in to work. Both computers are Dells and have Window7.

Any suggestions are welcomed.

Thank you

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

Re: Unable to get the SMF_addin to work on PC

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

Mon Apr 16, 2012 9:25 am (PDT)



As I mention in the front page of the group, I'm not a mind reader. A
problem description of "It doesn't work" gives me no way to help you.

What do you get from this formula:

=RCHGetElementNumber("Version")

On Mon, Apr 16, 2012 at 6:31 AM, kmc <pinkyinnj@gmail.com> wrote:

> I've triend on one PC and one Latop to get add-in to work. Both computers
> are Dells and have Window7.
>
> Any suggestions are welcomed.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

Yahoo real time prices

Posted by: "ken_jarrad" ken.jarrad@usa.net   ken_jarrad

Mon Apr 16, 2012 9:19 am (PDT)



Is anyone able to confirm that real time price fields are working?

e.g. http://finance.yahoo.com/d?s=MSFT&f=k1

I am getting "N/A" in the response.

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

Re: Yahoo real time prices

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

Mon Apr 16, 2012 9:27 am (PDT)



If you're getting "N/A", then the add-in is working. It's just that "N/A"
is what Yahoo is sending as the value.

On Mon, Apr 16, 2012 at 4:57 AM, ken_jarrad <ken.jarrad@usa.net> wrote:

> Is anyone able to confirm that real time price fields are working?
>
> e.g. http://finance.yahoo.com/d?s=MSFT&f=k1
>
> I am getting "N/A" in the response.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5a.

msn last 10 year eps rchelement #'s 333...342 I get an error message

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

Mon Apr 16, 2012 9:59 am (PDT)



I am using =RCHGetElementNumber($B$2,333), element #'s 333 thru 342 to get the last 10 years eps for a stock.

I keep getting an "error" message in excel. Do I need to do any addin updating?

Randy, what am I doing wrong.

Also, is there any element numbers for the last few 5 years of dividends or payout?

Thanks,

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

Re: msn last 10 year eps rchelement #'s 333...342 I get an error mes

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

Mon Apr 16, 2012 10:03 am (PDT)



I just tried the template from the files area of the group. Those element
numbers worked fine here for ticker symbol MMM. You may need to update --
MSN has changed their URL structure twice in the last few years, so I've
had to redefine the element definitions.

You can use RCHGetYahooHistory() to get the history of dividend payments.

On Mon, Apr 16, 2012 at 9:59 AM, rr76012 <rr76012@yahoo.com> wrote:

> I am using =RCHGetElementNumber($B$2,333), element #'s 333 thru 342 to get
> the last 10 years eps for a stock.
>
> I keep getting an "error" message in excel. Do I need to do any addin
> updating?
>
> Randy, what am I doing wrong.
>
> Also, is there any element numbers for the last few 5 years of dividends
> or payout?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
5c.

Re: msn last 10 year eps rchelement #'s 333...342 I get an error mes

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

Mon Apr 16, 2012 3:40 pm (PDT)



Hello Randy,

I looked at several templates with the name msn in it and did not see any examples of the eps numbers?

What template file are you referring to for the last 10 years eps??

Thank you.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I just tried the template from the files area of the group. Those element
> numbers worked fine here for ticker symbol MMM. You may need to update --
> MSN has changed their URL structure twice in the last few years, so I've
> had to redefine the element definitions.
>
> You can use RCHGetYahooHistory() to get the history of dividend payments.
>
> On Mon, Apr 16, 2012 at 9:59 AM, rr76012 <rr76012@...> wrote:
>
> > I am using =RCHGetElementNumber($B$2,333), element #'s 333 thru 342 to get
> > the last 10 years eps for a stock.
> >
> > I keep getting an "error" message in excel. Do I need to do any addin
> > updating?
> >
> > Randy, what am I doing wrong.
> >
> > Also, is there any element numbers for the last few 5 years of dividends
> > or payout?
> >
>

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

Re: msn last 10 year eps rchelement #'s 333...342 I get an error mes

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

Mon Apr 16, 2012 3:48 pm (PDT)



SMF-Template-MSN-10-Year-Summaries.xls

On Mon, Apr 16, 2012 at 3:40 PM, rr76012 <rr76012@yahoo.com> wrote:

>
> I looked at several templates with the name msn in it and did not see any
> examples of the eps numbers?
>
> What template file are you referring to for the last 10 years eps??
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
6a.

=RCHGetElementNumber($B$2,3523) etc.. are getting error messages

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

Mon Apr 16, 2012 10:19 am (PDT)



Hello Randy,

FYI,

=RCHGetElementNumber($B$2,3522) & =RCHGetElementNumber($B$2,3523)

and

=RCHGetElementNumber($B$2,337) thru =RCHGetElementNumber($B$2,342)

are getting error messages?

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

Re: =RCHGetElementNumber($B$2,3523) etc.. are getting error messages

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

Mon Apr 16, 2012 10:27 am (PDT)



On Mon, Apr 16, 2012 at 10:19 AM, rr76012 <rr76012@yahoo.com> wrote:

>
> =RCHGetElementNumber($B$2,3522) & =RCHGetElementNumber($B$2,3523)
>

No big surprise. Google now only displays 4 annual periods of information.

> =RCHGetElementNumber($B$2,337) thru =RCHGetElementNumber($B$2,342)
>
> are getting error messages?
>

These are working fine for me. You may need the latest update of element
definitions. MSN changed their URL structure at the start of the year.
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
7a.

Re: "Earnings" source not working?

Posted by: "enomisdue" enomisdue@yahoo.it   enomisdue

Mon Apr 16, 2012 10:21 am (PDT)



Hi all,

unfortunately i have the same problem, but in my case i already have all the txt files, i can't go over it and i'm getting crazy.

txt files i have are, 0,1,2,3,4,5,6,7,8,9,info
have i missed someone?

tnx

--- In smf_addin@yahoogroups.com, "mahluwa" <mahluwa@...> wrote:
>
> Oh yes, that was the problem. A couple of TXT files were not present. Looks like I might have messed up while unzip'ing. Manually copied again and it works now.
>
> Thanks for your help
>
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Sounds like you didn't unzip all of the files in the archives along with
> > the XLA file. The TXT files contain the element definitions. If they aren't
> > in the same folder as the XLA file, none of the elements will be defined.
> >
> > On Tue, Apr 3, 2012 at 3:32 PM, mahluwa <mahluwa@> wrote:
> >
> > >
> > > RCHGetElementNumber is returning "Undefined" for all items from source:
> > > Earnings (1286 onwards). Is this broken?
> > >
> >
>

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

Re: "Earnings" source not working?

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

Mon Apr 16, 2012 10:31 am (PDT)



Did you add the TXT files after you had already started EXCEL? They need to
exist before you use the first add-in formula. Adding them after that
doesn't get change anything. You'd need to exit and restart EXCEL or run
the smfForceRecalculation macro to reload the definition files.

On Mon, Apr 16, 2012 at 10:20 AM, enomisdue <enomisdue@yahoo.it> wrote:

> Hi all,
>
> unfortunately i have the same problem, but in my case i already have all
> the txt files, i can't go over it and i'm getting crazy.
>
> txt files i have are, 0,1,2,3,4,5,6,7,8,9,info
> have i missed someone?
>
> tnx
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
8a.

Trouble with Windows 7 and the file path

Posted by: "kmc" pinkyinnj@gmail.com   pinkyinnj

Mon Apr 16, 2012 11:40 am (PDT)



Hi,
I have tried so many different ways to get the excel spreadsheet and the SMF Add-in to work and I have not been successful. I think the problem is with Window 7 the file folders are set with default of:

computer > Local Disk (c:) > Program FIles > SMF Add-in.

I am unable to change the default file name without computer > Local Disk at he beginning of the new file path name.

I have reached out to the Yahoo message board and I have read prior posts and still no success. What suggestions do you have? I don't have any Excel Marco programing skills.

Thank you in advance for your help.

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

Re: Trouble with Windows 7 and the file path

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

Mon Apr 16, 2012 11:54 am (PDT)



I have no experience with Windows 7. But I find it hard to believe the file
structure is that different. If it were, nothing would be backward
compatible. Where are you seeing that path name?

On Mon, Apr 16, 2012 at 11:39 AM, kmc <pinkyinnj@gmail.com> wrote:

>
> I have tried so many different ways to get the excel spreadsheet and the
> SMF Add-in to work and I have not been successful. I think the problem is
> with Window 7 the file folders are set with default of:
>
> computer > Local Disk (c:) > Program FIles > SMF Add-in.
>
> I am unable to change the default file name without computer > Local Disk
> at he beginning of the new file path name.
>
> I have reached out to the Yahoo message board and I have read prior posts
> and still no success. What suggestions do you have? I don't have any Excel
> Marco programing skills.
>
> Thank you in advance for your help.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

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.28

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)