How to import "Live Feeds" to F Charts through excel.

MARUTIMANE · #51 19th March 2009, 04:12 AM

Dear Mambers,

I am having ODIN and I am getting data in Exl format but not able to link it throgh web query. I am getting real time data in arbritage.xls which is default format of ODIN, Pleas help how to get web qury in ODIN.

Thanks and regards

Maruti Mane

johnnypareek · #52 19th March 2009, 11:31 PM

HI,

I a unable to c the exel file to select in fchart. i have changed date n tine fonate. opened excel file n the hit intraday in fchart, select excel as source but no excel file is showing in dropdn.
i have office 2007 instaled

johnny

kharikumaar · #53 21st March 2009, 01:14 PM

A point to note here. I was noticing a lot of people getting the "13 : type mismatch". error.

for few who have been trying Ranjits excel sheet and trying to connect to Fcharts using the instruction given by annirudh. making the following changes may help . you have to change the column identification of B for date and C for time to "C & D ". Close as " E" and volume as "F".

as seen in the attachment

12. 1st Data Row = Row of the first company  Put appropriate column names eg: A, B, C, etc for Ticker, Date, Time, etc  Select Subtract Volume  Open Feed At Startup.

narayanatrader · #54 21st March 2009, 04:27 PM

Its great, its working...
Thankyou

murthymsr · #55 21st March 2009, 07:30 PM

Dear Ranjit,

You may please add a HELP sheet to your application and re-post as the next version for the benefit of all.

Thanks.
murthymsr

kharikumaar · #56 21st March 2009, 10:58 PM

One more enquiry.
would it be possible to import index futures into the charts?

murthymsr · #57 21st March 2009, 11:28 PM

Quote:

Originally Posted by kharikumaar

One more enquiry.
would it be possible to import index futures into the charts?

Quote:

..................................
17. Enjoy free Intraday Feed for Nifty Stocks, similar process can be applied for F&O, Commodities etc.

Please feel free to ask any questions……

Aniruddha Deshpande
Reply With Quote

Yes, it is possible. Please refer to the first post in this thread, abstracted for your ready reference.

You may add another webquery for this and post the same for for the benefit of others.

Regards.
murthymsr.

kharikumaar · #58 22nd March 2009, 12:12 AM

dear mr.murthy,

i tried to initiate another web query. and save what i got from the site. now i dont now what is the symbol to be given for fchart to recognize future contracts.

i am attaching the excel file i got from nse. if theres another method please advise

murthymsr · #59 22nd March 2009, 08:27 AM

Quote:

Originally Posted by kharikumaar

dear mr.murthy,

i tried to initiate another web query. and save what i got from the site. now i dont now what is the symbol to be given for fchart to recognize future contracts.

i am attaching the excel file i got from nse. if theres another method please advise

Dear kumar,

As I have NO experience with FnO, I cannot give any firm answer.

However, what FCharts wants is a UNIQUE name as a ticker, price, date,time and volume if available for preparing a chart.

The UNIQUE name in this case may have to be 'fabricated' by combining underlying_security+expiry_date+option_type+strike _price.

The resultant tickers may be like:

NIFTY_03
NIFTY_03_CE_2800
NIFTY_03_PE_2800

I tried to answer more than what I know !

murthymsr

The Examples:

murthymsr · #60 24th March 2009, 08:43 PM

Quote:

Originally Posted by johnnypareek

HI,

I a unable to c the exel file to select in fchart. i have changed date n tine fonate. opened excel file n the hit intraday in fchart, select excel as source but no excel file is showing in dropdn.
i have office 2007 instaled

johnny

Dear John,

1) Open FCharts first and complete the other configuration.

2) Open the Excel sheet.

3) FCharts 'Refill List' can be done at this stage.

Whenever Excel sheet is updating, you will not be able to pick up in FCharts Live data window. You may try a few times.

Alternatively, you may set the refresh rate in the web query / web queries to a high value till the excel sheet is picked up.

murthymsr

The Following 2 Users Say Thank You to kharikumaar For This Useful Post:
murthymsr (21st March 2009), Sgpal (3rd April 2009)