Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 6/16/2006(UTC)
Posts: 47
Location: Italy
Thanks: 6 times
|
Ciao a tutti, I was going to create a formula which divides a daily data (index daily values) by a monthly data (earnings). Obviously, MS doesn't allow me to do so, 'cause data periodicity is not the same for the two data items. Is there anyone who engineered some solution to this task, other than converting monthly values on a daily basis with the help of a spreedsheet (rather noisy task, in any case)?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/13/2005(UTC)
Posts: 715
Location: Midwest, USA
Was thanked: 1 time(s) in 1 post(s)
|
This should let you do that: http://www.metastockcsv.com/. You can keep earnings data in a *.CSV file, using Excel, and use MetaStockCSV to read it directly in an Indicator formula.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
You can also create a new security with daily resolution containing your data, then call this using the Security() function, or a more abstract way, use the "spare" data item in the MS data format i.e. OI to store your earnings data with the price and volume data.
wabbit [:D]
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 6/16/2006(UTC)
Posts: 47
Location: Italy
Thanks: 6 times
|
wabbit wrote:You can also create a new security with daily resolution containing your data, then call this using the Security() function
Hi Wabbit, how can I convert my monthly data file into a new daily one? Thks
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Export the monthly data to something like Excel, then create a complete list of daily dates and use the lookup functions in Excel to insert the monthly values to the respective position for each date, save as required and use the Downloader to convert the file to MS format.
wabbit [:D]
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
