Excel and the Amibroker's database

[atlas190]

Hello!! I have done a small VBA program with a small bug .
I think that I have this bug because I don't know how to install and use the file

Broker4705.tlb

on my computer ...

So my question is very sample how to install the file Broker4705.tlb ?

Here is my VBA code wich is meeting a bug with the method "refreshall"

Sub test()

Dim derlign As Integer
derlign = Worksheets(1).Range("A65536").End(xlUp).Row + 1

Dim Amibroker As Object
Set Amibroker = CreateObject("Broker.application")

Dim i As Integer
Dim a, b, c As String
Dim collectiondestock As Object

For i = 1 To derlign

a = Val(Left(Cells(i, 6).Value, 1)) 
'a = Left(a, 1)  
b = Cells(i, 5).Value & ".PA" 
c = Cells(i, 1).Value 



If a <> 0 Then   
Set collectiondestock = Amibroker.stocks.Add(b)
collectiondestock.FullName = c
collectiondestock.IndustryID = a
End If

Next i

Set collectiondestock = Amibroker.RefreshAll()   'did not work ?!
   Set Amibroker = Nothing

End Sub

The kind of .xls that I use is on http://www.euronext.com otherwise a file is joined .

 

[atlas190]

I have found the solution , sorry to speach alone ...
Hope that my post have interessed somebody ...

Sub test()

Dim derlign As Integer
derlign = Worksheets(1).Range("A65536").End(xlUp).Row + 1

Dim Amibroker As Object
Set Amibroker = CreateObject("Broker.application")

Dim i As Integer
Dim a, b, c As String
Dim collectiondestock As Object

For i = 1 To derlign

a = Val(Left(Cells(i, 6).Value, 1)) 
'a = Left(a, 1)  
b = Cells(i, 5).Value & ".PA" 
c = Cells(i, 1).Value 



If a <> 0 Then   
Set collectiondestock = Amibroker.stocks.Add(b)
collectiondestock.FullName = c
collectiondestock.IndustryID = a
End If

Next i

   Amibroker.RefreshAll     'without parenthses after the word "Refreshall"  
   Set Amibroker = Nothing

End Sub

 

[sdebu_2000]

Atlas190,
please tell us what is the function of ur VBA ? what do u do with it actually?I am interested

 

[vgarg59]

Dear all

I have IRIS which has a DDE link and generates the Excel file that has OHLC, Vol etc and is in real time. I also use Amibroker, Prof version. How do I link this to get the realtime data in AB? Help required

 

[amibroker-india]

Dear all

I have IRIS which has a DDE link and generates the Excel file that has OHLC, Vol etc and is in real time. I also use Amibroker, Prof version. How do I link this to get the realtime data in AB? Help required

Hello,

Please refer to this post by us for answer to a similar question.

http://www.traderji.com/amibroker/14161-amibroker-help-you-8.html#post289183

Best regards,

AmiBroker-India

 

[deliiii]

thank you eveybody...

 

[atlas190]

To sdebu_2000 .
Look at this in the Amibroker User's Guide .
Folder "database management"/ Understanding catgories .

At the bottom of the tutorial "Making it automatique" there is a link

"4 th issue of Amibroker Tips Newsletter" .

In fact the programm has been done in javascript and vbscript .I have done the same in VBA .

The purpose is to build quikly a database with the ticker's names wich are in a excel file .(see the excel file that I have joined) . The ticker is typed automatically and is put in the right folder , the good sector ...Depending what you need .

For the first database it is slowly that If I have done it by the hand but for the second database and if the excel file is good then It will be faster !

 

[bemanojb]

Dear All,
Can anyone post the code to retrieve the OHLC from AmiBroker to Excel through VBA.

 

[fishmarket]

Dear All,
Can anyone post the code to retrieve the OHLC from AmiBroker to Excel through VBA.

have you got the solution?

 

[trash]

have you got the solution?

////
Yes.
////