General Trading Chat

[TracerBullet]

Just like in josh utility you just read the stock updated numbers in excel and display graph in amibroker. Can the combined number generated by excel forumlae just be drawn as graph in amibroker.... Just thought you might now since you ve done an RTD utility. I guess you are reading data from now/nest and feeding it to an amibroker database. The plus here is that amibroker has its own database and every min data will be stored and graph generated.

Other approach I can do is draw graph from excel or I can read data from mysql populate in array and then draw graph using. http://phpchart.org/

The main question is how do I take data from now/and store it in my excel or database at real time

I found a way to do it.
Loop php scrip every 5 seconds. I am going to use php excelreader to read excel data and then plot the data in array using phpgraph. Sounds exciting.

Simply call the AB import COM call from excel using VBA as done by josh's Nest Excel Tool. You may have to use timer to do it periodically or on an event triggered by RTD update.

You can push extra data to Amibroker using aux fields or simply make a dummy script name and push it as its price.

PHP server i think would be overkill but do it for fun You can even draw the chart in excel itself, just google excel charts.

 

[lemondew]

Next weeks interesting

Next week :

Jan 26,2015 : Republic Day holiday.
Jan 27: Markets will move post modi obama meet

Jan 27,2015 : We will open to news/results of Greece Elections.
Jan 28 Not sure if this will effect indian markets

Jan 28,2015 : USD Federal Open Market Committee Rate Decision - which will have its effect on the expiry day of Nifty Jan series :thumb:
Jan 29, 2015: Post FOmc meet + Expiry

 

[RAAMAKANT]

50 Billion Euro's per month bond buying is what is expectations from ECB...

If comes this much then no big reactions for market as that much is almost discounted...

but if comes higher or lower than this then expect surprised reactions on either side.....

 

[sudoku1]

50 Billion Euro's per month bond buying is what is expectations from ECB...

If comes this much then no big reactions for market as that much is almost discounted...

but if comes higher or lower than this then expect surprised reactions on either side.....

bt befor dat..traders r fueling up 9000 CA buying :-D

 

[Taiki]

Simply call the AB import COM call from excel using VBA as done by josh's Nest Excel Tool. You may have to use timer to do it periodically or on an event triggered by RTD update.

You can push extra data to Amibroker using aux fields or simply make a dummy script name and push it as its price.

PHP server i think would be overkill but do it for fun You can even draw the chart in excel itself, just google excel charts.

Dear TracerBullet,

I have been using Josh's excel utility as my datafeed to Ami since long time. Had tried to create my own utility in dot net sometime back. But could not find any success to implement the RTD server in dot net.

Reason behind this attempt is -

1. All in one downloader to download EOD, IEOD (1M/5M) data for 100+ scrip, and intraday data feed for for selected scrips with a nice GUI.
2. Due to looping in excel to read data, few ticks are missed in between..
3. want to get rid of memory heavy excel.

Do you have any idea if this can be done in dot net or any other ways to achieve it,,?? Thinking of giving it a retry now..

Regards
Taiki

 

[niftychartreader]

The last 30 minutes gave market the required upthrust

 

[Smart_trade]

ECB has kept the interest rates unchanged.

ECB will start purchasing Govt bonds worth 60 billion Euros per month starting from March.Volatility expected in the world markets.

Positive development for Global and Indian markets.

Smart_trade

 

[niftychartreader]

Draghi announces 60 bn euro/month QE programme
Moneycontrol Bureau

The European Central Bank announced higher than expected monthly bond buying programme amounting to 60 billion euro till September 2016. It, however, kept benchmark interest rate unchanged. Announcing the extent of Quantitaive Easing, ECB chief Mario Draghi also said the central bank will work towards the objective of bringing inflation closer to 2 percent.

The ECB kept benchmark rate unchanged at 0.05 percent and left both marginal facility interest rate and deposit facility rate intact at 0.3 percent at -0.2 percent, respectively.

Policymakers attending the World Economic Forum in Davos were certain that ECB would announce a QE —street was pegging iot lower at 50 billion euros per month — but remained skeptical of its success. Speaking to CNBC-TV18 in Davos, Jan Lambregts, Director, Head of Research (Asia) at Rabobank said he does not expect the ECB to give a full-fledged plan today.

Federal Reserve's three rounds of QE theoritically suggests the exercise would pump up stocks, commodities and bond yields leading to some real economic growth. If Draghi goes for it, he is expected to roll out similar initiatives instead of stopping at one.

ECB's bond-buying programme is expected to push the dollar to new highs and put downward pressure on commodities including crude.

link
http://www.moneycontrol.com/news/economy/draghi-announces-60-bn-euromonth-qe-programme_1281590.html

 

[Smart_trade]

In my view the ECB decision is more likely to be in favour of bulls...let us see what Mr Dragi does...

ST

Looking at the current situation Mario Draghi had limited choice.

ST

 

[Smart_trade]

ECB decision will benefit Indian markets too. Bond purchases of 60 billion Euros will keep the tap of liquidity in European markets open. This in turn will help FII liquidity flowing in emerging markets . The fear of FIIs pulling out money will now be less...in fact FIIs will pour more money in emerging markets and India will be a major beneficiary of this policy.

Smart_trade