Messages In This Digest (7 Messages)

1a.: Re: profile summary From: kostas
1b.: Re: profile summary From: kostas

2a.: Added routine smfUpdateDownloadTableCurRow From: Rob Oppenheim
2b.: Re: Added routine smfUpdateDownloadTableCurRow [1 Attachment] From: Randy Harmelink

3a.: StartHelp & MacroFor1WkChange From: viraj.pandit@ymail.com
3b.: Re: StartHelp & MacroFor1WkChange From: Randy Harmelink
3c.: Excel on Macbook From: Au

View All Topics | Create New Topic

Messages

1a.: Re: profile summary

Posted by: "kostas" nasta256@yahoo.gr nasta256

Fri Aug 5, 2011 9:55 pm (PDT)

--- In smf_addin@yahoogroups.com, "nikos chryssochoidis" <nikoschryssochoidis@...> wrote:
>
> hi,
>
> am wondering if there is a formula to use , in order to add in a cell of an excel the profile summary of a company listed in a stock exchange.
>
> thank you , and many thanks for this great group !
>
Hi,
You can use
smfGetTagContent("http://www.reuters.com/finance/stocks/companyProfile?symbol=HEPr.AT","div",1,"Full Description") and clean it with some string manipulation.
You will find that Reuters as a source has most of the Greek companies.
Ελπίζω να βοήθησα.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1b.: Re: profile summary

Posted by: "kostas" nasta256@yahoo.gr nasta256

Fri Aug 5, 2011 9:57 pm (PDT)

--- In smf_addin@yahoogroups.com, "nikos chryssochoidis" <nikoschryssochoidis@...> wrote:
>
> hi,
>
> am wondering if there is a formula to use , in order to add in a cell of an excel the profile summary of a company listed in a stock exchange.
>
> thank you , and many thanks for this great group !
>

Hi,
You can use =smfGetTagContent(_
"http://www.reuters.com/finance/stocks/companyProfile?symbol=HEPr.AT","div",1,"Full Description")
and clean it with some string manipulation.
You will find that Reuters as a source has most of the Greek companies.
Elpizo na boi8isa.
Kostas

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

2a.: Added routine smfUpdateDownloadTableCurRow

Posted by: "Rob Oppenheim" oppenheim@email.com rob_oppie

Fri Aug 5, 2011 10:00 pm (PDT)

[Attachment(s) from Rob Oppenheim included below]

I added a routine to modDownloadTable that will update just one row of a
Download Quote Table
(whatever row has the current cell selection)

I use it when I need a quick update for just one symbol.
The old functionality remains the same. It just adds a new ability.

The new routine is named: smfUpdateDownloadTableCurRow

You can add buttons to a spreadsheet that cause the table to be updated.
Either all rows, or just the current row...

Create a button in Excel (Developer/Insert/Form Controls: button).
Edit the button text to be something like "Reload All Quote Data",
Right click the button and "Assign Macro...", click NEW (or edit),
then in the ButtonX_Click() macro body add the line:
Application.Run "smfUpdateDownloadTable"

Add another button labled "Load Cur Row",
then in the ButtonX_Click() macro body add the line:
Application.Run "smfUpdateDownloadTableCurRow"

Examples:

Sub Button1_Click()
Application.Run "smfUpdateDownloadTable"
End Sub

Sub Button2_Click()
Application.Run "smfUpdateDownloadTableCurRow"
End Sub

To use the update current row ability, you must update module
modDownloadTable as follows:
Attached is a text file that replaces the modDownloadTable module (for
beta version: 2.1.2011.04.03).

If you are using version: 2.1.2011.04.03, and you want to use this mod,
then ...

Select all of the text in modDownloadTable.txt, and in Excel goto the
Developer tab and click on Visual Basic.
in the box on the left under the "RCH_Stock_Market_Functions", double
click on "modDownloadTable".
Then select all the text in the module (Ctrl-A) and paste in the new
text from modDownloadTable.txt.

It is fine by me if this code is added to the distribution.

-Rob

Attachment(s) from Rob Oppenheim

1 of 1 File(s)

modDownloadTable.txt

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.: Re: Added routine smfUpdateDownloadTableCurRow [1 Attachment]

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

Fri Aug 5, 2011 10:08 pm (PDT)

The next logical step would be to update highlighted rows... :)

On Fri, Aug 5, 2011 at 9:48 PM, Rob Oppenheim <oppenheim@email.com> wrote:

>
> I added a routine to modDownloadTable that will update just one row of a
> Download Quote Table
> (whatever row has the current cell selection)
>

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

3a.: StartHelp & MacroFor1WkChange

Posted by: "viraj.pandit@ymail.com" viraj.pandit@ymail.com viraj.pandit@ymail.com

Fri Aug 5, 2011 11:42 pm (PDT)

Hello,
I went through a bunch of files in the Files section. I would like to know if there is a "start here" / Readme document for this forum for newbies.
I am specifically looking for a macro in which I can enter a number of days for which I want a list of stock's returns. i.e. for a portfolio of GOOG, AAPL, CREE, if I enter 3, it will give me the return for the last 3 trading days. If I change 3 to 5, it will give me the return for the last 5 trading days.
Please help.
Thanks,

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3b.: Re: StartHelp & MacroFor1WkChange

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

Fri Aug 5, 2011 11:46 pm (PDT)

Look in the "Documentation" folder of the files area. Tips and FAQs are in
the "Links" area of the group.

For the most part, the add-in is user-defined functions, not macros.

The function that would do the type of thing you're requesting is the
smfPricesByDates() function.

On Fri, Aug 5, 2011 at 11:42 PM, viraj.pandit@ymail.com <
viraj.pandit@ymail.com> wrote:

> Hello,
> I went through a bunch of files in the Files section. I would like to know
> if there is a "start here" / Readme document for this forum for newbies.
> I am specifically looking for a macro in which I can enter a number of days
> for which I want a list of stock's returns. i.e. for a portfolio of GOOG,
> AAPL, CREE, if I enter 3, it will give me the return for the last 3 trading
> days. If I change 3 to 5, it will give me the return for the last 5 trading
> days.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3c.: Excel on Macbook

Posted by: "Au" uanant@ymail.com uanant@ymail.com

Sat Aug 6, 2011 3:27 am (PDT)

Hello Randy,
Will your add-in work on excel on Macbook. Not on virtual machine actual ms office version of excel on Macbook.

regards
Aku

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

EXCEL FEED

Sabtu, 06 Agustus 2011

[smf_addin] Digest Number 1911[1 Attachment]

Messages In This Digest (7 Messages)

Messages

Re: profile summary

Posted by: "kostas" nasta256@yahoo.gr nasta256

Fri Aug 5, 2011 9:55 pm (PDT)

Re: profile summary

Posted by: "kostas" nasta256@yahoo.gr nasta256

Fri Aug 5, 2011 9:57 pm (PDT)

Added routine smfUpdateDownloadTableCurRow

Posted by: "Rob Oppenheim" oppenheim@email.com rob_oppie

Fri Aug 5, 2011 10:00 pm (PDT)

Re: Added routine smfUpdateDownloadTableCurRow [1 Attachment]

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

Fri Aug 5, 2011 10:08 pm (PDT)

StartHelp & MacroFor1WkChange

Posted by: "viraj.pandit@ymail.com" viraj.pandit@ymail.com viraj.pandit@ymail.com

Fri Aug 5, 2011 11:42 pm (PDT)

Re: StartHelp & MacroFor1WkChange

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

Fri Aug 5, 2011 11:46 pm (PDT)

Excel on Macbook

Posted by: "Au" uanant@ymail.com uanant@ymail.com

Sat Aug 6, 2011 3:27 am (PDT)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me