Loss of Attributes in RM Drop Down

SkyTrader

Hi there,

I've raised this question before in other threads relating to other topics/processes but not had a solution that has permanently resolved it and would like to add it here as it's own topic.

When I first started using RM a few months ago the attribute drop down alway showed me what was in my Dow Jones, FTSE, or £/$ Excel data files. By that i mean if I wanted to select an attribute from my file in RM there would be a long list of attributes like open, high, low, close, EMA, RSI, etc, that I could select.

This functionality is now no longer available. I have done two updates since I first used RM. All I get, using any of my processes, when trying to retrieve a data set, is blank drop downs empty of any Excel attributes. I have tried a myriad of "solutions" including re-importing the data files, deleting Retrieve and Read Excel operators from processes, deleting Excel files from RM and reimporting all to no avail.

Even writing in "close" still makes not difference? I can say with 100% certainly that close exists in my file and is written exactly as "close" (and without any special characters attached to the word as occurred with one Yahoo Finance FTSE download, that attached an asterisk to the close, i.e. it read as: close* in my Excel file, therefore meaning RM could not recognise the attribute "close" from my typed in "close" suggestion.

Here's a screenshot of one of many I've got:



Can someone please give me a permanent solution so I can get back to using RM in the manner it was designed and which I first encountered it?

Many thanks!

MartinLiebig

Hi,

You have a very clear error message. The column does not exist in your data. It is that simple. This is not at all a bug or something. If you do not post data and processes is it impossible to diagnose what you did wrong.

~Martin

SkyTrader

Hi Martin, @mschmitz

Happy to post processes etc, but just for now, this is what I just did:

1) Delete Excel file in repository.

2) Import Data:


3) Close appears in Example Set:


4) Set Close to Label:


5) Click on Next -- and complete import:


6) Go to Retrieve and select new import file:
This is where it's going wrong. The Close doesn't exist?


7) Windowing operator has blank attributes despite screenshot above showing they exist (albeit without the Close!):



8) Enter the word "Close" :



I'm pretty certain the attribute exists so what can I do?

Many thanks,

MartinLiebig

Hi @SkyTrader ,

the error message is explicitly telling you what your error is. Close is a special attribute (label) you need to check "include special attributes"as aparameter.

Also note, that you used "close" not "Close" for horizon attribute.

Best,

Martin

SkyTrader

Cheers Martin, @mschmitz
"Include special attributes" fixed half the problem. How do I get the attributes drop down menus to self populate with attributes (that are in my Excel files) and avoid warning like this:



This process above was derived from a YouTube video on Rm that doesn't use Set Role:




Thanks again,
Best,
SkyTrader

MarcoBarradas

@SkyTrader the only way of not obtaining that error with the process you show is by setting the role of your attribute as label while importig the data to RM. The other way of doing that is by setting the Role with the Set Role operator and picking th attribute which you want your model to predict since its needed for the models to learn a solution.

Best Regards 

MartinLiebig

@SkyTrader ,

can you please check if "Validate Automatically" is checkmarked?

Best,

Martin