logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
ageitalia  
#1 Posted : Wednesday, December 12, 2012 10:58:17 AM(UTC)
ageitalia

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)?

jjstein  
#2 Posted : Wednesday, December 12, 2012 1:09:54 PM(UTC)
jjstein

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.

wabbit  
#3 Posted : Wednesday, December 12, 2012 4:03:04 PM(UTC)
wabbit

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]

ageitalia  
#4 Posted : Thursday, December 13, 2012 9:51:10 AM(UTC)
ageitalia

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

wabbit  
#5 Posted : Thursday, December 13, 2012 3:59:48 PM(UTC)
wabbit

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