Click here to Login








Average Daily Return per Year/Month Table

by QuantShare, 4663 days ago
Share |






Using the pivot table tool of QuantShare, I have created a table that shows the average daily return of a security per month and per year. The table displays years as rows and months as columns and calculates the average daily return for every cell (year/month). The daily return is calculated using the open and close prices (The intraday percentage change from open to close). A cell is colored in red when the average daily profit is negative and it is colored in green when the average daily profit is positive.

Above the table, you can change the active symbol to refresh the table.

You can also perform calculations based on the active trading chart (each time you change a chart or chart's symbol the table will be updated automatically):
- Right click on the pivot table
- Select "Active Symbol Settings"
- Select "Active Chart Symbol"

Note that to add this pivot table, you must first open or create a new dashboard (Tools -> Dashboard). After that, right click on the Dashboard to add the pivot table.

To update the analysis period, right click on the pivot table, select "Update Rows/Columns/Values", update the start and end dates in the "Select Dates" panel.



Share This ->
Share |


You have to log in to bookmark this object
What is this?




Type: Pivot Table

Object ID: 1103


Country:
All

Market: All

Style:
Technical Analysis

Reviews
You must log in first

Join now
and get instant access for free to the trading software, the Sharing server and the Social network website.
Click here


Related objects

Empty

Number of reviews
Click to add a review
Average rate
Click to rate this item
Number of times this object was downloaded
Number of rates the current object received
Report an object
if you can't run it for example or if it contains errors
Click to report this object

Technical Analysis


Fundamental Analysis



Random Blog Posts

6 techniques to improve the performance of your stock trading strategy

Trading System: Buy stocks with the highest Sharpe ratio

Create indicators, composites and trading systems using QL and CSharp

Custom Indicator: Accumulation Distribution Line

Custom Indicator: Relative Strength

Custom Indicator: Moving average spread

The custom trading indicators tool explained

Diversify your portfolio by investing in stocks from various industries

Show All

Number of reviews
Click to add a review
Average rate
Click to rate this item
Number of times this object was downloaded
Number of rates the current object received
Report an object
if you can't run it for example or if it contains errors
Click to report this object






QuantShare
Product
QuantShare
Features
Create an account
Affiliate Program
Support
Contact Us
Trading Forum
How-to Lessons
Manual
Company
About Us
Privacy
Terms of Use

Copyright © 2024 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
Follow us on Google+
RSS Trading Items



Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.