Kamis, 02 Februari 2012

[smf_addin] Digest Number 2099

Messages In This Digest (18 Messages)

Messages

1a.

"RCH_Stock_Market_Functions-2.1.2012.01.30.zip"

Posted by: "gsr2588" generivard@gmail.com   gsr2588

Wed Feb 1, 2012 7:23 am (PST)



Greetings. The 1-30-2012 version does not appear to be in the works in progress folder at this time. (I see only three items there (need to be looked at folder, prior versions folder, and the change log).

I am currently using the 1-21-2012 version and I think I need the ADVfn change that is in the 1-30 2012 version to make things right again.

Thanks in advance

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

Re: "RCH_Stock_Market_Functions-2.1.2012.01.30.zip"

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

Wed Feb 1, 2012 7:25 am (PST)



That version was changed to be the official release, so now it's in the
"Add-In Files" folder...

On Wed, Feb 1, 2012 at 5:38 AM, gsr2588 <generivard@gmail.com> wrote:

> Greetings. The 1-30-2012 version does not appear to be in the works in
> progress folder at this time. (I see only three items there (need to be
> looked at folder, prior versions folder, and the change log).
>
> I am currently using the 1-21-2012 version and I think I need the ADVfn
> change that is in the 1-30 2012 version to make things right again.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1c.

Re: "RCH_Stock_Market_Functions-2.1.2012.01.30.zip"

Posted by: "gsr2588" generivard@gmail.com   gsr2588

Wed Feb 1, 2012 7:58 am (PST)



OK, got it. I should have looked there first... sorry about that. Thanks very much !

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That version was changed to be the official release, so now it's in the
> "Add-In Files" folder...
>
> On Wed, Feb 1, 2012 at 5:38 AM, gsr2588 <generivard@...> wrote:
>
> > Greetings. The 1-30-2012 version does not appear to be in the works in
> > progress folder at this time. (I see only three items there (need to be
> > looked at folder, prior versions folder, and the change log).
> >
> > I am currently using the 1-21-2012 version and I think I need the ADVfn
> > change that is in the 1-30 2012 version to make things right again.
> >
>

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

Some RCHGetElementNumber codes do not work today

Posted by: "timdbui" timdbui@gmail.com   timdbui

Wed Feb 1, 2012 8:23 am (PST)



Hi Randy,

Several of my RCHGetElementNumber codes give #VALUE! or Error today. They all worked in the past.

For example:

=RCHGetElementNumber(Symbol,9506)+RCHGetElementNumber(Symbol,9546)
this cell supposes to give the most recent Cash & Sec amount stopped working today and gives back #VALUE!.

I have updated the latest addin 2.1.2011.01.28 but it did not help.

Could you tell me what should I do?

Thanks so much, Randy!

Tim

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

Re: Some RCHGetElementNumber codes do not work today

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

Wed Feb 1, 2012 8:30 am (PST)



Those are AdvFN elements and you need the absolute latest SMF which
addresses the recent change to that website.

Those elements are working fine for me with the latest version.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of timdbui
Sent: Wednesday, February 01, 2012 11:23 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Some RCHGetElementNumber codes do not work today

Hi Randy,

Several of my RCHGetElementNumber codes give #VALUE! or Error today. They
all worked in the past.

For example:

=RCHGetElementNumber(Symbol,9506)+RCHGetElementNumber(Symbol,9546)
this cell supposes to give the most recent Cash & Sec amount stopped working
today and gives back #VALUE!.

I have updated the latest addin 2.1.2011.01.28 but it did not help.

Could you tell me what should I do?

Thanks so much, Randy!

Tim

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

Re: Some RCHGetElementNumber codes do not work today

Posted by: "timdbui" timdbui@gmail.com   timdbui

Wed Feb 1, 2012 8:37 am (PST)



Thanks for your reply,Mike! Let me try again. Tim

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> Those are AdvFN elements and you need the absolute latest SMF which
> addresses the recent change to that website.
>
> Those elements are working fine for me with the latest version.
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of timdbui
> Sent: Wednesday, February 01, 2012 11:23 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Some RCHGetElementNumber codes do not work today
>
>
>
>
> Hi Randy,
>
> Several of my RCHGetElementNumber codes give #VALUE! or Error today. They
> all worked in the past.
>
> For example:
>
> =RCHGetElementNumber(Symbol,9506)+RCHGetElementNumber(Symbol,9546)
> this cell supposes to give the most recent Cash & Sec amount stopped working
> today and gives back #VALUE!.
>
> I have updated the latest addin 2.1.2011.01.28 but it did not help.
>
> Could you tell me what should I do?
>
> Thanks so much, Randy!
>
> Tim
>

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

Re: Some RCHGetElementNumber codes do not work today

Posted by: "timdbui" timdbui@gmail.com   timdbui

Wed Feb 1, 2012 8:41 am (PST)



You are absolutely right, Mike. I updated to the most recent Addin and it works. Thanks for your suggestion! Tim

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> Those are AdvFN elements and you need the absolute latest SMF which
> addresses the recent change to that website.
>
> Those elements are working fine for me with the latest version.
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of timdbui
> Sent: Wednesday, February 01, 2012 11:23 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Some RCHGetElementNumber codes do not work today
>
>
>
>
> Hi Randy,
>
> Several of my RCHGetElementNumber codes give #VALUE! or Error today. They
> all worked in the past.
>
> For example:
>
> =RCHGetElementNumber(Symbol,9506)+RCHGetElementNumber(Symbol,9546)
> this cell supposes to give the most recent Cash & Sec amount stopped working
> today and gives back #VALUE!.
>
> I have updated the latest addin 2.1.2011.01.28 but it did not help.
>
> Could you tell me what should I do?
>
> Thanks so much, Randy!
>
> Tim
>

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

SMFTech Question

Posted by: "draz2121" bolony21@gmail.com   draz2121

Wed Feb 1, 2012 8:24 am (PST)



Hi Randy,

I see that the SMFTech function is coded to print the results base don the dates running from bottom to top i.e. the latest date is at the bottom of the array and the earliest date is at the top.

Is there a quick way to flip this?

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

Re: SMFTech Question

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

Wed Feb 1, 2012 11:23 am (PST)



Nope. However, you could get the free TA-Lib add-in, which has a reverse
function library that will. Do a search of the message archives for more
info on it.

On Wed, Feb 1, 2012 at 9:24 AM, draz2121 <bolony21@gmail.com> wrote:

>
> I see that the SMFTech function is coded to print the results base don the
> dates running from bottom to top i.e. the latest date is at the bottom of
> the array and the earliest date is at the top.
>
> Is there a quick way to flip this?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3c.

Re: SMFTech Question

Posted by: "Shaun" bolony21@gmail.com   draz2121

Wed Feb 1, 2012 1:22 pm (PST)



Thanks, I will look into it.

Regards,

Shaun

On 1 Feb 2012, at 19:23, Randy Harmelink <rharmelink@gmail.com> wrote:

> Nope. However, you could get the free TA-Lib add-in, which has a reverse function library that will. Do a search of the message archives for more info on it.
>
>
> On Wed, Feb 1, 2012 at 9:24 AM, draz2121 <bolony21@gmail.com> wrote:
>
> I see that the SMFTech function is coded to print the results base don the dates running from bottom to top i.e. the latest date is at the bottom of the array and the earliest date is at the top.
>
> Is there a quick way to flip this?
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
4a.

RCHExtractData Problem

Posted by: "Don" don@cemero.com   dsellari

Wed Feb 1, 2012 12:31 pm (PST)





Randy

I am having a problem with the following code:

Public Sub
x()
Dim f1 As String
Dim f2 As String
Dim i As Integer
Dim j As
Integer
Dim np As String

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

Re: smfGetCSVFile( ) Brazilian Central Bank - Problem

Posted by: "Allan Batista Gabriel" allan_bgabriel@yahoo.com.br   allan_bgabriel

Wed Feb 1, 2012 1:17 pm (PST)





Hello,

I started making a macro to
extract the official forecasts of site (JavaScript) of the Brazilian Central
Bank.

"https://www3.bcb.gov.br/expectativas/publico/consulta/serieestatisticas"

Basically, it is needed to select options from the SelectBoxand Optionbox and generate the
".XLS" or ".CSV".

The point is that: each
selected option (SelectBoxand Optionbox), page refreshes.

However, with the macro that I
made, the page is fully updated and I end up losing previously selected options.

I wonder if anyone can help me
to solve this program. One alternative I thought was consider the function
"smfGetCSVFile ()". But I do not knowexactly howit or others Add-in might be useful in this case.
The program is following:

Function ExtraiDados()

Dim Enderço, URL As String
Dim ret As Long
 
With CreateObject("InternetExplorer.Application")
.Visible = True
.navigate "https://www3.bcb.gov.br/expectativas/publico/consulta/serieestatisticas"

While .ReadyState <> 4
DoEvents
Wend

.Document.forms.Item(0).All.Item("Indicador").Value = "3"
.Refresh    'Here is the problem: the page is fully updated
.Document.forms.Item(0).All.Item("calculo").Value = "0"
.Document.forms.Item(0).All.Item("linhaPeriodicidade:periodicidade").Value = "0"     'this part is only if the pages refreshes
.Document.forms.Item(0).All.Item("grupoIndicePreco:opcoes_2").Click                    'this part is only if the pages refreshes
.Document.forms.Item(0).All.Item("tfDataFinal").Value = "11/04/2011"
.Document.forms.Item(0).All.Item("tfDataInicial").Value = "01/03/2011"
.Document.forms.Item(0).All.Item("btnXLS").Click

.Document.forms.Item(0).All.Item("btnXLS").Click
.Quit

End With

End Function

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

Re: RCHExtractData Problem

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

Wed Feb 1, 2012 6:12 pm (PST)



No, it's that the XMLHTTP protocol only returns a truncated copy of the
source code of the web page. I don't know why. I looked into the problem
several years ago and found no resolution:

http://finance.groups.yahoo.com/group/smf_addin/message/10155

The same problem occurs with the EXCEL Web Query process, so it's not
specific to the add-in processing.

On Wed, Feb 1, 2012 at 1:31 PM, Don <don@cemero.com> wrote:

> **
>
> The data in sData seems to be truncated when there is no data in a cell.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4d.

Re: smfGetCSVFile( ) Brazilian Central Bank - Problem

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

Wed Feb 1, 2012 6:22 pm (PST)



I don't think the add-in can be of any help in this case. All add-in
functions require a bookmarkable URL. It can't be a URL generated
dynamically by interacting with the web page.

If you are generating your CSV file via your VBA, you're going to have to
process with your VBA.

On Wed, Feb 1, 2012 at 2:16 PM, Allan Batista Gabriel <
allan_bgabriel@yahoo.com.br> wrote:

>
> I started making a macro to extract the official forecasts of site
> (JavaScript) of the Brazilian Central Bank.
>
> "https://www3.bcb.gov.br/expectativas/publico/consulta/serieestatisticas"
>
> Basically, it is needed to select options from the SelectBox and
> Optionbox and generate the ".XLS" or ".CSV".
>
> The point is that: each selected option (SelectBox and Optionbox), page
> refreshes.
>
> However, with the macro that I made, the page is fully updated and I end
> up losing previously selected options.
>
> I wonder if anyone can help me to solve this program. One alternative I
> thought was consider the function "smfGetCSVFile ()". But I do not know exactly
> how it or others Add-in might be useful in this case.
>
> The program is following:
>
> Function ExtraiDados()
>
> Dim Enderço, URL As String
> Dim ret As Long
>
> With CreateObject("InternetExplorer.Application")
> .Visible = True
> .navigate "
> https://www3.bcb.gov.br/expectativas/publico/consulta/serieestatisticas"
>
> While .ReadyState <> 4
> DoEvents
> Wend
>
>
> .Document.forms.Item(0).All.Item("Indicador").Value = "3"
> .Refresh 'Here is the problem: the page is fully updated
> .Document.forms.Item(0).All.Item("calculo").Value = "0"
> .Document.forms.Item(0).All.Item("linhaPeriodicidade:periodicidade").Value
> = "0" 'this part is only if the pages refreshes
> .Document.forms.Item(0).All.Item("grupoIndicePreco:opcoes_2").Click
> 'this part is only if the pages refreshes
> .Document.forms.Item(0).All.Item("tfDataFinal").Value = "11/04/2011"
> .Document.forms.Item(0).All.Item("tfDataInicial").Value = "01/03/2011"
> .Document.forms.Item(0).All.Item("btnXLS").Click
> .Document.forms.Item(0).All.Item("btnXLS").Click
> .Quit
>
> End With
>
> End Function
>
> thanks
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
5a.

Please can somebody start me off

Posted by: "draz2121" bolony21@gmail.com   draz2121

Thu Feb 2, 2012 2:02 am (PST)



I am currently using SMFGetYahooHistory to fetch the following:

Date adjOpen adjHigh adjLow adjClose Volume

for various shares.

My frustration lies with the fact that Yahoo does not update it's EoD data until 1-2 hours AFTER our market (LSE) opens the following day.

This does not allow me to do analysis after a day's trading and plan strategy for the following day.

I see that Google and MSN all have their EoD data available within 2-3 hours of market close which is ideal.

Could somebody please start me off here with an example of how to fetch the date and one of the prices from each google and MSN - then I can work on bringing the rest through using your example.

The date must work up from the bottom of the array also i.e. latest date at the bottom.

Many thanks in advance.

Shaun

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

Re: Please can somebody start me off

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

Thu Feb 2, 2012 2:37 am (PST)



When I'm on the historical quotes page for Google or MSN, both have a
"Download" option. You should just grab that file and sort it in whatever
order you need, if it has all of the data you need.

On Thu, Feb 2, 2012 at 3:02 AM, draz2121 <bolony21@gmail.com> wrote:

> I am currently using SMFGetYahooHistory to fetch the following:
>
> Date adjOpen adjHigh adjLow adjClose Volume
>
> for various shares.
>
> My frustration lies with the fact that Yahoo does not update it's EoD data
> until 1-2 hours AFTER our market (LSE) opens the following day.
>
> This does not allow me to do analysis after a day's trading and plan
> strategy for the following day.
>
> I see that Google and MSN all have their EoD data available within 2-3
> hours of market close which is ideal.
>
> Could somebody please start me off here with an example of how to fetch
> the date and one of the prices from each google and MSN - then I can work
> on bringing the rest through using your example.
>
> The date must work up from the bottom of the array also i.e. latest date
> at the bottom.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
5c.

Re: Please can somebody start me off

Posted by: "draz2121" bolony21@gmail.com   draz2121

Thu Feb 2, 2012 2:38 am (PST)



Can this not be automated using your add-in though Randy?

I figured that you could use the elements function in some way?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> When I'm on the historical quotes page for Google or MSN, both have a
> "Download" option. You should just grab that file and sort it in whatever
> order you need, if it has all of the data you need.
>
> On Thu, Feb 2, 2012 at 3:02 AM, draz2121 <bolony21@...> wrote:
>
> > I am currently using SMFGetYahooHistory to fetch the following:
> >
> > Date adjOpen adjHigh adjLow adjClose Volume
> >
> > for various shares.
> >
> > My frustration lies with the fact that Yahoo does not update it's EoD data
> > until 1-2 hours AFTER our market (LSE) opens the following day.
> >
> > This does not allow me to do analysis after a day's trading and plan
> > strategy for the following day.
> >
> > I see that Google and MSN all have their EoD data available within 2-3
> > hours of market close which is ideal.
> >
> > Could somebody please start me off here with an example of how to fetch
> > the date and one of the prices from each google and MSN - then I can work
> > on bringing the rest through using your example.
> >
> > The date must work up from the bottom of the array also i.e. latest date
> > at the bottom.
> >
>

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

Re: Please can somebody start me off

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

Thu Feb 2, 2012 2:49 am (PST)



From Google:

=smfGetCSVFIle("
http://www.google.com/finance/historical?q=NYSE:MMM&output=csv")

From MSN:

=smfGetCSVFIle("
http://investing.money.msn.com/investments/equity-historical-price/?PT=7&D4=1&DD=1&D5=0&DCS=2&MA0=0&MA1=0&CF=0&nocookie=1&SZ=0&symbol=MMM&Download=1
")

But the MSN historical quotes are weekly, so I doubt they would fit your
needs.

On Thu, Feb 2, 2012 at 3:38 AM, draz2121 <bolony21@gmail.com> wrote:

> Can this not be automated using your add-in though Randy?
>
> I figured that you could use the elements function in some way?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need traffic?

Drive customers

With search ads

on Yahoo!

Yahoo! News

Fashion News

What's the word on

fashion and style?

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 03.20

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)