Sabtu, 03 Desember 2011

[smf_addin] Digest Number 2034

Messages In This Digest (17 Messages)

1a.
Data fromWeb page From: Philip S
1b.
Re: Data fromWeb page From: Randy Harmelink
1c.
Re: Data fromWeb page From: Philip S
1d.
Re: Data fromWeb page From: Mike McQuaid
1e.
Re: Data fromWeb page From: adam pilz
2a.
Need Advice on RCHGetYahooHistory From: GaryFera
2b.
Re: Need Advice on RCHGetYahooHistory From: Randy Harmelink
2c.
Re: Need Advice on RCHGetYahooHistory From: GaryFera
2d.
Re: Need Advice on RCHGetYahooHistory From: dguillett1
2e.
Re: Need Advice on RCHGetYahooHistory From: Randy Harmelink
2f.
Re: Need Advice on RCHGetYahooHistory From: rmalladi
2g.
Re: Need Advice on RCHGetYahooHistory From: Randy Harmelink
3a.
Breakout From: lexstar
3b.
Re: Breakout From: Randy Harmelink
4a.
Re: Stock screener.xls ticket hypelink each symbol From: almondtree
4b.
Re: Stock screener.xls ticket hypelink each symbol From: Randy Harmelink
4c.
Re: Stock screener.xls ticket hypelink each symbol From: almondtree

Messages

1a.

Data fromWeb page

Posted by: "Philip S" Philip_R_Small@hotmail.com   philip_r_small

Fri Dec 2, 2011 3:21 am (PST)



Hi Randy

I think I know the answer to this already but is there a way of using the SMF to pull individual data from the following links?

http://markets.ft.com/ft/markets/reports/FTReport.asp?dockey=GOV-011211

http://markets.ft.com/ft/markets/reports/FTReport.asp?dockey=FTUK-011211

The pages appear to have data in PDF format.

I was looking to do some analysis of the Gilt Equity Ratio and wanted to look at getting data for this.

Thanks

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

Re: Data fromWeb page

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

Fri Dec 2, 2011 3:50 am (PST)



Sorry, no....

On Fri, Dec 2, 2011 at 4:21 AM, Philip S <Philip_R_Small@hotmail.com> wrote:

>
> I think I know the answer to this already but is there a way of using the
> SMF to pull individual data from the following links?
>
> http://markets.ft.com/ft/markets/reports/FTReport.asp?dockey=GOV-011211
>
> http://markets.ft.com/ft/markets/reports/FTReport.asp?dockey=FTUK-011211
>
> The pages appear to have data in PDF format.
>
> I was looking to do some analysis of the Gilt Equity Ratio and wanted to
> look at getting data for this.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1c.

Re: Data fromWeb page

Posted by: "Philip S" Philip_R_Small@hotmail.com   philip_r_small

Fri Dec 2, 2011 3:55 am (PST)



Sadly, that is what I thought. Will have to resort to the old manual input technique!

Thanks for the prompt response. Have a good weekend.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Sorry, no....
>
> On Fri, Dec 2, 2011 at 4:21 AM, Philip S <Philip_R_Small@...> wrote:
>
> >
> > I think I know the answer to this already but is there a way of using the
> > SMF to pull individual data from the following links?
> >
> > http://markets.ft.com/ft/markets/reports/FTReport.asp?dockey=GOV-011211
> >
> > http://markets.ft.com/ft/markets/reports/FTReport.asp?dockey=FTUK-011211
> >
> > The pages appear to have data in PDF format.
> >
> > I was looking to do some analysis of the Gilt Equity Ratio and wanted to
> > look at getting data for this.
> >
>

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

Re: Data fromWeb page

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Fri Dec 2, 2011 5:55 am (PST)



Some scanners can create an Excel spreadsheet from a scanned image - this
would save you the trouble of manual entry.

There are various software packages that convert PDF into other formats,
Word, Excel, etc

Nitro PDF, for one, says it does that. I've used NitroPDF for other things,
not Excel conversion, so can't speak directly to how well it works.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Philip S
Sent: Friday, December 02, 2011 6:55 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Data fromWeb page

Sadly, that is what I thought. Will have to resort to the old manual input
technique!

Thanks for the prompt response. Have a good weekend.

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
Randy Harmelink <rharmelink@...> wrote:
>
> Sorry, no....
>
> On Fri, Dec 2, 2011 at 4:21 AM, Philip S <Philip_R_Small@...> wrote:
>
> >
> > I think I know the answer to this already but is there a way of using
the
> > SMF to pull individual data from the following links?
> >
> > http://markets.ft.com/ft/markets/reports/FTReport.asp?dockey=GOV-011211
> >
> > http://markets.ft.com/ft/markets/reports/FTReport.asp?dockey=FTUK-011211
> >
> > The pages appear to have data in PDF format.
> >
> > I was looking to do some analysis of the Gilt Equity Ratio and wanted to
> > look at getting data for this.
> >
>

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

Re: Data fromWeb page

Posted by: "adam pilz" adampilz.2326@gmail.com   pilzadam

Fri Dec 2, 2011 10:42 am (PST)



If you are looking for the yields and spreads, this site might help:

http://markets.ft.com/RESEARCH/Markets/Government-Bond-Spreads

AP

On Fri, Dec 2, 2011 at 8:55 AM, Mike McQuaid <mikemcq802@yahoo.com> wrote:

> **
>
>
> **
> Some scanners can create an Excel spreadsheet from a scanned image - this
> would save you the trouble of manual entry.
>
> There are various software packages that convert PDF into other formats,
> Word, Excel, etc
>
> Nitro PDF, for one, says it does that. I've used NitroPDF for other
> things, not Excel conversion, so can't speak directly to how well it works.
>
> ------------------------------
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] *On
> Behalf Of *Philip S
> *Sent:* Friday, December 02, 2011 6:55 AM
> *To:* smf_addin@yahoogroups.com
> *Subject:* [smf_addin] Re: Data fromWeb page
>
>
>
> Sadly, that is what I thought. Will have to resort to the old manual input
> technique!
>
> Thanks for the prompt response. Have a good weekend.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > Sorry, no....
> >
> > On Fri, Dec 2, 2011 at 4:21 AM, Philip S <Philip_R_Small@...> wrote:
> >
> > >
> > > I think I know the answer to this already but is there a way of using
> the
> > > SMF to pull individual data from the following links?
> > >
> > >
> http://markets.ft.com/ft/markets/reports/FTReport.asp?dockey=GOV-011211
> > >
> > >
> http://markets.ft.com/ft/markets/reports/FTReport.asp?dockey=FTUK-011211
> > >
> > > The pages appear to have data in PDF format.
> > >
> > > I was looking to do some analysis of the Gilt Equity Ratio and wanted
> to
> > > look at getting data for this.
> > >
> >
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2a.

Need Advice on RCHGetYahooHistory

Posted by: "GaryFera" gfera@shaw.ca   GaryFera

Fri Dec 2, 2011 5:49 am (PST)



Randy, I am having difficulty getting the RCHGetYahooHistory function to work. I have been using your excellent Add In successfully for months but when I try to use this particular function it simply appears that it is not installed since the command is not recognized by Excel.

Can you please give me some guidance on how to determine if in fact this function is installed? Thanks.

Gary

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

Re: Need Advice on RCHGetYahooHistory

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

Fri Dec 2, 2011 7:43 am (PST)



If the add-in is installed, that function is installed.

What problems are you running into?

On Fri, Dec 2, 2011 at 6:49 AM, GaryFera <gfera@shaw.ca> wrote:

> Randy, I am having difficulty getting the RCHGetYahooHistory function to
> work. I have been using your excellent Add In successfully for months but
> when I try to use this particular function it simply appears that it is not
> installed since the command is not recognized by Excel.
>
> Can you please give me some guidance on how to determine if in fact this
> function is installed? Thanks.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2c.

Re: Need Advice on RCHGetYahooHistory

Posted by: "GaryFera" gfera@shaw.ca   GaryFera

Fri Dec 2, 2011 10:37 am (PST)



Randy, the Add In has been installed and working fine for months. I tried downloading the sample spreadsheet that retrieved historical quotes for CLDN for June 1 to July 10, 2006 but keep getting #NAME? errors even when I change the symbol to IBM. I am not sure what I am doing incorrectly.

Gary

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> If the add-in is installed, that function is installed.
>
> What problems are you running into?
>
> On Fri, Dec 2, 2011 at 6:49 AM, GaryFera <gfera@...> wrote:
>
> > Randy, I am having difficulty getting the RCHGetYahooHistory function to
> > work. I have been using your excellent Add In successfully for months but
> > when I try to use this particular function it simply appears that it is not
> > installed since the command is not recognized by Excel.
> >
> > Can you please give me some guidance on how to determine if in fact this
> > function is installed? Thanks.
> >
>

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

Re: Need Advice on RCHGetYahooHistory

Posted by: "dguillett1" dguillett1@gmail.com   donaldb36

Fri Dec 2, 2011 11:05 am (PST)



goto yahoo finance and you will find 2 symbols for cldn
cldn.L
cldn.F

Don Guillett
SalesAid Software
dguillett1@gmail.com

From: GaryFera
Sent: Friday, December 02, 2011 12:37 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Need Advice on RCHGetYahooHistory

Randy, the Add In has been installed and working fine for months. I tried downloading the sample spreadsheet that retrieved historical quotes for CLDN for June 1 to July 10, 2006 but keep getting #NAME? errors even when I change the symbol to IBM. I am not sure what I am doing incorrectly.

Gary

--- In mailto:smf_addin%40yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> If the add-in is installed, that function is installed.
>
> What problems are you running into?
>
> On Fri, Dec 2, 2011 at 6:49 AM, GaryFera <gfera@...> wrote:
>
> > Randy, I am having difficulty getting the RCHGetYahooHistory function to
> > work. I have been using your excellent Add In successfully for months but
> > when I try to use this particular function it simply appears that it is not
> > installed since the command is not recognized by Excel.
> >
> > Can you please give me some guidance on how to determine if in fact this
> > function is installed? Thanks.
> >
>

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

Re: Need Advice on RCHGetYahooHistory

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

Fri Dec 2, 2011 11:38 am (PST)



You probably just have unresolved links causing a location error. See the
"Location Errors" item in the "Links" area of the group. It's an issue with
how EXCEL processes add-in formulas.

On Fri, Dec 2, 2011 at 11:37 AM, GaryFera <gfera@shaw.ca> wrote:

> Randy, the Add In has been installed and working fine for months. I tried
> downloading the sample spreadsheet that retrieved historical quotes for
> CLDN for June 1 to July 10, 2006 but keep getting #NAME? errors even when I
> change the symbol to IBM. I am not sure what I am doing incorrectly.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2f.

Re: Need Advice on RCHGetYahooHistory

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

Fri Dec 2, 2011 9:16 pm (PST)



I am also having the same issue.

My excel which was working until a month ago, stopped working.

"RCHGetYahooHistory" is producing "#NAME?" for IBM and all other Tickers.

--- In smf_addin@yahoogroups.com, "GaryFera" <gfera@...> wrote:
>
> Randy, I am having difficulty getting the RCHGetYahooHistory function to work. I have been using your excellent Add In successfully for months but when I try to use this particular function it simply appears that it is not installed since the command is not recognized by Excel.
>
> Can you please give me some guidance on how to determine if in fact this function is installed? Thanks.
>
> Gary
>

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

Re: Need Advice on RCHGetYahooHistory

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

Fri Dec 2, 2011 9:20 pm (PST)



Are you getting when opening a new workbook and entering the formula, or
when opening a template? If the latter, you may just have link errors that
need to be resolved (see "Links" area of group for location errors item).

What do you get with:

=RCHGetElementNumber("Version")

On Fri, Dec 2, 2011 at 10:14 PM, rmalladi <rmalladi@yahoo.com> wrote:

> I am also having the same issue.
>
> My excel which was working until a month ago, stopped working.
>
> "RCHGetYahooHistory" is producing "#NAME?" for IBM and all other Tickers.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
3a.

Breakout

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

Fri Dec 2, 2011 9:29 am (PST)



Does anyone know if it is possible to retrieve the following information.

Say my stop loss is 10 as example. How can I find the SPECIFIC DAY OF THE MONTH and the SPECIFIC PRICE IT CLOSED LOWER than my stop loss of 10.

In other words, if LAST Closed is > 10, do nothing.

If LAST Close is <10, and PREVIOUS DAY's Close is >10, find me the Last Close and it's Date.

Is there a formula or function that can accomplish this task? Any comments appreciated.

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

Re: Breakout

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

Fri Dec 2, 2011 9:39 am (PST)



The most straight-forward way would be to simply download the historical
data and then use helper columns to identify the specific conditions.

On Fri, Dec 2, 2011 at 10:29 AM, lexstar <lexstar@yahoo.com> wrote:

> Does anyone know if it is possible to retrieve the following information.
>
> Say my stop loss is 10 as example. How can I find the SPECIFIC DAY OF THE
> MONTH and the SPECIFIC PRICE IT CLOSED LOWER than my stop loss of 10.
>
> In other words, if LAST Closed is > 10, do nothing.
>
> If LAST Close is <10, and PREVIOUS DAY's Close is >10, find me the Last
> Close and it's Date.
>
> Is there a formula or function that can accomplish this task? Any
> comments appreciated.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

Re: Stock screener.xls ticket hypelink each symbol

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

Fri Dec 2, 2011 10:11 pm (PST)



I got it to work URL = "http://finviz.com/quote.ashx?t=" + cell.Value + "&ty=c&ta=1&p=d"
End If
I inserted a new column then copy tickers over, Run macro works. Next to see if it works in Reuters or Google.
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You would need to modify the "rng" and "URL" values to be what you need
> them to be. Like I said, I personally prefer to use the hyperlink function
> in a new column.
>
> On Thu, Dec 1, 2011 at 4:21 PM, almondtree <almondtree@...> wrote:
>
> >
> > Ifound this Macro on Yahoo Answers: It makes all tickers blue I don't know
> > how insert a URL maybe you could have a look:
> > Sub ConvertToHyperlink()
> > Dim rng As Range
> > Set rng = Range("A6:A" & Cells _
> > (rows.Count, 1).End(xlUp).Row)
> > 'Set rng = ActiveSheet.UsedRange
> > For Each cell In rng
> > cell.Select
> > If cell.Value <> "" Then
> > If Left(cell.Value, 7) = "http://" Then
> > URL = cell.Value
> > Else
> > URL = "http://" + cell.Value
> > End If
> > ActiveSheet.Hyperlinks.Add Anchor:=cell, _
> > Address:=URL, TextToDisplay:=cell.Value
> > End If
> > here:
> > Next
> > End Sub
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
>

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

Re: Stock screener.xls ticket hypelink each symbol

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

Fri Dec 2, 2011 10:14 pm (PST)



If you're going to insert a new column, wouldn't it be easier to just use
the HYPERLINK() function?

On Fri, Dec 2, 2011 at 11:11 PM, almondtree <almondtree@yahoo.com> wrote:

> I got it to work URL = "http://finviz.com/quote.ashx?t=" + cell.Value +
> "&ty=c&ta=1&p=d"
> End If
> I inserted a new column then copy tickers over, Run macro works. Next to
> see if it works in Reuters or Google.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
4c.

Re: Stock screener.xls ticket hypelink each symbol

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

Fri Dec 2, 2011 10:46 pm (PST)



What's the fun in that? when blinding speed works for you.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> If you're going to insert a new column, wouldn't it be easier to just use
> the HYPERLINK() function?
>
> On Fri, Dec 2, 2011 at 11:11 PM, almondtree <almondtree@...> wrote:
>
> > I got it to work URL = "http://finviz.com/quote.ashx?t=" + cell.Value +
> > "&ty=c&ta=1&p=d"
> > End If
> > I inserted a new column then copy tickers over, Run macro works. Next to
> > see if it works in Reuters or Google.
> >
>

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

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

Yahoo! Groups

Small Business Group

Ask questions,

share experiences

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
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 02.01

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)