Username:  Password:
Forgot your username or password?        
     
Home Product Tour FAQ Forum Contact Us Download           
MySF Forums
Home       Calendar
        



Importing Revaluation data for unlisted... Expand / Collapse
Author
Message
Posted 14/06/2012 9:07:05 PM
Regular Member

Regular MemberRegular MemberRegular MemberRegular MemberRegular MemberRegular MemberRegular MemberRegular Member

Group: Forum Members
Last Login: 20/06/2017 1:51:36 PM
Posts: 15, Visits: 64
I created a new exchange using the configuration > exchange tab - and I called it 'Unlisted'. I then associated my unlisted assets with this exchange. I tried to import a revaluation file but my unlisted assets were ignored. This is probably because I can not assign the asset code to the Exchange I created within the configuration>exchange window.

It would be good if MySF had a default exchange name such as 'Unlisted'. Any revaluation data that was associated with this Exchange would then be revalued if there was a fund asset with that code. There would be NO requirement for this asset code to exist under the exchange.

More generally, it might be nice if MySF would revalued the asset as long as it exists in the fund irrespective of whether the code exists in the Exchange table. Your preview could give a warning (currently it does not!)
Post #4817
Posted 30/06/2012 6:15:33 PM


MySF Administrator

MySF AdministratorMySF AdministratorMySF AdministratorMySF AdministratorMySF AdministratorMySF AdministratorMySF AdministratorMySF Administrator

Group: Administrators
Last Login: 26/07/2017 11:15:18 PM
Posts: 254, Visits: 1,078
Hi,

We'll need to test this further.

The automated revaluation feature definitely should ignore unlisted assets as the data feed requires the exchange in order to retrieve price histories.

For importing a price data file, you can set the Suffix of your 'Unlisted' exchange via Configuration > Exchanges and then in your data file ensure that all of the assets associated with this exchange have this suffix.

For example, if I were importing all price data for the ASX, I would ensure they had a suffix of .AX.

Regards,

MySF
Post #4818
Posted 3/07/2012 4:01:59 AM
Regular Member

Regular MemberRegular MemberRegular MemberRegular MemberRegular MemberRegular MemberRegular MemberRegular Member

Group: Forum Members
Last Login: 20/06/2017 1:51:36 PM
Posts: 15, Visits: 64
What I did was what you stated. For example, the import CSV file was of the format -
CFS452,UL,20/06/2012,0.86
and the suffix UL was defined in the exchanges table.
and the asset CFS452 was associated with the exchange corresponding to UL.
The Data preview table says, CFS452.UL will be revalued ...
However, when submitting the revaluation - it completes but advises that no assets have been revalued.
Post #4819
« Prev Topic | Next Topic »



All times are GMT -6:00, Time now is 8:55pm

Powered by InstantForum.NET v4.1.4 © 2018
Execution: 0.125. 9 queries. Compression Disabled.