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

[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

 

[kharikumaar]

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]

Its great, its working...
Thankyou

 

[murthymsr]

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]

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

 

[murthymsr]

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

..................................
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]

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]

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]

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

 

[RANJITSINGH66]

Dear murthy sir,
as per your advice I will post a new version of LIVE DATA RANJIT excel file with a help file very soon.The SIZE of help file is more than 324KB.please guide me as to how i can post it.
thanks and regards.
RANJITSINGH66