Messages In This Digest (4 Messages)
- 1a.
- Database From: lexstar
- 1b.
- Re: Database From: dguillett1
- 2a.
- Re: Extracting Data for Multiple Companies From: craig
- 3.
- portfolio tracker integration? From: oyz79
Messages
- 1a.
-
Database
Posted by: "lexstar" lexstar@yahoo.com lexstar
Wed Dec 21, 2011 10:04 am (PST)
I was wondering if anyone could give me some suggestions. I want to download monthly data onto a database and then query the data I need to do any analysis I want.
I'm wondering if it is best to set that database as a separate WORKSHEET within the SAME WORKBOOK in Excel, or should it sit separately in a DIFFERENT WORKBOOK.
The database should be run once per day to get the end of day data.
Any suggestions would be appreciated.
Currently I have the database sit within the SAME WORKBOOK.
- 1b.
-
Re: Database
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Wed Dec 21, 2011 12:01 pm (PST)
I would do it the way you have it.
Don Guillett
SalesAid Software
dguillett1@gmail.com
From: lexstar
Sent: Wednesday, December 21, 2011 12:04 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Database
I was wondering if anyone could give me some suggestions. I want to download monthly data onto a database and then query the data I need to do any analysis I want.
I'm wondering if it is best to set that database as a separate WORKSHEET within the SAME WORKBOOK in Excel, or should it sit separately in a DIFFERENT WORKBOOK.
The database should be run once per day to get the end of day data.
Any suggestions would be appreciated.
Currently I have the database sit within the SAME WORKBOOK.
- 2a.
-
Re: Extracting Data for Multiple Companies
Posted by: "craig" craigmorris@yahoo.com craigmorris
Wed Dec 21, 2011 6:34 pm (PST)
Randy
THANK YOU, I got it to work. Really appreciated.
Craig
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Just do normal EXCEL string concatenation when creating the URL. For
> example:
>
> ="...string1..."&A1
> ="...string1..."&A1&". ..string2. .."
> =A1&"...string2..."
> =A1&"...string1..."&B1
>
> On Sun, Dec 18, 2011 at 11:26 PM, craig <craigmorris@...> wrote:
>
> >
> > I can now get the following:
> > =smfGetTagContent("
> > http://www.sec.gov/cgi-bin/ ",browse-edgar? Find=Find+ Companies& action=getcompan y&CIK=ibm
> > "a",1,">SIC")
> >
> > to return 3570.
> >
> > But after reading the files etc, I am unsure how to get data for multiple
> > companies. I thoght I could list the companies in column "A" and get the
> > SIC code in column "B". But I need some help to get there.
> >
>
- 3.
-
portfolio tracker integration?
Posted by: "oyz79" oyz79@yahoo.com oyz79
Wed Dec 21, 2011 8:17 pm (PST)
I have previously installed the add-in and it works great. I am looking for a comprehensive portfolio tracker which tracks and displays dividends, CAGR, max draw down, an equity curve, volatility, and sharpe ratio. Portfolio transactions would be entered manually (buy/sell/date/shares, etc.)
Has anyone developed a template like this using the add-in or have any other cloud-based recommendations?
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
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