Realtime data NOW,ODIN,TradeTiger,Google,Yahoo > AmiBroker, Fcharts, Qtstalker

[sr114]

Dear josh1,

If i open any excel file in Live Market Hours (while running in RTG31.xlsm) that new excel file A column (From A7) data also appended in Amibroker Symbol list . Can you help me to solve this problem?

Example :
=========

I opened new excel file and type A1 to A12 .

A1 = Date
A2 = 1/08/2012
A3 = 4/08/2012
A4 = 7/08/2012
A5 = 8/08/2012
A6 = 9/08/2012
A7 = 10/08/2012
A8 = 13/08/2012
A9 = 14/08/2012
A10 = 16/08/2012
A11 = 17/08/2012
A12 = PERIOD

Row A7 to A12 Data added in Amibroker Symbol List.

SmartTrade

pls answer these questions:
1. du u save this particular excel file containing the dates and period?
2. do u open this saved file by double clicking?

if the answer is yes then this will happen. ( and the answer is yes - no guess work here ) - do 1 thing. if u want to do something in excel while RTG31.xlm is open, then open another excel file thru Start-MSOffice-Excel ( or in whatever order u have in ur start menu) and do ur calculation. then no addition of the col of that particular excel file will be appended in ami.

sr

 

[yrjadeja]

Mr. Josh is it possible to get data from Nest Trader ??

presently using nse now to ami smoothly thanks to u but my friend is using nest trader is it possible to get data from nest to ami ?

 

[smarttrade]

SmartTrade

pls answer these questions:
1. du u save this particular excel file containing the dates and period?
2. do u open this saved file by double clicking?

if the answer is yes then this will happen. ( and the answer is yes - no guess work here ) - do 1 thing. if u want to do something in excel while RTG31.xlm is open, then open another excel file thru Start-MSOffice-Excel ( or in whatever order u have in ur start menu) and do ur calculation. then no addition of the col of that particular excel file will be appended in ami.

sr

Dear sr114,

Thanks for your reply. When I try to open another excel file thru Start-MSOffice-Excel then working correctly . But I ask one more question here . can you help also this ?

==========================================================
Sub MakeCSV()
Dim fs As Object, a As Object, C As Integer, i As Integer, R As Integer, S As String, t As Variant, CellValue As String
'Create a file object for writing
Set fs = CreateObject("Scripting.FileSystemObject")
On Error Resume Next
MkDir ("C:\RT") 'This will create a folder RT in C Drive.
FileName = "C:\RT\MyCSVG.txt" 'This file is used to write quotes
Set a = fs.CreateTextFile(FileName, True) 'Here we create the file MyCSV.csv
MyBook.Sheets("Now").Select 'Selects sheet containing quotations
If NSENOW = "Yes" Then
For R = 7 To Range("A65536").End(xlUp).Row
[Can we add any command here to find the value from A7 to A65536 only in RTG31.xlsm file]
S = Date & ","
C = 1
While Not IsEmpty(Cells(R, C))
If C = 4 Then
t = Cells(R, C).Value - (Vol(R, 1))
Vol(R, 1) = Cells(R, C).Value
CellValue = t
' Debug.Print Cells(R, 1).Value & t & " - " & Vol(R, 1)
Else
CellValue = Cells(R, C).Value '
End If
S = S & CellValue & "," 'Add contents of current cell to string 's' and a comma
C = C + 1
Wend
a.writeline S 'write line to the file MyCSV.csv

Next R
End If
==========================================================

 

[josh1]

Mr. Josh is it possible to get data from Nest Trader ??

presently using nse now to ami smoothly thanks to u but my friend is using nest trader is it possible to get data from nest to ami ?

Sure ! Linking procedure is same for both

 

[josh1]

Dear sr114,

For R = 7 To Range("A65536").End(xlUp).Row
[Can we add any command here to find the value from A7 to A65536 only in RTG31.xlsm file]

Your query is not clear. You can see the values in Excel sheet.

 

[smarttrade]

If i open (Double Click) any excel file in Live Market Hours (while running in RTG31.xlsm) that new excel file A column (From A7) data also appended in Amibroker Symbol list .

When I try to open excel file thru Start-MSOffice-Excel then working correctly.

Thats y i ask have any method to (Before make csv) find A Column Only in RTG31.xlsm file.

 

[sr114]

Dear sr114,

Thanks for your reply. When I try to open another excel file thru Start-MSOffice-Excel then working correctly . But I ask one more question here . can you help also this ?

==========================================================
Sub MakeCSV()
Dim fs As Object, a As Object, C As Integer, i As Integer, R As Integer, S As String, t As Variant, CellValue As String
'Create a file object for writing
Set fs = CreateObject("Scripting.FileSystemObject")
On Error Resume Next
MkDir ("C:\RT") 'This will create a folder RT in C Drive.
FileName = "C:\RT\MyCSVG.txt" 'This file is used to write quotes
Set a = fs.CreateTextFile(FileName, True) 'Here we create the file MyCSV.csv
MyBook.Sheets("Now").Select 'Selects sheet containing quotations
If NSENOW = "Yes" Then
For R = 7 To Range("A65536").End(xlUp).Row
[Can we add any command here to find the value from A7 to A65536 only in RTG31.xlsm file]
S = Date & ","
C = 1
While Not IsEmpty(Cells(R, C))
If C = 4 Then
t = Cells(R, C).Value - (Vol(R, 1))
Vol(R, 1) = Cells(R, C).Value
CellValue = t
' Debug.Print Cells(R, 1).Value & t & " - " & Vol(R, 1)
Else
CellValue = Cells(R, C).Value '
End If
S = S & CellValue & "," 'Add contents of current cell to string 's' and a comma
C = C + 1
Wend
a.writeline S 'write line to the file MyCSV.csv

Next R
End If
==========================================================

if u get the proper value by clicking start-msoffice, then why u want to query the RTG31.xlm A Col? it will be cumbersome for the xlm file.

sr

 

[milind2754]

In NSE NOW there is limitation of 55 scripts in marketwatch . if i want to get realtime data for more than 55 scripts , then wat's the solution ?

 

[josh1]

In NSE NOW there is limitation of 55 scripts in marketwatch . if i want to get realtime data for more than 55 scripts , then wat's the solution ?

Try paid data providers like e'signal. If you cannot afford to pay their subscription wait till the 55 limit is removed by NSENOW.

 

[labdhi]

sir is there any utility , by which we transfer data from india infoline trader terminal to ami .