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

[josh1]

Hi Josh

where can i find way to get the feed from NOW to Fchart?

Thanks

It is given in first six pages of this thread.

 

[josh1]

Hi Joshi,
Sorry forgot to add format files, added them but now its connecting to amibroker and opening another instance of it, so i am getting 2 instances of amibroker running. What should i do ?

Regards

Use whichever instance you want :lol:

 

[bestnifty]

Dear Sr114 ,
is there any improvements to feed Metastock ?

 

[sr114]

Dear Sr114 ,
is there any improvements to feed Metastock ?

read in the thread abut kanitkar's response for data in metastock. he has done the coding along with josh

regds
subroto

 

[sr114]

Best eod software is in market now" excella trader"

r u serious? is it better than Amibroker or Metastock?

can u substantiate ur claim with any proof?

pls do so - we r waiting?

 

[reenumlk]

Hi sr114, can you please share your semi automatic backfilling trick (excel file etc.) for current day from hourly statistics data of NOW, bcoz we mostly need current day backfilling and backfill from nest plus is very irritating, you know.

thanks in advance

 

[sr114]

Hi sr114, can you please share your semi automatic backfilling trick (excel file etc.) for current day from hourly statistics data of NOW, bcoz we mostly need current day backfilling and backfill from nest plus is very irritating, you know.

thanks in advance

do 1 thing - get the data from Hourly stat in NOW and see the data format. keep the required ones and discard the unnecessary.

Save it in excel csv format.

now the necessary part
write a macro to keep the necessary data and discarding the unnecessary data part . so on next time use that macro to get the proper backfill data.

in ami, import ascii , define a format file

so while u do the import - it will take very little time for conversion and import

[this part u have to do]

putting a macro for u - see what can be used here, record this macro after proper editing and use it. this macro is used mainly in DIET ODIN data conversion - make it fit for NOW backfill data ( i cud help up to this as i dont have any NOW hrly stat data with me as i use Nest Trader and there data is properly formatted - u only have to convert the data and time component)

Sub ......()
'
'
'
' Keyboard Shortcut: Ctrl+q
'
Columns("B:C").Select
Selection.Copy
Columns("F:F").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Columns("F:F").Select
Selection.Cut
Application.CutCopyMode = False
Selection.Copy
Columns("D").Select
ActiveSheet.Paste
Columns("C:C").Select
ActiveSheet.Paste
Columns("E:E").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Columns("A:A").Select
Selection.Copy
Columns("B:B").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Columns("A:A").EntireColumn.AutoFit
Columns("B:B").EntireColumn.AutoFit
Columns("A:A").Select
Selection.NumberFormat = "dd/mm/yyyy"
Columns("B:B").Select
Selection.NumberFormat = "HH:mm:ss"
Range("B1").Select
ActiveCell.FormulaR1C1 = "Time"
Range("C1").Select
ActiveCell.FormulaR1C1 = "Open"
Range("D1").Select
ActiveCell.FormulaR1C1 = "High"
Range("E1").Select
ActiveCell.FormulaR1C1 = "Low"
Range("F1").Select
ActiveCell.FormulaR1C1 = "Close"
Range("G1").Select
ActiveCell.FormulaR1C1 = "Volume"
Range("G1").Select
CopyToCSV
End Sub

regds
subroto

 

[reenumlk]

Thanks sr for quick reply, will try to do this and revert back if there any problem happens.

 

[josh1]

Navin Bhatia,

You PM for help on Teamviewer. Then you keep your TV offline and also your own PM off. How am I supposed to help you?

regards
Josh1

 

[happy1]

do 1 thing - get the data from Hourly stat in NOW and see the data format. keep the required ones and discard the unnecessary.

Save it in excel csv format.

now the necessary part
write a macro to keep the necessary data and discarding the unnecessary data part . so on next time use that macro to get the proper backfill data.

in ami, import ascii , define a format file

so while u do the import - it will take very little time for conversion and import

[this part u have to do]

putting a macro for u - see what can be used here, record this macro after proper editing and use it. this macro is used mainly in DIET ODIN data conversion - make it fit for NOW backfill data ( i cud help up to this as i dont have any NOW hrly stat data with me as i use Nest Trader and there data is properly formatted - u only have to convert the data and time component)



regds
subroto

Subroto: How u do that in Nest Trader